What are the responsibilities and job description for the Senior Lead Analyst - Data Engineering position at MetLife, Inc?
Description and Requirements
The Team You Will Join
The position sits within the newly consolidated Employer & Broker pillar of Data and Analytics (D&A) organization supporting MetLife's U.S. Business. U.S. D&A assists all business lines of MetLife’s U.S. business (about 2/3 of MetLife Global by earnings) with everything related to reporting and analytics including visualization, business intelligence, data science, and AI.
The Opportunity
The Data Analyst serves as the data expert and acts as the backbone to the analytics life cycle, responsible for requirement gathering and solutioning. The individual will collaborate with all the stakeholders of the project (technical leads, build team, project managers and business/operations teams) in building data enablement solutions across different LOBs and use cases.
How You’ll Help Us Build a Confident Future (Key Responsibilities)
- Work with business users/tech partners to translate given business problems into solutions to develop ETL processes with defined outcomes.
- Analyze the data in depth, using SQLs and other exploratory tools against various platforms such as Azure Synapse, Databricks, Bigdata, Oracle, SQL Server and others.
- Convert business requirements to functional requirements, with detailed transformation rules for ETL team. This is a very technical hands-on role and is responsible for the functional design of the end-to-end process.
- Work closely with the ETL and data science/reporting teams to review the requirements and data integrations.
- Understand the requirements from Business and Data Science/reporting. Understand the business and business impact on use cases.
- Write validation scripts to validate the data loaded by data engineering team.
- Work with IT, business, and architects to develop and design requirements to formulate technical design.
- Skills to understand the right functional domain knowledge of the business to be able to gather right requirements for the design.
- Capture meta data, data lineage, reference data management and data quality rules as part of data governance.
- Overseeing the development of ETL processes in Azure synapse or Databricks and able to modify those ETL pipelines and troubleshoot failures or issues.
- Lead the team, including stakeholders, spread across the globe in driving the delivery of projects.
- Lead/mentor other analysts within the team and/or organization.
Required Skills:
- Bachelor’s degree in computer science, engineering, or related discipline.
- 8 years of overall experience, including 5 years working in a data management/engineering organization.
- Proficient in Agile development and operations.
- Detail oriented, gathering the appropriate level of feature and user story descriptions and benefit hypothesis.
- Extensive experience in data analysis and data modeling (table design).
- Extensive experience writing functional requirements and high-level design documents, data-flow diagrams, etc.
- Experience in writing validation scripts to validate the data, data integrations and ETL transformations.
- Analytical skills to analyze situations and come to optimal and efficient solution based on requirements.
- SQL knowledge and data analysis skills for data anomaly detection and data quality assurance.
- Proficiency in SQLs and data exploration tools. Experience with SQL, Spark &/or Scala/Python and performance tuning.
- Experience with scripting primarily on shell/bash/ PowerShell.
- Excellent communication skills, both written and verbal.
- Strong leadership and negotiation skills.
Preferred Skills:
- Working closely with product management, customers, business owners, and other stakeholders to create viable and sustainable plans, and seeking and incorporating feedback into the solutions, and ensuring completeness and timely execution.
- Strong technical experience in Azure synapse, Azure Databricks, including Spark, DeltaLake, data stores for analytics consumption.
- Hands-on expertise in Azure SQL Synapse and/or Data Factory experience.
- Help define, refine, prioritize, and accept the work by an Agile team to meet the feature acceptance criteria and maintain a sustainable pace.
- Strong background or working experience in Insurance Industry.
- Ability to interact with senior leadership teams in IT and business.
- Exposure to Gen AI technology and tools.
- DevOps practices: Git, Azure Dev Ops, CI/CD pipelines.
Salary : $110,000 - $175,600