Lead source-to-target data mapping for Enterprise Data Warehouse, focusing on complex Life and Retirement products.
Create and maintain paginated/interactive dashboards and reports using tools like Tableau or PowerBI.
Perform data analysis on raw source data and enterprise data warehouses/data marts to access and maintain data quality.
Develop and maintain metadata definitions for sourcing data stores and all evolutions of the Data Lake from ingested sources to consumers.
Work with stakeholders across departments to develop analytical solutions for business challenges.
Participate in data governance initiatives and ensure data integrity, consistency, and quality.
Create and maintain data dictionaries, ER diagrams, and mapping documentation.
Facilitate data requirements meetings with stakeholders to drive data solutions.
Assist developers with query development and performance optimization.
Collaborate with other technology teams and architects to define and develop solutions.
This is a hands-on role.
Requirements
Bachelor's or Master’s degree in Information Technology or related field preferred, or equivalent work experience.
A seasoned IT professional with senior leadership qualities and background with a minimum of 10 years’ experience in IT.
8+ years of experience in data analysis and 5+ years within financial services in Life/Retirement business.
8+ years of experience SQL and BI tools like Tableau/PowerBI.
10+ years of experience in the IT Industry.
Strong working knowledge of SQL, Data Analysis tools like Python/R to analyze large datasets for trends.
Perform “root cause analysis” on data quality issues to maintain integrity of highly sensitive financial data.
Deep understanding of Life Insurance and Retirement (Individual and Group) industry space preferred.
Excellent technical and organizational skills.
Familiarity with data governance frameworks (Collibra, Informatica, Erwin).
Strong communication and team skills.
Proficiencies with Agile development practices.
Experience with relational and dimensional data modeling.
Strong knowledge of reporting modeling concepts, including dimensional, snowflakes, slowly changing dimensions, and surrogate, compound and intelligent keys.
Experience with cloud platforms like AWS, Azure.
Familiarity with data warehousing concepts and ETL processes.
Tech Stack
AWS
Azure
Cloud
ETL
Informatica
Python
SQL
Tableau
Benefits
Health and Wellness: We offer a range of medical, dental and vision insurance plans, as well as mental health support and wellness initiatives to promote overall well-being.
Retirement Savings: We offer retirement benefits options, which vary by location. In the U.S., our competitive 401(k) Plan offers a generous dollar-for-dollar Company matching contribution of up to 6% of eligible pay and a Company contribution equal to 3% of eligible pay (subject to annual IRS limits and Plan terms). These Company contributions vest immediately.
Employee Assistance Program: Confidential counseling services and resources are available to all employees.
Matching charitable donations: Corebridge matches donations to tax-exempt organizations 1:1, up to $5,000.
Volunteer Time Off: Employees may use up to 16 volunteer hours annually to support activities that enhance and serve communities where employees live and work.
Paid Time Off: Eligible employees start off with at least 24 Paid Time Off (PTO) days so they can take time off for themselves and their families when they need it.