Senior Data & Reporting Engineer (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 14 hours ago
Similar jobs that could be interesting for youBased on the Senior Data & Reporting Engineer (SQL/Python/AWS) in Manila vacancy
130000 - 150000 Php
...Permanent Night Shift Schedule (10pm - 6am) Pax8 is hiring a Data Automation Engineer (Python and SQL) in Makati, Philippines to help shape the future of... ...Jira, Kubernetes and Docker tooling in addition to AWS is a plus. ~ Strong understanding of observability principles...- ...Eastern Time About the Role We are seeking a hands-on Senior Agentic AI Engineer to design, develop, integrate, and optimize... ...scalable, secure, and distributed AI workflows using AWS Bedrock, AgentCore, LangGraph, Python, and FastAPI. This role requires strong software...
- ...are seeking a highly skilled Senior Data Engineer to join our growing Data... ...support downstream analytics and reporting. Implement data... ...platforms (preferably GCP, but AWS/Azure acceptable). ~... ...programming abilities in Python , SQL , and NoSQL databases, with...
- ...Responsibilities: Own data pipeline development:... ...: Write efficient SQL, Hive queries, and Python code. Apply... ...Build and manage AWS workflows: Develop and... ...team: Guide 2-3 engineers, break requirements into... ...audience data, campaign reporting, or customer...
- .... Job Summary We are seeking a Senior Data Engineer to own the ingestion, data model, and... ...with deep BigQuery expertise and strong Python and SQL skills. You will design robust,... ...quarantine processes to detect, isolate, and report invalid or incomplete source data....
- ...Senior Python Backend Engineer Location: Manila, Philippines Work Mode: Hybrid Experience: 6–8 Years Shift Timings: 3:30 PM – 12:30... ...asynchronous applications. Pydantic: Request/response models and data validation. PostgreSQL: Database design, querying, and...
- ...implementations depend on providing clients with the quality reporting they need to run their business smoothly. You will work in a... ...and mapping documents into reliable and useful converted data. As our SQL Reports Developer, you will analyze and map source data, write...
- ...that support business decisions, is growing and is hiring a senior data engineer to help own and scale the data platform underpinning our... ...solely research or prototype work). ~ Strong proficiency in Python and SQL. ~ Hands-on experience with cloud platforms. ~...
- ...Experience ~8+ years of Data Engineering experience with expertise in ETL/ELT, data pipelines, and cloud-based data... .../project based setup. Technical Skills Python: Strong proficiency (4/5 or higher). SQL: Intermediate to advanced proficiency (3/5 or higher...
- ...This role requires strong, practical Python development experience, along with SQL, API integration, and business... ...for business process automation, data processing, and system integration... ...classification, ticket triage, and reporting. Monitor, troubleshoot, and maintain...
- ...Specializing in IT and software engineering, we drive innovation in... ...years of professional data engineering experience,... ...-ready datasets. Senior-level hands-on... ...Databricks, PySpark, Spark SQL, Delta Lake, and SQL.... ...business-facing datasets for reporting, analytics, and...
- ...career aspirations. Job Summary We are seeking an Engineer with 3+ years of Python data or backend experience to build the configuration, services... ...and generating business-ready outputs, including Excel reports. The ideal candidate writes well-tested, type-checked...
- ...experienced and results-driven Data Engineer to join our dynamic... ...modeling, and modern AWS data services, we want... ..., PostgreSQL, and MS SQL . Cloud &... ...and backend scripts in Python or Java . BI & Analytics... ...and advanced analytics reporting. Data Governance: Drive...
- ...implement scalable cloud-based solutions using AWS services. Develop and maintain machine... ...Bachelor’s degree in Computer Science, Engineering, or a related field. Experience Level:... ..., and programming languages such as Python or Java. Responsibilities and Duties:...
- ...Job Description FOCUS AREA | DATA, REPORTING & PLATFORM ENABLEMENT Senior Vice President, Data, Reporting & Platform Enablement Global | Permanent About Citco Citco is a global leader in fund services, corporate governance and related asset services with...
- ...in-depth analyses of relevant data and information. Your work... ...opportunities. Prepare comprehensive reports and presentations that... ...Management, Industrial Engineering, Statistics, Management Engineering... ...languages such as Excel, SQL, Python, or R ~ Knowledge of data visualization...
- ~ Develop Python solutions to extract, transform, and standardize data from raw files in various formats (PDF, Excel, HTML... ...new payers, business rules, and reporting requirements. ~ Collaborate... ...Science, Information Technology, Engineering, or a related field (or...
- ...the same at Agoda. Data and technology are... ...product managers, engineers, and many others... ...Opportunity: As a Senior/Staff Data... ...views) that power CEG reporting, monitoring, forecasting... ...such as Python, Java, Golang, or... ...impact). ~ Strong SQL skills (complex joins...
- ...JOB TITLE: AWS Cognitive Engineer WORK SET UP: Onsite in Manila WORK SHIFT: Shifting Summary: As an Application Developer specializing... ...containerization (Docker, Kubernetes). • Proficiency in Python or other programming languages for AI integration. •...
- ...Accountabilities The Data Operations Specialist serves... ...data warehouses, APIs, Python and modern... ...performance analysis and reporting. Build and maintain... ...Develop and maintain modular SQL transformation workflows... ...automation and reusable data-engineering workflows. Translate...
- Data Scientist – Mid-Level / Senior Leading Global Financial Information &... ...Operations, Technology, Engineering, and analytics teams... ...proficiency in Python , including libraries... ...knowledge of SQL , relational databases... ...cloud platforms such as AWS or Azure, and MLOps...
- ...places to work. Mission As the Data Engineer you will design, build, and optimize scalable... .... Business Intelligence Reporting – Create and maintain Power BI and other... ..., or similar role. ~ Proficiency in Python and SQL for data engineering, automation, and...
- ...continued growth, we are hiring for a Senior Data Engineer (PostgreSQL DBA) at M3 Global Research... ...and optimize databases (PostgreSQL ,SQL Server, Oracle) for performance, security... ...best practices in data management and reporting. Qualifications Competencies...
- ...are looking for an experienced Data Engineer to develop, maintain, and... ...support business data integration, reporting, and analytics requirements.... .... Develop and optimize SQL queries, data transformation... ...Experience with cloud data platforms, Python, and data orchestration tools...
- ...Job Summary The Data Engineer is responsible for designing, building, and maintaining... ...accessible information to support enterprise reporting, analytics, and business decision-... ...ETL/ELT processes Proficiency in SQL and Python, with experience using data engineering...
- ...Data engineering at J4RVIS means building the foundations that... ...than just writing SQL. You’ll build data models... ...ElevenLabs, Snowflake, and AWS - spanning business... ...that supports reporting, analytics, and AI.... ...-ready datasets. • Python: Working knowledge of...
- ...Design and implement scalable cloud infrastructure solutions on AWS. Automate deployment processes using Infrastructure as... ...Testing, Functional Testing, Performance Testing, Test Automation, SQL, Shell, Python, and Java. Qualities and Traits: Strong analytical and...
- ...qualified professional to join our Market Data Services team as a full-time employee,... ...Minimum Bachelor's degree in Finance, Engineering, Computer Science, Economics, Statistics... ...and CAIA, are pluses Experience with SQL, Python or other object-oriented programming language...
- ...Responsibilities Advanced Data & AI Solutions: Build... ...practices in Python, C++, and R to optimize... ...Data Science, AI, or Data Engineering. Language Proficiency... ...microservices , and SQL/NoSQL databases. Machine... ...Proven capability in AWS, Azure, or GCP ,...
- ...insurer to support their growing Data & AI team. Based in Manila, you'll work alongside senior engineering, architecture and analytics... ...business, analytics and reporting use cases across a complex regional... ...Databricks, Spark/PySpark, Python and SQL. Develop ingestion,...
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Senior Data & Reporting Engineer (SQL/Python/AWS). Be the first to apply!
