JobMesh

Data Engineer

Simpson Thacher & Bartlett LLP · US

The Data Engineer is responsible for developing, maintaining, and optimizing data pipelines and analytics solutions across the Microsoft data ecosystem.

Job description

The Data Engineer is responsible for developing, maintaining, and optimizing data pipelines and analytics solutions across the Microsoft data ecosystem. This role focuses on building reliable ETL/ELT workflows using Azure Data Factory, Databricks, Microsoft Fabric, SQL Server, and Python to support reporting, analytics, and data science initiatives. The engineer collaborates with senior team members, analysts, and business partners to deliver clean, well structured data while contributing to the modernization of cloud-based data platforms. This position requires strong technical fundamentals, attention to detail, and a desire to grow into more advanced engineering and architectural responsibilities. Essential Job Duties & Responsibilities: Oversee the development and optimization of SQL Server databases and queries to meet complex reporting and analytical needs. Write and maintain Python scripts for sophisticated data transformation, analysis, and automation tasks. Collaborate with cross-functional teams, including data scientists, analysts, and business stakeholders, to understand and translate data requirements into technical solutions. Troubleshoot and resolve complex data-relat...