Data Engineer

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-related issues, ensuring high data quality and reliability.

• Monitor, optimize, and scale data workflows to improve performance and cost-efficiency.

• Develop and enforce best practices for data engineering processes, documentation, and governance.

Education

Required

• Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent practical experience in lieu of formal education.

• Legal IT experience a plus but not required

Skills and Experience

Required

• 2-4 years experience working with enterprise level relational and/or non-relational database and ETL/ELT technologies.

• Extensive experience with Azure Data Lake Storage, Azure Data Factory, Databricks, SQL Server, and Python.

• Demonstrated experience in the implementation and creation of both on-premise SQL Server Databases as well as Azure SQL Databases.

• Deep understanding of data modeling, ETL processes, data warehousing concepts, and data architecture.

• Advanced proficiency in SQL for complex querying and database management.

• Strong experience with Python for advanced data manipulation and automation tasks.

• In-depth knowledge of cloud computing concepts and services, particularly within Azure.

• Excellent problem-solving abilities and attention to detail.

• Exceptional communication skills and experience working collaboratively in a team-oriented environment.

• Experience with data governance and data quality frameworks.

• Familiarity with Azure services (e.g., Azure Synapse Analytics, Azure SQL Database, Cosmos DB) and big data technologies.

• Experience with semi-structured/NoSQL databases is a plus.

• Azure data certifications (e.g., Azure Data Engineer Associate) are a plus but not required.

Salary Information

NY Only: The estimated base salary range for this position is $150,000 to $175,000 at the time of posting.

The actual salary offered will depend on a variety of factors, including without limitation, the qualifications of the individual applicant for the position, years of relevant experience, level of education attained, certifications or other professional licenses held, and if applicable, the location in which the applicant lives and/or from which they will be performing the job. This role is exempt meaning it is not overtime pay eligible.

Simpson Thacher will not sponsor applicants for work visas for this position.

Privacy Notice

For information about how Simpson Thacher & Bartlett LLP collects and processes your personal information, please refer to our Privacy Notice available at https://www.stblaw.com/other/privacy-notice.

Simpson Thacher & Bartlett is committed to a collegial work environment in which all individuals are treated with respect and dignity. The Firm prohibits discrimination or harassment based upon race, color, religion, gender, gender identity or expression, age, national origin, citizenship status, disability, marital or partnership status, sexual orientation, veteran’s status or any other legally protected status. This Policy pertains to every aspect of an individual’s relationship with the Firm, including but not limited to recruitment, hiring, compensation, benefits, training and development, promotion, transfer, discipline, termination, and all other privileges, terms and conditions of employment.