QA Automation Engineer (Data)

Posted 4 Hours Ago
Be an Early Applicant
Mumbai, Maharashtra, IND
Hybrid
Junior
Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services
Unlock what's already in you
The Role
Designs and maintains automated data quality frameworks, validation controls, anomaly monitoring, and source-to-target reconciliation processes for large-scale financial datasets. The role validates data from market-data providers, embeds quality controls into ETL/ELT pipelines, supports new dataset onboarding, and performs profiling and root-cause analysis. Requires advanced Python, SQL, and PySpark skills, financial data expertise, and exposure to AWS-based platforms and AI productivity tools.
Summary Generated by Built In

The Area: The Investment Management group is a global team guided by Morningstar’s investment principles focused on delivering great long-term investment results to help end-investors reach their financial goals.  We use our expertise in asset allocation, investment selection and portfolio construction to create world-class investment strategies leveraging the full resources of Morningstar. The group specializes in multi-asset investing, using building blocks in equities, fixed income and alternative investments to construct robust portfolios.  Through our investment offerings, we serve financial advisers and institutions, and the investors that they serve. 
Shift: UK Shift

Role Summary: 

The Data Quality Automation Engineer will join the Systematic Strategies team in the Research & Investment group. This experienced professional will design and implement automated data quality controls, validation frameworks, reconciliation processes, and monitoring solutions across enterprise-scale data platforms. The ideal candidate combines expertise financial data management and automation engineering, with a passion for building scalable controls that improve data quality and operational efficiency.
 

Key Responsibilities 

The successful candidate will 

  • Design, build, and maintain enterprise-scale automated data quality frameworks like Great Expectations, AWS Glue Data Quality, Amazon Deequ, or similar data validation frameworks 

  • Experience implementing and maintaining data quality controls by establishing quality metrics for multi-asset class financial datasets. 

  • Develop automated monitoring controls capable of identifying anomalies, outliers, missing data, stale data, and reconciliation breaks 

  • Validate investment datasets sourced from multiple external providers including Bloomberg, FactSet, Morningstar, LSEG, and other market data vendors 

  • Develop automated source-to-target reconciliation frameworks across ingestion, transformation, and reporting layers 

  • Collaborate with Data Engineering teams to embed data quality controls throughout ETL/ELT pipelines 

  • Support onboarding and robustness checks for new datasets including validation of data completeness, accuracy, consistency, and fitness for downstream investment and research workflows 
     

Requirements: 

  • Advanced Python development 

  • Strong SQL and data analysis skills 

  • Hands-on experience with PySpark and distributed data processing 

  • Experience building automated data validation and reconciliation frameworks 

  • Experience working with large-scale structured and semi-structured datasets in financial domain 

  • Data profiling, anomaly detection, and root-cause analysis experience 
     

Required Technical Skills 

  • Advanced SQL, Python, and PySpark skills 

  • Exposure to designing, developing, and maintaining automated data quality frameworks  

  • Strong expertise in financial data testing, data profiling and root cause analysis  

  • Exposure to cloud-based data platforms and services (AWS preferred) 

  • Exposure to AI productivity tools such as ChatGPT, Microsoft Copilot, and GitHub Copilot, with responsible validation of AI-generated outputs.
     

Preferred Qualifications 

  • Bachelor's or master's degree in quantitative, financial, economic, or engineering discipline 

  • 2+ years of experience in Data Quality Engineering, Data Engineering, Analytics Engineering, Financial Data Management, or Investment Technology 

Morningstar is an equal opportunity employer.

Morningstar's hybrid work environment gives you the opportunity to collaborate in-person each week as we've found that we're at our best when we're purposely together on a regular basis. In most of our locations, our hybrid work model is four days in-office each week. A range of other benefits are also available to enhance flexibility as needs change. No matter where you are, you'll have tools and resources to engage meaningfully with your global colleagues.

I10_MstarIndiaPvtLtd Morningstar India Private Ltd. (Delhi) Legal Entity

