Data Engineer

For this role we need someone who is working or worked in the past for a Life Insurance company.

As a Data Engineer on the Conversions team, you will play a critical role in migrating insurance policy data from administration systems to a modern policy administration platform. Your primary responsibility is to profile source data, build staging pipelines, resolve data quality issues, and deliver validated data loads. This role offers direct mentorship from an experienced conversion manager and exposure to the full data migration lifecycle from initial discovery through production cutover. This position requires technical expertise in SQL and data engineering, combined with effective communication to support iterative delivery cycles

.
Key Responsibilitie

• s:
  Data Profiling & Analys

is:o Profile source system data to identify data quality gaps, mapping requirements, and transformation log

ic.o Investigate data anomalies, trace root causes across related tables, and document findings for stakeholder revi

• ew.Staging Pipeline Developme

nt:o Design and maintain SQL staging views that transform legacy data into target system form

at.o Create and maintain lookup/reference views that map source system codes to target platform valu

es.o Build stored procedures for data population and scope management across multiple product lin

• es.Data Validation & Quali

ty:o Build and execute validation queries, reconciliation checks, and load report resolution workflo

ws.o Participate in iterative data quality cycles (profile, fix, reload, validate) until target thresholds are m

et.o Implement data validation checks, monitor data quality, and address issues related to data integrity and accura

• cy.Collaboration with Stakeholde

rs:o Resolve load report findings and deliver clean data packag

es.o Maintain ongoing communication with internal teams to ensure requirements are fully understood and reflected in delivered solutio

ns.o Provide regular updates on project progress, issues, and mileston

• es.Automation & Tooli

ng:o Maintain and populate target staging databases in cloud environments (AWS RD

• S).Documentation & Knowledge Shari

ng:o Document data mappings, transformation logic, product specifications, and data dictionari

es.o Create and maintain comprehensive technical documentation including SQL scripts, process workflows, and integration specificatio

ns.o Share knowledge and expertise with team members, promoting best practices and fostering a culture of collaborative learni

• ng.AI-Assisted Developme

nt:o Leverage AI coding assistants (e.g., Claude, Copilot) to accelerate SQL development, data profiling, script generation, and documentati

on.O Write effective prompts to guide AI tools for complex data analysis, code generation, and automated reporti

ng.o Review, validate, and refine AI-generated outputs to ensure accuracy and alignment with business requiremen

• ts.Continuous Learning & Innovati

on:o Stay up to date with emerging data engineering technologies, AI tooling, and best practices to improve solution delive

ry.o Absorb insurance domain knowledge through mentorship, documentation review, and hands-on data explorati

• on.Code Quality and Best Practic

es:o Write clean, efficient, and maintainable code, adhering to coding standards and best practic

es.
Qualificati

• ons:
  2-5 years of exper
• ienceHighly Prefe

rred:o Prior data migration/conversion project exper

ienceo Experience with policy administration sy

stemso Experience in the insurance/financial ind

• ustry
  Proficiency in SQL Server (queries, views, stored procedures, CTEs, window functions) and ETL (Extract, Transform, Load) pro
• cessesAWS: RDS, S3, Secrets Manager, or equivalent cloud database expe
• rienceProficiency in Excel for data analysis and legacy data
• review
• GitHubExperience with project management software (e.g.,
• Jira)Expertise in Agile methodologies (e.g., Kanban, Scrum) for managing de
• liveryExperience ensuring secure data handling, especially sensitive financial data and personally identifiable information
• (PII)Proficient in data validation and data cleansing pra
• cticesExperience using AI coding assistants (Claude, GitHub Copilot, or similar) for development workflows, prompt engineering, and automated an

alysis
Compet

• encies:
  Excellent communication and interpersonal skills, capable of conveying complex technical concepts to non-technical stake
• holders.Strong problem-solving abilities and analytical t
• hinking.Self-directed learner who thrives with mentorship — eager to absorb insurance domain knowledge and conversion meth
• odology.Ability to work on multiple projects simultaneously while ensuring high-quality d
• elivery.Attention to detail, with a focus on delivering accurate and validat