Design, build, and maintain end-to-end data pipelines and data models in Snowflake using Medallion Architecture. Develop ingestion and transformation logic with Python and/or Informatica, implement CI/CD and version control (Git/Bitbucket), leverage Snowflake AI/ML (Cortex/LLM integrations), monitor and optimize pipelines, and ensure data quality and performance across environments.
The Role:
We are looking for a Senior Data Engineer with a minimum of 5+ years of experience in designing and implementing scalable, end-to-end data engineering solutions. The ideal candidate should have strong hands-on expertise in Snowflake, modern data pipeline development, cloud platforms, version-controlled development practices, and AI-enabled data solutions.
Key Responsibilities:
Required Skills & Experience:
Nice to Have:
Base Salary Compensation Range
$90,489.00-132,711.00
Incentive Target Percentage
12.5% Annual
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.
S99_MstarSwedenAB Morningstar Sweden AB Legal Entity
We are looking for a Senior Data Engineer with a minimum of 5+ years of experience in designing and implementing scalable, end-to-end data engineering solutions. The ideal candidate should have strong hands-on expertise in Snowflake, modern data pipeline development, cloud platforms, version-controlled development practices, and AI-enabled data solutions.
Key Responsibilities:
- Design, build, and maintain end-to-end data pipelines with Snowflake as the primary data warehouse.
- Implement and support Medallion Architecture within Snowflake for structured and scalable data management.
- Develop data ingestion pipelines using Python and/or Informatica to load data into Snowflake.
- Build scalable and efficient data models and transformation logic within Snowflake.
- Leverage Snowflake AI/ML capabilities (e.g., Snowflake Cortex, AI functions, or LLM integrations where applicable) to enable advanced analytics, automation, and data-driven insights.
- Manage SQL scripts, Python code, and Snowflake objects in a structured and maintainable way.
- Use Git / Bitbucket for version control of Snowflake scripts, Python code, and deployment artifacts.
- Support and implement CI/CD and deployment processes for data pipelines and database changes.
- Monitor, troubleshoot, and optimize data pipelines across all environments.
- Ensure data quality, consistency, and performance across all pipelines.
Required Skills & Experience:
- Minimum 5+ years of experience in data engineering or related roles.
- Strong hands-on experience with Snowflake, including data modeling, performance tuning, and production workloads.
- Proven experience in building end-to-end data pipelines.
- Strong proficiency in Python for data processing and automation.
- Experience with Informatica or similar ETL tools.
- Advanced SQL skills with strong understanding of data warehousing concepts.
- Hands-on experience with Snowflake AI/ML capabilities (e.g., Snowflake Cortex, LLM-based features, or similar AI-driven data platforms).
- Experience using Git / Bitbucket for version control in collaborative environments.
- Basic to intermediate understanding of CI/CD pipelines and deployment workflows.
- Hands-on experience with AWS cloud services and cloud-based data architectures.
Nice to Have:
- Exposure to Agile/Scrum development environments.
- Knowledge of Terraform / Infrastructure as Code.
- Exposure to Tableau or other BI / data visualization tools.
Base Salary Compensation Range
$90,489.00-132,711.00
Incentive Target Percentage
12.5% Annual
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.
S99_MstarSwedenAB Morningstar Sweden AB Legal Entity
Similar Jobs at Morningstar
Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services
As a Manager Research Analyst, you'll conduct quantitative and qualitative analysis on funds and investment vehicles, providing insights and ratings for investors while collaborating with a team dedicated to high-quality research.
Top Skills:
MatlabPythonR
Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services
Lead and manage credit ratings coverage for Canadian real estate entities, conducting financial and industry research, assessing legal documentation, preparing forecasts and rating committee materials, producing rating reports and press releases, developing methodologies, mentoring junior analysts, and maintaining stakeholder relationships. Role requires travel, regulatory compliance, and active participation in conferences and investor outreach.
Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services
Support Business Development team across North America by assisting client meetings, tracking engagements, maintaining Salesforce records, supporting billing and marketing, conducting market research, and contributing to process improvements and special projects to drive business growth.
Top Skills:
BloombergExcelMicrosoft OutlookMicrosoft PowerpointMicrosoft WordSalesforce
What you need to know about the Ottawa Tech Scene
The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.
