
Senior Data Engineer
Simpson Thacher & Bartlett LLP
full-time
Posted on:
Location Type: Hybrid
Location: New York City • New York • United States
Visit company websiteExplore more
Salary
💰 $175,000 - $200,000 per year
Job Level
About the role
- 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, 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.
Requirements
- 5-7 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.
- 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.
- 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.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
ETL processesdata pipelinesAzure Data Lake StorageAzure Data FactoryDatabricksSQL ServerPythondata modelingdata warehousingcloud computing
Soft Skills
leadershipproblem-solvingattention to detailcommunicationcollaborationmentoringstrategic planningtroubleshootingoptimizationgovernance
Certifications
Azure Data Engineer Associate