Build automated data extracts and feeds from curated Gold Layer models
Develop formatted operational and regulatory reports (Power BI, Tableau, SAC, SSRS, Crystal Reports)
Design and maintain ETL/ELT pipelines using ADF, Informatica or similar tools
Create reliable outbound data delivery via SFTP, APIs, or managed file transfer platforms
Implement data validation, reconciliation checks, and robust quality controls
Maintain clear lineage from Gold Layer to downstream outputs with audit readiness
Optimize extraction logic for performance and scalability
Build and manage scheduling, monitoring, and alerting for production pipelines
Work closely with Finance, Actuarial, Operations, and business partners to gather and translate reporting needs
Document feeds, mappings, data definitions, and technical specifications

Bachelor’s degree in computer science, Software Engineering, or a related field (or equivalent experience)
4+ years’ experience in data engineering, BI engineering, or analytics engineering
Advanced SQL skills and strong understanding of 3NF and analytic modeling
Hands‑on experience with ETL/ELT platforms (Informatica, ADF or similar)
Practical experience building formatted reports (Power BI/Tableau/SAC/SSRS/Crystal Reports)
Ability to generate and automate file‑based outputs (CSV, TSV, XML, JSON etc.)
Experience delivering feeds via SFTP, MFT, or API frameworks
Strong data quality, validation, and reconciliation skills
Good understanding of data warehousing and data model design
Familiarity with scheduling/orchestration tools (ADF, Airflow, Control‑M, Autosys)

Health insurance
Dental benefits
Vision benefits
Short
and long-term disability insurance
Life and AD&D insurance coverage
Adoption/surrogacy and wellness benefits
Employee/family assistance plans
Retirement savings plans
Generous paid time off program including holidays, vacation, personal, and sick days

Full Stack Data Engineer, Analytics, ETL, Reporting

Key skills