Stblaw
Senior Data Engineer
New York, NY · Senior
No sponsorship$175k-$200kDetected 30 days ago
PythonSQLNoSQLDatabricksAzureMachine LearningData EngineeringLeadershipCommunicationProblem Solving
About the role
- Salary Information NY Only: The estimated base salary range for this position is $175,000 to $200,000 at the time of posting.
- This role is exempt meaning it is not overtime pay eligible.
- Simpson Thacher will not sponsor applicants for work visas for this position.
Requirements
- Demonstrated leadership skills, with the ability to mentor and guide junior team members.
Nice to have
- Oversee the development and optimization of SQL Server databases and queries to meet complex reporting and analytical needs.
- Spearhead data migration projects from on-premises systems to Azure cloud services, ensuring strategic planning, minimal disruption, and data integrity.
- Troubleshoot and resolve complex data-related issues, ensuring high data quality and reliability.
- Legal IT experience a plus but not required
- Azure data certifications (e.g., Azure Data Engineer Associate) are a plus but not required.
Skills
- 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.
- Excellent problem-solving abilities and attention to detail.
- 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.
Compensation
- NY Only: The estimated base salary range for this position is $175,000 to $200,000 at the time of posting.
- This role is exempt meaning it is not overtime pay eligible.
- 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.
Visa & Work Authorization
- Simpson Thacher will not sponsor applicants for work visas for this position.
This listing is sourced directly from Stblaw's careers page and normalized into a canonical job model.