Remote Senior Data Engineer- Azure Synapse & Data Warehouse

Symfa Inc.; United States; Remote; USD 140,000 - 210,000; Full time

Job summary

Symfa Inc. is seeking a Senior Data Engineer to join an enterprise data warehouse project in the insurance domain. You will design data ingestion, transformation, and orchestration pipelines across Bronze, Silver, and Gold layers, and optimize Azure Synapse for analytical workloads.

You will build dimensional models and ensure data quality for analytics-ready outputs. You will collaborate with business analysts and engineers, develop validation frameworks, and maintain comprehensive

Qualifications

• 5+ years of data engineering experience.
• 2-3 years working with Azure.
• Strong SQL skills with complex analytical queries and performance optimization.
• Python/PySpark for large-scale data processing and ETL/ELT pipelines.
• Hands-on experience with Azure Synapse Analytics, including Dedicated SQL Pool and Pipelines.
• Understanding of Medallion Architecture (Bronze, Silver, Gold) and scalable data warehouses.
• Experience with dimensional data modeling (star/snowflake schemas).
• Knowledge of data quality practices, data cleaning, validation, and standardization.
• Experience preparing analytics-ready data for Power BI or other BI tools.
• English level B2 or higher.

Responsibilities

• Design, build, and maintain data infrastructure for large-scale processing, analytics, and reporting.
• Create and maintain dimensional data models to support efficient querying.
• Build and optimize ETL pipelines from multiple sources.
• Optimize queries, indexes, and storage for performance.
• Implement data quality checks and validation frameworks.
• Develop validation processes to detect data anomalies.
• Translate business requirements into technical solutions in collaboration with stakeholders.
• Maintain documentation of data flows, schemas, and processes.
• Implement access controls and data masking; ensure governance and regulatory compliance.

Skills

Azure

SQL

Python

PySpark

ETL/ELT

Data Warehousing

Dimensional modeling

Data quality

Data governance

Performance tuning

Tools

Azure Synapse Analytics

SSIS

Power BI

Job description

Symfa Inc. is seeking a Senior Data Engineer to join an enterprise data warehouse project in the insurance domain. You will design data ingestion, transformation, and orchestration pipelines across Bronze, Silver, and Gold layers, and optimize Azure Synapse for analytical workloads.

You will build dimensional models and ensure data quality for analytics-ready outputs. You will collaborate with business analysts and engineers, develop validation frameworks, and maintain comprehensive