Lead the design and implementation of data models and pipelines on the Snowflake platform. Collaborate with stakeholders to ensure data quality and governance, while optimizing performance and best practices.
Description and Requirements
Summary:
Here at MetLife, we are seeking an experienced Data Modeler/Solution Designer to join our team and help on our building data platform solution (known as the Data Exchange or "DAX").
This role will mainly help design, build data models, and oversee implementation of data pipelines on our Snowflake data platform("DAX"). You will work with Snowflake, Erwin and Matillion to develop scalable and efficient data pipelines that support our business needs.
A strong understanding of data modeling principles is essential to build robust data pipelines based on our Data Architecture. Additionally, familiarity with DevOps models, CI/CD workflows and best practices is important.
Key Responsibilities:
Core Deliverables:
Responsibilities:
TECHNICAL TROUBLESHOOTING AND OPTIMISATION:
Conduct impact assessment for any upstream / downstream changes.
Devops & Operations:
Ensure compliance with data governance, security.
Qualifications:
Core SnowPro Certificate is highly desired
Experience & Skills:
Strong problem-solving skills and the ability to troubleshoot pipeline issues effectively.
About MetLife
Recognized on Fortune magazine's list of the 2025 "World's Most Admired Companies" and Fortune World's 25 Best Workplaces™ for 2024, MetLife , through its subsidiaries and affiliates, is one of the world's leading financial services companies; providing insurance, annuities, employee benefits and asset management to individual and institutional customers. With operations in more than 40 markets, we hold leading positions in the United States, Latin America, Asia, Europe, and the Middle East.
Our purpose is simple - to help our colleagues, customers, communities, and the world at large create a more confident future. United by purpose and guided by empathy, we're inspired to transform the next century in financial services.
At MetLife, it's #AllTogetherPossible . Join us!
#BI-Hybrid
Summary:
Here at MetLife, we are seeking an experienced Data Modeler/Solution Designer to join our team and help on our building data platform solution (known as the Data Exchange or "DAX").
This role will mainly help design, build data models, and oversee implementation of data pipelines on our Snowflake data platform("DAX"). You will work with Snowflake, Erwin and Matillion to develop scalable and efficient data pipelines that support our business needs.
A strong understanding of data modeling principles is essential to build robust data pipelines based on our Data Architecture. Additionally, familiarity with DevOps models, CI/CD workflows and best practices is important.
Key Responsibilities:
Core Deliverables:
- Develop and deliver Conceptual/Logical/Physical data models
- Develop data mappings and transformation rules document
- Develop business glossaries (metadata) and relevant data model documentation (data dictionaries) for data and analytics solutions.
Responsibilities:
- Work with business SMEs and data stewards to align data models according to business process.
- Ensure data architecture and data management principles are followed during development of new data models.
- Build data modelling standards, naming conventions and follow them during implementation.
- Work with data stewards, data management specialists to ensure metadata, data quality rules are implemented accurately.
- Integrate data from various source systems (e.g., databases, APIs, flat files) into Snowflake.
- Review and support the whole SDLC till go-live and post-production issues. This includes reviewing technical mapping documents, test cases, test plans and execution. Includes scheduling seamless deployment to go live.
TECHNICAL TROUBLESHOOTING AND OPTIMISATION:
- Ability to conduct workshops with business SMEs and data stewards to understand the business processes.
- Data Profiling and analysis to establish strong hold on data.
- Conduct root cause analysis and recommend long-term fixes for recurring issues
Conduct impact assessment for any upstream / downstream changes.
Devops & Operations:
- Collaborate with Data Engineers and Tech BA, ensuring proper version control (Git, Bitbucket) and deployment best practices for data models.
Ensure compliance with data governance, security.
Qualifications:
- Bachelor's degree in computer science or equivalent with demonstrated experience in delivery of data model and design for Data and analytics project delivery.
Core SnowPro Certificate is highly desired
Experience & Skills:
- 8+ years of experience as a Data Engineer/Data Modeler, preferably in a cloud-based environment.
- Strong experience with data modelling and data warehouse and data integration.
- Deep understanding of Snowflake, including performance optimization and best practices.
- Strong SQL skill is mandatory
- Solid understanding of data modeling concepts to build effective pipelines.
- Familiarity with DevOps workflows and working in environments with CI/CD, version control (Git, Bitbucket), and automated deployments.
Strong problem-solving skills and the ability to troubleshoot pipeline issues effectively.
- Knowledge of data management / governance principles and their importance to dealing with data risk (for MetLife and relationship with regulators).
- Life Insurance or Banking experience including knowledge of financial / actuarial valuation methods and processes (preferred).
About MetLife
Recognized on Fortune magazine's list of the 2025 "World's Most Admired Companies" and Fortune World's 25 Best Workplaces™ for 2024, MetLife , through its subsidiaries and affiliates, is one of the world's leading financial services companies; providing insurance, annuities, employee benefits and asset management to individual and institutional customers. With operations in more than 40 markets, we hold leading positions in the United States, Latin America, Asia, Europe, and the Middle East.
Our purpose is simple - to help our colleagues, customers, communities, and the world at large create a more confident future. United by purpose and guided by empathy, we're inspired to transform the next century in financial services.
At MetLife, it's #AllTogetherPossible . Join us!
#BI-Hybrid
Top Skills
Bitbucket
Erwin
Git
Matillion
Snowflake
SQL
Similar Jobs at MetLife
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
The Assistant Vice President will lead corporate technology transformation, manage large technology teams in India, and drive strategic technology decisions while ensuring high engagement and innovation in product development processes.
Top Skills:
.NetAIAPIsAWSAzureAzure DevopsCloudDataDevsecopsGCPGithub CopilotJavaMicrosoft Azure StackOpenai
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
The Junior Engineer II will work on test automation, validate application functionality, maintain automation scripts, and participate in planning and execution of testing strategies.
Top Skills:
AgileManual TestingTest Automation
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
The SDET leads testing practices, develops automation solutions, manages test strategies, and collaborates with teams to ensure high-quality software delivery in an Agile setup.
Top Skills:
AgileAutomation TestingBddCi/CdGen-Ai
What you need to know about the Kolkata Tech Scene
When considering the industries shaping India's tech scene, gaming might not immediately come to mind. However, in the last decade, increased internet usage and greater access to mobile devices have catapulted the industry to new heights, with Kolkata-based companies like Virtualinfocom, Red Apple Technologies and Digitoonz, at the forefront, driving the design and animation of new gaming titles for players.