Data Engineer SQL

Talendica; United States; Remote; USD 100,000 - 140,000; Full time

Job summary

Talendica is seeking a data engineer with 5+ years of data engineering experience to design and implement end-to-end data pipelines for insurance data, using SQL Server, Azure Data Factory, dbt, and Python.

The role requires self-direction and the ability to collaborate with business SMEs to translate insurance rules into pipeline logic while working remotely in EST hours.

Experience with Lakehouse architectures, data quality checks, and performance tuning is a plus.

Qualifications

• 5+ years of data engineering experience.
• Strong SQL Server development including complex T-SQL, indexing and query tuning.
• Hands-on experience with Azure Data Factory and SSIS for batch ETL.
• Experience with dbt and Python for transformation and testing.
• Familiarity with Microsoft Fabric: Lakehouse, Data Factory pipelines and notebooks.

Skills

Data engineering

SQL Server

Azure Data Factory

dbt

Python

Microsoft Fabric

ETL

Data modeling

Tools

SSIS

Job description

Location: Remote- need to work EST hours

Duration: 6 months to 1 year

Looking for someone with 3-5 years of experience with SQL Server, Azure data factory, and stored procedures. Excellent communication skills.

• 5+ years of data engineering experience, including hands-on work with property and casualty insurance data (policy, premium, claims, losses, reserves)
• Strong SQL Server development: complex T-SQL, stored procedures, indexing, and query tuning against large transactional and reporting datasets
• Proven SSIS experience building batch ETL, including incremental loads, error handling, and deployment via SQL Server Agent
• Working knowledge of Microsoft Fabric: Lakehouse, Data Factory pipelines, notebooks, and Direct Lake semantic models
• Experience with dbt and Python for transformation, testing, and documentation, implementing a medallion architecture (bronze, silver, gold) from raw extracts through conformed and curated reporting layers
• Builds dimensional models for actuarial, underwriting, and finance reporting, with documented lineage and data quality checks
• Familiarity with P&C source systems and standards (policy admin, billing, claims platforms; bordereaux, ISO statistical reporting, ACORD a plus)
• Self-directed contractor who partners with business SMEs to translate insurance rules into pipeline logic