Data Engineer

For this role we need someone with insurance background.

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 & Analysi

s:o Profile source system data to identify data quality gaps, mapping requirements, and transformation logi

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

• w.Staging Pipeline Developmen

t:o Design and maintain SQL staging views that transform legacy data into target system forma

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

s.o Build stored procedures for data population and scope management across multiple product line

• s.Data Validation & Qualit

y:o Build and execute validation queries, reconciliation checks, and load report resolution workflow

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

t.o Implement data validation checks, monitor data quality, and address issues related to data integrity and accurac

• y.Collaboration with Stakeholder

s:o Resolve load report findings and deliver clean data package

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

s.o Provide regular updates on project progress, issues, and milestone

• s.Automation & Toolin

g:o Maintain and populate target staging databases in cloud environments (AWS RDS

• ).Documentation & Knowledge Sharin

g:o Document data mappings, transformation logic, product specifications, and data dictionarie

s.o Create and maintain comprehensive technical documentation including SQL scripts, process workflows, and integration specification

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

• g.AI-Assisted Developmen

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

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

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

• s.Continuous Learning & Innovatio

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

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

• n.Code Quality and Best Practice

s:o Write clean, efficient, and maintainable code, adhering to coding standards and best practice

s.
Qualificatio

• ns:2-5 years of experie
• nceHighly Preferr

ed:o Prior data migration/conversion project experie

nceo Experience with policy administration syst

emso Experience in the insurance/financial indus

• try
  
  Proficiency in SQL Server (queries, views, stored procedures, CTEs, window functions) and ETL (Extract, Transform, Load) proc
• essesAWS: RDS, S3, Secrets Manager, or equivalent cloud database exper
• ienceProficiency in Excel for data analysis and legacy data r
• eviewG
• itHubExperience with project management software (e.g.,
• Jira)Expertise in Agile methodologies (e.g., Kanban, Scrum) for managing del
• iveryExperience ensuring secure data handling, especially sensitive financial data and personally identifiable information
• (PII)Proficient in data validation and data cleansing prac
• ticesExperience using AI coding assistants (Claude, GitHub Copilot, or similar) for development workflows, prompt engineering, and automated ana

lysis
Compete

• ncies:Excellent communication and interpersonal skills, capable of conveying complex technical concepts to non-technical stakeho
• lders.Strong problem-solving abilities and analytical thi
• nking.Self-directed learner who thrives with mentorship — eager to absorb insurance domain knowledge and conversion method
• ology.Ability to work on multiple projects simultaneously while ensuring high-quality del
• ivery.Attention to detail, with a focus on delivering accurate and validated