Skills Required

  • Advanced Python development skills
  • Strong SQL and data analysis skills
  • Hands-on experience with PySpark and distributed data processing
  • Experience building automated data validation and reconciliation frameworks
  • Experience working with large-scale structured and semi-structured datasets in the financial domain
  • Experience with data profiling, anomaly detection, and root-cause analysis
  • Advanced SQL, Python, and PySpark skills
  • Exposure to designing, developing, and maintaining automated data quality frameworks
  • Strong expertise in financial data testing, data profiling, and root-cause analysis
  • Exposure to cloud-based data platforms and services, preferably AWS
  • Exposure to ChatGPT, Microsoft Copilot, and GitHub Copilot, with responsible validation of AI-generated outputs
  • Bachelor's or master's degree in a quantitative, financial, economic, or engineering discipline
  • Two or more years of experience in Data Quality Engineering, Data Engineering, Analytics Engineering, Financial Data Management, or Investment Technology

What the Team is Saying

Anna
Upasna
Saurabh
Wendell
Raaghavendar
Jeff
Brandon
Kunal Kapoor
Elizabeth Collins
Marie Trzupek Lynch
Rod Diefendorf
Christine

Morningstar Compensation & Benefits Highlights

  • Leave & Time Off Breadth Policies include a paid sabbatical every four years and flexible PTO covering vacation, sick, and personal days, alongside paid volunteer time. Feedback suggests these features create meaningful flexibility and rest opportunities beyond standard leave plans.
  • Parental & Family Support A global minimum of 16 weeks paid parental leave for primary caregivers (up to 8 weeks for secondary) and at least six weeks of paid caregiving leave are publicly stated, with adoption assistance also available. These provisions indicate robust support for families during key life events.
  • Retirement Support U.S. materials document a 401(k) match of $0.75 per $1 up to 7% of pay and no‑cost access to Morningstar retirement tools. This combination strengthens long‑term savings and planning for employees.

Morningstar Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Chicago, IL
11,500 Employees
Year Founded: 1984

What We Do

We are a global investment research and financial data company with 40-plus offices across North America, Europe, Australia, and Asia. Our products and services are used daily by individual investors, financial advisors, asset managers, retirement plan providers, and institutional investors. We provide data, research, and analysis across managed investment products, publicly listed companies, private capital markets, debt securities, and real-time global market data. The financial system can have real barriers—hidden information, friction that can slow decisions, and forces that can limit transparency and access. We work to remove them, bringing independent research, connected data, and investor-first tools to a system that needs more clarity. The people doing this work span research, technology, design, product, sales, and functional areas. We build many of our products in-house, so the work can connect directly to the tools investors use to make real financial decisions.

Why Work With Us

Imagining big things is in our blood -- it's transformed us from a company with just a few employees in 1984 to a leading independent investment research company with a worldwide presence today. As of April 2020, we acquired Sustainalytics to drive long-term meaningful outcomes for investors in the ESG space. Join us on this exciting journey!

Gallery

Gallery
Gallery
Gallery
Gallery
Gallery
Gallery

Morningstar Offices

Hybrid Workspace

Employees engage in a combination of remote and on-site work.

Typical time on-site: 4 days a week
Company Office Image
HQGlobal Headquarters
Ambler, Pennsylvania
Amsterdam - De Oliphant
Bucuresti, Bucuresti
Cape Town, Western Cape
Dubai
Edinburgh, Scotland
Frankfurt - Junghofstraße
Frankfurt - Neue Mainzer Straße
New Delhi
Hong Kong
London - Oliver's Yard
London - Saffron House
Madrid, Comunidad de Madrid
Milano, Lombardia
Mumbai - Platinum Park
Mumbai - Vishwaroop
New York - Broadway
New York - Park Ave
Paris, Ile-de-France
San Francisco, California
PitchBook US Headquarters
Sham Chun Hu, Guangdong
Singapore, Singapore
Stockholm - Birger Jarlsgatan
Sydney - International Tower
Timisoara, Timis
Tokyo - Minato-ku
Company Office Image
Toronto, ON
Zürich, Zurich
Learn more

Similar Jobs

Morningstar Logo Morningstar

Senior Quantitative Analyst

Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services
Hybrid
Mumbai, Maharashtra, IND
11500 Employees

Morningstar Logo Morningstar

Quantitative Developer

Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services
Hybrid
Mumbai, Maharashtra, IND
11500 Employees

Morningstar Logo Morningstar

Associate Product Manager

Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services
Hybrid
Mumbai, Maharashtra, IND
11500 Employees

Morningstar Logo Morningstar

Editor

Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services
Hybrid
Mumbai, Maharashtra, IND
11500 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account