Full Stack Data Engineer
Core
Migrate legacy insurance licensing and compensation data to a modern vendor platform and Data Lake, building scalable ETL/ELT pipelines and ensuring data quality for downstream financial and operational consumers.
Role type
Senior Full-Stack Data Engineer (Modernization & Migration)
Builds
ETL/ELT pipelines, data models, automated extracts, and reconciliation reports for Finance, Distribution, and Operations.
Domain
Insurance / Financial Services / Data Engineering
Required skills
SQL, Informatica, Azure Data Factory (ADF), Databricks, Data Warehousing, Data Modeling, ETL/ELT, Data Migration, Data Reconciliation, Power BI, Tableau, SSRS, Scheduling/Orchestration
Preferred skills
Legacy system modernization, Azure Synapse/Spark/Python, Git/CI/CD, REST APIs/Kafka, Insurance domain knowledge, Generative AI
Technologies
Informatica, Azure Data Factory, Databricks, SQL, Power BI, Tableau, SSRS, Crystal Reports, MuleSoft, CA WLA
Responsibilities
Analyze legacy data structures and business rules; Design and develop ETL/ELT pipelines for data conversion; Perform source-to-target mapping, profiling, cleansing, and validation; Design and maintain dimensional data models; Build automated data extracts and interfaces; Develop operational and analytical reporting; Implement data-quality controls and financial reconciliation; Partner with business analysts and architects to translate requirements; Investigate complex data issues and support root-cause analysis; Maintain data lineage and technical specifications for auditability.
Seniority
Senior, hands-on IC