Senior Data Engineer

TM Senior Data Engineer

• Home
• Vacancies
• Senior Data Engineer

Senior Data Engineer

REMOTE Azure data stack Data Warehouse 5+ years of experience B2 English level fluency SQL databases

We're looking for a Senior Data Engineer to join an ambitious Data Warehouse project for a large US insurance client. The project focuses on building a robust and high-performance data platform that consolidates financial data from multiple enterprise sources to support data-driven decision-making across Finance, Accounting, and other key business departments. You will become part of a collaborative international team working with modern cloud technologies and large-scale enterprise data.

apply

Major responsibilities:

• Design, develop and optimize scalable ETL processes and data pipelines
• Develop and maintain BI solutions, data marts and analytical datasets
• Design and optimize complex SQL scripts, procedures, and data processing workflows
• Manage risks and dependencies by identifying technical and delivery threats such as data quality, legacy alignment and capacity, communicating them to stakeholders, and proposing pragmatic mitigations early
• Align stakeholders by defining and agreeing on approaches and trade‑offs, presenting options and recommendations, and running demos to validate progress and demonstrate value
• Provide technical leadership with hands‑on delivery by reviewing and enforcing architecture, designs, code and SQL/notebooks, and by implementing critical components to ensure consistent quality.

We'd love to hear from you if you have:

• Minimum of 5 years of experience in data engineering, with at least 2–3 years focused on the Azure cloud ecosystem
• Expert in SQL with proven ability to write and optimize complex analytical queries, stored procedures and functions
• Deep knowledge of PySpark and Python for large-scale data processing and building ETL/ELT pipelines
• Understanding data organization principles within a Data Lake (Raw, Silver, Gold layers)
• Experience in administration and development within managed instance environments
• Knowledge of data modeling methodologies (Kimball/Inmon), understanding of Slowly Changing Dimensions (SCD), and history management
• Deep understanding of enterprise Data Warehouse architecture, including the design of dimension and fact tables, and the creation of aggregated data layers
• Financial/Insurance Data Experience, understanding of month-end close processes, data reconciliation, and financial calculation logic
• Experience in performing code reviews, designing pipeline architecture, and overseeing the technical quality of the team's output
• Experience working in Scrum teams, with the ability to decompose high-level business goals into specific technical tasks (User Stories/Tasks) and manage the delivery plan
• English level B2 or higher.
  

Nice to have:

• Experince orchestrating complex task chains in Azure Data Factory
• Knowledge of the insurance domain including premiums, commissions, premium taxes, and actuarial calculations
• Experience with BI tools such as Power BI and understanding how end users consume data from a DWH
• Practical experience performing lift-and-shift migrations of logic from legacy databases to a cloud-based warehouse
• Azure certification preferred, for example Microsoft Certified: Azure Data Engineer Associate (DP-203).