Senior Business Solution Specialist II - Data & Reporting (SQL/Python/AWS)
Full-time
The Citco Group Limited
About Citco JOB DESCRIPTION The market leader. The premier provider. The best in the business. At Citco, we’ve been the front-runner in our field since our incorporation in 1948 led to the evolution of the asset servicing sector itself. This pioneering spirit continues to guide us today as we innovate and expand, push beyond the boundaries of our industry, and shape its future. From working exclusively with hedge funds to serving all alternatives, corporations and private clients, our organization has grown immensely across asset classes and geographies. For us, this progress is a pattern that we’ll only maintain as we move forward, always prioritizing our performance. So for those who want to play at the top of their game and be at the vanguard of their space, we say: Welcome to Citco. About The Team & Business Line Citco Fund Services is a division of the Citco Group of Companies and is the largest independent administrator of Hedge Funds in the world. Our continuous investment in learning and technology solutions means our people are equipped to deliver a seamless client experience. This position reports in to the Loan Services Business Line As a core member of our Loan Services Data and Reporting team, you will be working with some of the industry’s most accomplished professionals to deliver award-winning services for complex fund structures that our clients can depend upon. Responsibilities Your Role:
- Develop and execute database queries and conduct data analyses
- Create scripts to analyze and modify data, import/export scripts and execute stored procedures
- Model data by writing SQL queries/Python codes to support data integration and dashboard requirements
- Develop data pipelines that provide fast, optimized, and robust end-to-end solutions
- Leverage and contribute to design/building relational database schemas for analytics. Handle and manipulate data in various structures and repositories (data cube, data mart, data warehouse, data lake)
- Analyze, implement and contribute to building of APIs to improve data integration pipeline
- Perform data preparation tasks including data cleaning, normalization, deduplication, type conversion etc.
- Perform data integration through extracting, transforming and loading (ETL) data from various sources.
- Identify opportunities to improve processes and strategies with technology solutions and identify development needs in order to improve and streamline operations
- Create tabular reports, matrix reports, parameterized reports, visual reports/dashboards in a reporting application such as Power BI Desktop/Cloud or QLIK
- Integrating PBI/QLIK reports into other applications using embedded analytics like Power BI service (SaaS)
- Building and Designing cloud applications using Microsoft Azure/AWS cloud technologies
- 5+ Years in Financial Services / Financial Technology with a primary focus on loans/credit products
- Bachelor’s Degree in technology/related field or equivalent work experience
- 4+ Years of SQL and/or Python experience is a must
- Strong knowledge of data concepts and tools and experienced in RDMS such as MS SQL Server, Oracle etc.
- Well-versed with concepts and techniques of Business Intelligence and Data Warehousing
- Strong database designing and SQL skills. objects development, performance tuning and data analysis
- In-depth understanding of database management systems, OLAP & ETL frameworks
- Familiarity or hands on experience working with REST or SOAP APIs
- Well versed with concepts for API Management and Integration with various data sources in cloud platforms, to help with connecting to traditional SQL and new age data sources, such as Snowflake
- Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI) is an advantage
- Hands-on experience at least in one ETL tool (SSIS, Informatica, Talend, Glue, Azure Data factory) and associated data integration principles is an advantage
- Experience of a range of debt product types - including, but not limited to, syndicated (par & distressed), bilateral, direct lending originations, commercial real estate loans – is preferred but not essential
- Minimum 1+ year experience with Cloud platform technologies (AWS/Azure), including Azure Machine Learning is desirable. Following AWS experience is a plus:
- Implementing cloud storage using Amazon Simple Storage Service (S3)
- Experience with serverless approaches using AWS Lambda, e.g. AWS (SAM)
- Configuring Amazon Elastic Compute Cloud (EC2) Instances
- Experience querying databases and strong programming skills: Python, SQL, PySpark etc.
- Prior experience supporting ETL production environments & web technologies such as XML is an advantage
- Previous working experience on Azure Data Services including ADF, ADLS, Blob, Data Bricks, Hive, Python, Spark and/or features of Azure ML Studio, ML Services and ML Ops is an advantage
- Experience with dashboard and reporting applications like Qlik, Tableau, Power BI
- Well rounded individual possessing a high degree of initiative
- Proactive person willing to accept responsibility with very little hand-holding
- A strong analytical and logical mindset
- Demonstrated proficiency in interpersonal and communication skills including oral and written English
- Ability to learn new platforms and source information from numerous systems
- Ability to work in fast paced, complex Business & IT environments
- Knowledge of Loan Servicing and/or Loan Administration
- Understanding of Agile/Scrum methodology as it relates to the software development lifecycle
Vacancy posted 13 hours ago
Similar jobs that could be interesting for youBased on the Senior Business Solution Specialist II - Data & Reporting (SQL/Python/AWS) in Manila vacancy
130000 - 150000 Php
...Pax8 is hiring a Data Automation Engineer (Python and SQL) in Makati, Philippines... ...meets real business impact. As a Data Automation... ...full stack solutions (dashboards, APIs,... ...tooling in addition to AWS is a plus. ~ Strong... ...potential. Alongside specialist Learning &...- ...implementations depend on providing clients with the quality reporting they need to run their business smoothly. You will work in a flexible, friendly, and... ...documents into reliable and useful converted data. As our SQL Reports Developer, you will analyze and map source...
- ...passionate about designing innovative AWS solutions that solve complex business challenges? Would you like to... ...customers, sales teams, and delivery specialists to design and implement secure,... ...transformation initiatives, including data center modernization, cloud migrations...
- ...the Role We are seeking a hands-on Senior Agentic AI Engineer to design,... ...and distributed AI workflows using AWS Bedrock, AgentCore, LangGraph, Python, and FastAPI. This role requires strong... ...practical experience deploying agentic AI solutions in production environments. Key...
- ...to build and maintain solutions that connect business systems, automate repetitive... ...strong, practical Python development experience, along with SQL, API integration, and... ...process automation, data processing, and system... ...classification, ticket triage, and reporting. Monitor,...
- ...distribution of data, through responsible... ...and innovative solutions. Through our... ...data solutions specialist. Role... ...Trade and pre-Trade business activity. The... ...is deployed on AWS. Role Responsibilities... ...Experience with SQL and database... ...with MAR, MIFID II or similar...
- ...Own data pipeline development... ...Write efficient SQL, Hive queries, and Python code. Apply distributed... ...Build and manage AWS workflows: Develop... ...support data solutions using Amazon S3,... ...Ability to translate business requirements... ...data, campaign reporting, or customer analytics...
- ...seeking a highly skilled Senior Data Engineer to join our growing Data and AI solutions team. This role... ...downstream analytics and reporting. Implement data governance... ...(preferably GCP, but AWS/Azure acceptable). ~... ...abilities in Python , SQL , and NoSQL databases...
- ...Job Description FOCUS AREA | DATA, REPORTING & PLATFORM ENABLEMENT Senior Vice President, Data, Reporting &... ...administration, we deliver end-to-end solutions and exceptional service to meet... ...please visit About The Team & Business Line Fund Administration is...
- Data Scientist – Mid-Level / Senior Leading Global Financial... ...data and AI solutions that support... ...that deliver business value. We... ...with analytics specialists, software engineers... ...in Python , including... ...knowledge of SQL , relational... ...platforms such as AWS or Azure, and...
- ...thrive. What you’ll be doing: - Provide data-driven strategic consulting to... ...stakeholders to elicit requirements, evaluate business needs, and deliver solution recommendations through formal... ...contact center analytics - Proficiency in SQL query building - Analytic thinker...
- ...Overview LevelUp is a specialist agency that provides outsourcing solutions to agencies,... ...detail-oriented, and data-driven Data Analytics & Revenue Reporting Specialist to drive... ...financial data analysis, business intelligence, or... ..., CAC). - Advanced SQL & Big Data: Strong...
- ...build the technology that helps businesses and communities thrive. Join... ...a Production Support Analyst II, you will support live software... ...Microsoft Windows, Microsoft SQL Server, networks and cloud-hosted... ...to effective, lasting solutions. Support application releases...
- .... About the Role The Senior Solutions Consultant provides strategic... ...customers to understand their business challenges and objectives.... ...Practical experience with Azure or AWS environments. Software... ...using tools like PowerShell and SQL. Level of Authority...
- ...in-depth analyses of relevant data and information. Your work... ...opportunities. Prepare comprehensive reports and presentations that... ...-related issues impacting business processes and operational efficiency... ...languages such as Excel, SQL, Python, or R ~ Knowledge of data...
- ...About the role We are looking for a highly skilled Senior Solutions Designer with strong expertise in AWS Data Engineering, Cloud Data Architecture, and... ...Data API platforms. This role involves translating business requirements into technical solutions while collaborating...
- ...analytics and models that support business decisions, is growing and is hiring a senior data engineer to help own and scale... ...will be trusted to architect solutions independently, ingest data reliably... ...). ~ Strong proficiency in Python and SQL. ~ Hands-on experience with...
- ...Overview: As a Lending Business Specialist , you will use your... ...the Business through data-driven insights and solutions to achieve organizational... ...Deliver management reports and analytics periodically... ...languages (R, Python, NumPy, MatLab, SQL) is an advantage Strong...
- ? Business Data Analyst (Billing) | Philippines | Pax8... ...? Define, manage, and report operational objectives... ..., retrospectives, and solution discovery sessions focused... ...Working knowledge of SQL and data-driven decision... ...potential. Alongside specialist Learning & Development...
- ...transformation to as-a-Service business models. DysrupIT is... ...Summary We are seeking a Senior Data Engineer to own the ingestion... ...BigQuery expertise and strong Python and SQL skills. You will design robust... ...processes to detect, isolate, and report invalid or incomplete source...
- ...About the role The Solutions Designer has deep knowledge of enterprise platforms technologies, practices, and procedures as well as knowledge of business processes. They rely on their expertise, experience and judgment, both on the business aspect and the enterprise...
- ...Senior Python Backend Engineer Location: Manila, Philippines Work Mode: Hybrid Experience: 6–8 Years Shift Timings: 3:30 PM... ...asynchronous applications. Pydantic: Request/response models and data validation. PostgreSQL: Database design, querying, and...
- ...Description Develop ad hoc analyses or reports and communicate insights to business teams. Capture high-level and... ...and collaborate on reporting and data-related projects. Provide... ...advanced Microsoft Excel and SQL skills (Python a plus) Detail-oriented and has...
- ...Experience ~8+ years of Data Engineering experience with expertise... ...designing and building scalable data solutions. ~ Willing to work in a... ...setup. Technical Skills Python: Strong proficiency (4/5 or higher). SQL: Intermediate to advanced proficiency...
- ...in team-based, strategy and solutions work. In all models, you will... ...journals, allocations, monthly reporting, issue resolution). ·... ...accuracy, and validity of financial data. · Provide sound financial... ...to team members and business partners. · Support the Team...
- ...About the role The Solutions Specialist solves operational and technical workflow challenges... ...teams and clients to translate business requirements into reliable... ...Google Apps Script solutions for data processing, validation, reporting, and operational efficiency Research...
- ...professional to join our Market Data Services team as a full-time... ..., Product and Client Support business units. The output of the... ...are pluses Experience with SQL, Python or other object-oriented... ...integrated investment management solutions. We are 3,000+ colleagues with...
- ...Global As a Consulting Solution Architect for the Data Management domain , you... ...on client needs. The role reports to the Global Practice Lead... ...Interface with clients, including senior stakeholders, on custom... ...Mathematics or a relevant Business degree At least 7+...
- ...and consultancy solutions for natural and built... ...Software Support Specialist II Automation... ...using PowerShell, Python, Power Platform,... ...deployment, monitoring, reporting and governance... ...knowledge workflows, data lookups and... ...Engineering Applications, business systems,...
- ...About the role The Senior Business Analytics Analyst will... ...Smartly uses business data. This person will focus... ...including executive metrics reporting, company OKR tracking,... ...field Strong SQL skills, ideally including... ...experience with Python Experience building...
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Senior Business Solution Specialist II - Data & Reporting (SQL/Python/AWS). Be the first to apply!
