STB is currently seeking a highly experienced Senior Data Engineer with expertise in Azure Data Lake Storage, Azure Data Factory (ADF), Databricks, SQL Server, and Python, as well as a strong background in migrating data from on-premises systems to the cloud. The ideal candidate will have extensive experience in designing, building, and maintaining complex data pipelines and solutions to drive our business forward and ensure successful cloud migrations.
Responsibilities:
- Lead the design, development, and implementation of advanced data pipelines and ETL processes using Azure Data Lake Storage and Azure Data Factory.
- Architect and manage scalable data solutions on Databricks for high-performance data processing and analytics.
- 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.
- Spearhead data migration projects from on-premises systems to Azure cloud services, ensuring strategic planning, minimal disruption, and data integrity.
- Collaborate with cross-functional teams (data scientists, analysts, 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:
- Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent practical experience.
- Legal IT experience is a plus but not required.
Skills and Experience:
- Extensive experience with Azure Data Lake Storage, Azure Data Factory, Databricks, SQL Server, and Python.
- Demonstrated experience in both on-premise SQL Server Databases and Azure SQL Databases.
- Deep understanding of data modeling, ETL processes, data warehousing concepts, and data architecture.
- Proven track record of managing and executing large-scale data migration projects from on-premises to cloud environments.
- 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.
- Demonstrated leadership skills with the ability to mentor and guide junior team members.
- Excellent problem-solving abilities and attention to detail, alongside exceptional communication skills and collaborative experience in team-oriented environments.
- 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 is a plus.
- Experience with semi-structured/NoSQL databases and Azure data certifications (e.g., Azure Data Engineer Associate) is a plus but not required.
Compensation:
- The estimated base salary range for this position is $155k to $180k at the time of posting.
- The actual salary offered will depend on factors such as qualifications, relevant experience, education level, certifications, and location.
- This role is exempt, meaning it is not overtime pay eligible.
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, age, national origin, citizenship status, disability, marital or partnership status, sexual orientation, protected 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.
.png)
