Sr Data Management Analyst
Pacific Life · Newport Beach, CA · 1 wk ago
Information Technology$138k–$168k/yrFull-time
About the role
The Sr Data Management Analyst plays a crucial role in ensuring reliable, high-quality, and trusted data across Pacific Life's enterprise data platforms. Reporting to the Director of Data Management, this position focuses on data quality, governance, and observability.
Responsibilities
- Lead Data Quality and Governance for Workforce Benefits Division (WBD)
- Manage asset certification program for data, data metrics, reports
- Partner with data architects, engineers, analysts, and business stakeholders to gather requirements and translate business needs into clear technical solutions
- Implement data observability and data quality monitoring frameworks, including automated checks, anomaly detection, and alerting mechanisms across critical data pipelines
- Perform deep data analysis using SQL and Python to identify anomalies, data gaps, and inconsistencies across source-to-target systems
- Develop and maintain data quality metrics, scorecards, and monitoring dashboards to track data reliability and pipeline health
- Conduct root cause analysis and remediation of data issues, working across upstream and downstream systems
- Design and develop scalable data solutions, including data models, source-to-target mappings, ETL/ELT
- Collaborate with engineering teams on code reviews, testing, CI/CD processes, and deployment best practices
- Support data governance initiatives, including metadata management, data lineage, data certification, and business glossary maintenance
- Ensure compliance with data standards, controls, and regulatory requirements for sensitive data (PII/PHI)
- Work within Agile delivery teams to prioritize, manage, and execute work effectively
Requirements
- BS in Computer Science, Mathematics, Finance or related field. Master’s degree preferred
- Minimum of 6+ years’ of professional experience in Data analysis, Data Quality, Engineering, related roles
- Expert level SQL and strong Python programming skills
- Strong hands-on experience with SQL for data analysis, validation, and troubleshooting data issues
- Experience building or supporting data pipelines, ETL processes, or data workflows
- Experience implementing data quality monitoring, observability frameworks, or automated controls
- Experience working with cloud-based data platforms (AWS, Azure, Snowflake, etc.)
- Strong experience with data profiling, anomaly detection, and root cause analysis
- Experience working in Workforce Benefits (WBD), Insurance, or Healthcare data domains
Qualifications
- Experience with regulated data environments (PII/PHI)
- Experience in Workforce benefits domain
- Data Management Professional (CDMP), AWS certification
- 3+ years setting up data governance and catalog toolsets like Alation, Atlan, or Collibra
- 3+ years experience with cloud technologies such as Snowflake and AWS related to data warehousing
- 3+ years of data analysis or reporting experience with building SQL queries, metrics definitions and translating source data into target analysis
Skills
- SQL for data analysis, validation, and troubleshooting data issues
- Python programming skills
- Data profiling, anomaly detection, and root cause analysis
- Data governance and catalog toolsets
- Cloud technologies such as Snowflake and AWS
- Data analysis or reporting experience with SQL queries, metrics definitions, and translating source data into target analysis
Benefits
- Prioritization of your health and well-being including Medical, Dental, Vision, and Wellbeing Reimbursement Account
- Generous paid time off options including: Paid Time Off, Holiday Schedules, and Financial Planning Time Off
- Paid Parental Leave as well as an Adoption Assistance Program
- Competitive 401k savings plan with company match and an additional contribution regardless of participation