Senior Analyst Programmer

About the Opportunity

Job Type: Permanent

Application Deadline: 30 June 2026

Job Description

                                                                                                

Title                 Senior Analyst Programmer

Department      Corporate Enablers - Technology

Location          Dalian

Reports To       Project Manager

Level                3

We’re proud to have been helping our clients build better financial futures for over 50 years. How have we achieved this? By working together - and supporting each other - all over the world. So, join our team and feel like you’re part of something bigger.

About your team

The Technology function provides IT services to the Fidelity International business, globally. These include the development and support of business applications that underpin our revenue, operational, investment, compliance, finance, legal, marketing and customer service functions. The broader organization incorporates Infrastructure services that the firm relies on to operate on a day-to-day basis including data center, networks, proximity services, security, voice, incident management and remediation. The Central team comprises systems development and support specialists that provide support to departments such as HR Services, Finance, Corporate Services, Legal and Compliance, Risk and Technology across various geographic locations.

About your role

As a Senior Analyst Programmer, you will be a key member of the Corporate Property Services (CPS) technology team, responsible for delivering end-to-end data solutions from data ingestion and transformation through to insightful visualizations and reporting. You will work closely with business stakeholders, tech lead and peer developers to design, build, and maintain high-quality data pipelines, analytical models, and Power BI dashboards that drive business decisions.

You will be expected to have a comprehensive understanding of the full data lifecycle, combining strong analytical thinking with hands-on technical skills across data warehousing, ETL processes, SQL development, Python scripting, and BI visualization. This role requires someone who can operate independently across the data stack while collaborating effectively with global teams.

About you

Eager to grow your knowledge and your career, you’ll fit right in. You’ll succeed because below are the opportunities you will get in here:

Key Responsibilities:

• Data Visualization & Reporting: Own and deliver technically sound Power BI dashboards and reports, working with business analysts and stakeholders to translate requirements into effective visualizations.
• Data Analysis & Exploration: Perform in-depth analysis and evaluation of data sources, data volumes, data quality, and associated business rules to support decision-making.
• Data Pipeline Development: Design, develop, and maintain ETL/ELT data pipelines to move and transform data across the enterprise data platform.
• SQL Development: Write and optimize complex SQL queries, stored procedures, views, and data transformations to support both operational and analytical workloads.
• Python Development: Develop Python scripts and utilities for data processing, automation, data validation, and integration tasks to enhance productivity and reduce manual effort.
• Data Modelling: Contribute to the design and maintenance of dimensional data models (star/snowflake schemas, SCD patterns) that underpin reporting and analytics.
• Stakeholder Collaboration: Work directly with senior business stakeholders in the development and refinement of dashboards and reports; train key business users on how to use reports and interpret KPIs/metrics.
• Technical Documentation: Produce technical specifications, data dictionaries, and unit test cases for interfaces and data pipelines under development.
• Quality Assurance: Design, build, and execute unit testing and data validation for reports, dashboards, and data pipelines to ensure accuracy and reliability.
• Best Practices: Propose best-practice visualizations, data modelling approaches, and coding standards; guide the business appropriately.
• Issue Resolution: Analyze technical issues, flag risks, and provide solution approaches proactively.
• Deployment & Version Control: Ensure code is maintained in version control (Git/GitHub) and participate in code deployments with the deployment team.
• Production Support: Provide necessary production support during initial phases after go-live and support the RTB (Run the Business) team for smooth integration experiences.

Essential Skills:

• Power BI: Strong hands-on experience (3+ years) in Power BI with the ability to identify best-practice visualizations, solutioning and delivering enterprise-grade dashboards and reports. Proficiency in DAX (including advanced measures, calculation groups, and field parameters), Power Query (M) for complex data transformations, and data modelling within Power BI (relationships, role-playing dimensions, aggregations). Experience with Row-Level Security (RLS), incremental refresh, composite models, dataflows, and Power BI Service administration (workspaces, deployment pipelines, scheduled refresh) is highly valued. Candidates with deep expertise in Tableau or other leading BI platforms (Qlik, Looker, etc.) who are willing to transition to Power BI will also be considered.
• SQL: Strong SQL skills (3+ years) including complex queries, joints, window functions, CTEs, query optimization, and understanding of indexes and execution plans. Experience with stored procedures, triggers, and packages is a plus.
• Python: Solid programming capability in Python for data analysis, automation, and scripting (e.g., pandas, NumPy, requests, or similar libraries). Ability to write clean, maintainable code.
• Data Warehousing: 3+ years of experience in data warehousing and data preparation, with a solid understanding of dimensional modelling (star schema, snowflake schema), fact/dimension tables, and SCD (Slowly Changing Dimension) patterns.
• ETL / Data Pipelines: Practical understanding of ETL/ELT concepts and experience building or maintaining data pipelines. Familiarity with tools such as Snaplogic, Informatica, or similar integration platforms.
• Databases: Excellent understanding of relational databases and the ability to read/create Entity Relationship Diagrams. Experience working with enterprise-grade data platforms (Oracle/SQL server/Snowflake/RDS).
• Communication: Excellent English written and verbal communication skills to collaborate effectively with global teams and senior stakeholders. Must be able to communicate fluently and articulately in English in a professional setting.
• Analytical Thinking: Must be able to articulate the logic/reasoning behind metrics, KPIs, and data points in dashboards and translate business requirements into technical solutions.
• Agile: Experience of delivering in an Agile environment with familiarity in sprint-based delivery, stand-ups, and retrospectives.
• Growth Mindset & Innovation: A strong passion for embracing emerging technologies especially AI, machine learning, and automation and proactively exploring how they can be applied to improve data workflows, reporting, and business outcomes. Demonstrates intellectual curiosity, a love for learning, and a drive to continuously improve.
• Ownership & Accountability: A strong sense of responsibility and dedication to work. Takes ownership of deliverables, follows through on commitments, and consistently strives for high-quality outcomes with attention to detail.

Desirable Attributes:

• Experience with Snowflake as a cloud data platform (or similar cloud data warehouses such as Redshift, BigQuery).
• Familiarity with AWS cloud fundamentals (S3, IAM, Lambda, or similar services).
• Experience with Git (branching, pull requests) and CI/CD pipelines (Jenkins, GitHub Actions, or similar).
• Knowledge of Infrastructure as Code Basics (Terraform or similar).
• Experience with data integration/orchestration platforms such as Snaplogic or similar tools.
• Exposure to JavaScript or other scripting languages for advanced Power BI or web-based reporting customization.
• Understanding of data governance, data quality frameworks, and metadata management.
• Familiarity with Control-M or similar job scheduling tools.
• Basic understanding of observability (logging, metrics) and secure coding practices.

Feel rewarded

For starters, we’ll offer you a comprehensive benefits package. We’ll value your wellbeing and support your development. And we’ll be as flexible as we can about where and when you work – finding a balance that works for all of us. It’s all part of our commitment to making you feel motivated by the work you do and happy to be part of our team. For more about our work, our approach to dynamic working and how you could build your future here, visit careers.fidelityinternational.com.