Senior Data Engineer (Insurance)

Location: Remote

Company

hirify.global is hiring for an enterprise data warehouse project in the insurance domain.

What you will do

• Design, build, and maintain data infrastructure for large-scale processing, analytics, and reporting.
• Build and optimize ingestion, transformation, orchestration, ETL, and ELT pipelines integrating multiple data sources.
• Create dimensional data models, including star and snowflake schemas, fact tables, and dimension tables.
• Clean, validate, standardize, and prepare data across Bronze, Silver, and Gold layers for Power BI and other BI tools.
• Optimize queries, indexes, storage, Azure Synapse Dedicated SQL Pool, and other pipeline components for analytical workloads.
• Implement data quality checks, anomaly detection, access controls, data masking, documentation, and governance-compliant solutions.

Requirements

• 5+ years of experience in data engineering, including 2–3 years working with Azure.
• Strong SQL skills, including complex analytical queries, stored procedures, and performance optimization.
• Proficiency in Python and PySpark for large-scale data processing and ETL/ELT pipeline development.
• Hands-on experience with Azure Synapse Analytics, including Dedicated SQL Pool and Synapse Pipelines.
• Understanding of Medallion Architecture and experience building scalable data warehouses.
• Experience with dimensional data modeling, including star schemas, fact tables, and dimension tables.
• Knowledge of data cleaning, validation, standardization, and other data quality practices.
• Experience preparing analytics-ready data for Power BI or other BI tools.
• English level B2 or higher.

Nice to have

• Knowledge of the insurance domain.
• Experience with SQL Server Integration Services (SSIS) for ETL packages and data integration workflows.

Culture & Benefits

• Remote work format.