Description and Requirements 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.
Location Expectation: This is a hybrid role
requiring a minimum of 3 days per week in office.
The expected salary range for this position is $110,000 - $175,600. This role may also be eligible for annual short-term incentive compensation. All incentives and benefits are subject to the applicable plan terms.
Benefits We Offer Our U.S. benefits address holistic well-being with programs for physical and mental health, financial wellness, and support for families. We offer a comprehensive health plan that includes medical/prescription drug and vision, dental insurance, and no-cost short- and long-term disability. We also provide company-paid life insurance and legal services, a retirement pension funded entirely by MetLife and 401(k) with employer matching, group discounts on voluntary insurance products including auto and home, pet, critical illness, hospital indemnity, and accident insurance, as well as Employee Assistance Program (EAP) and digital mental health programs, parental leave, volunteer time off, tuition assistance and much more!
$110,000 - $175,600
