All vacancies
Symfa

Lead Data Engineer

Symfa · remote · lead · full-time · $149500–$241500 USD
aidatatech AzureDWHSQLPySparkAzure Synapse AnalyticsAzure Data Lake Storage Gen2Azure SQL Managed Instancedata modelingScrum
9.0
AI Score
The vacancy is well-structured and informative, offering clarity on responsibilities and compensation.
Job description
We're looking for a Lead Data Engineer (Azure, DWH) to join a long-term project in the insurance domain. You will take ownership of a strategic initiative — building a modern cloud-based data warehouse that will replace legacy reporting and month-end processes. This role combines hands-on engineering, technical leadership, and direct collaboration with the client.
Responsibilities
- Act as a primary technical point of contact for the client, clarifying requirements and translating business goals into technical solutions - Own and drive the DWH delivery plan, including prioritization, planning, and progress tracking - Identify risks and dependencies (data, legacy systems, delivery) and proactively propose mitigation strategies - Perform code reviews and ensure high quality of SQL, PySpark, and data models across the team, ensure consistent quality and architectural alignment - Align technical solutions with stakeholders and present trade-offs and recommendations - Distribute tasks within the team and maintain a sustainable development pace.
Requirements
- 5+ years of experience in Data Engineering, including 2+ years in Azure - Expert-level SQL skills (complex analytical queries, performance optimization) - Strong experience with Azure Synapse Analytics, PySpark - Hands-on experience with Azure Data Lake Storage Gen2 and data layer design (Raw / Silver / Gold) - Experience with Azure SQL Managed Instance - Strong knowledge of data modeling (Kimball / Inmon, SCD, historical data handling) - Solid experience designing and building enterprise Data Warehouses (fact/dimension modeling, aggregation layers) - Experience in technical leadership (code reviews, architecture decisions, mentoring) - Experience working in Scrum teams and managing delivery from high-level requirements - English level B2+ (regular communication with the client).
About Symfa
Symfa is a global software service provider offering IT services and development, including roles like .Net Tech Leads for projects with US insurance companies. They hire for positions such as Lead Data Engineer, indicating involvement in data engineering and software projects for enterprise clients.
SaaS · Alexandria, Virginia, USA · https://symfa.com/jobs/lead_data_engineer
Apply to this role