System Analyst, ETL Pipeline (Financial Services, Contract)

A leading financial institution in Hong Kong seeks a System Analyst to develop and optimise ETL pipelines supporting ESG data solutions and regulatory reporting.

This role focuses on data quality, scalable analytics, and cross-functional collaboration in a supportive environment that values technical excellence and professional growth.

Key responsibilities:

As a System Analyst, you will play a central role in shaping the firm's ESG product offerings by designing robust database structures and developing efficient ETL pipelines.

• Design and develop database objects (tables, stored procedures, queries, and triggers) to support ESG-related projects
• Build, maintain, and optimise ETL pipelines using Python, SQL, SSIS, and scheduling tools
• Collaborate with cross-functional teams on database architecture and interface design for ESG initiatives
• Develop logical and physical data models while ensuring strong data integrity, quality, and consistency
• Manage development, UAT, and production environments to ensure smooth deployment across project stages
• Produce clear documentation of design specifications and functional requirements for project delivery

Candidate profile:

Your experience in system analysis and ETL development equips you with the technical expertise needed for this asset management role.

• Expert-level proficiency in SQL and Python for building and optimising data solutions
• Hands-on experience with Microsoft enterprise tools, including SSIS, SQL Server, and SSRS
• Proven experience delivering data interface development and system/data migration projects
• Strong expertise in data modelling, data analysis, and data governance frameworks
• Quick learner with the ability to adapt effectively to new and evolving technical environments
• Familiarity with .NET and additional ETL tools considered a strong advantage
• Knowledge of data governance and data quality management best practices
• Strong team player with excellent communication skills, professional integrity, and a collaborative work ethic

About this company:

This leading financial services organisation is committed to driving innovation in sustainable investing through advanced ESG data and reporting solutions.

Keywords: ETL Development, System Analysis, SQL & Python, Database Development, ESG Data & Reporting

What's next:

If you're ready to make a meaningful impact on sustainable investing while advancing your career within a supportive team environment, apply now!