Simpson Thacher & Bartlett LLP

Data Engineer

• 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.

• 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.

Senior Data Engineer

Manager

• Provide high-value competitive intelligence and evidence-based recommendations to support business development and strategic decision-making.
• Design and execute competitive intelligence research and analysis of competitors, market shifts, industry trends and external forces shaping the legal and professional services landscape.
• Work with the Strategic Intelligence Director to lead competitive intelligence research and analysis and produce strategic reports on key competitors, market shifts and emerging industry trends and opportunities.
• Monitor industry and regulatory developments affecting the legal services market, identifying implications and recommended actions.
• Produce concise, high impact briefing materials and executive level reports to support strategic planning, business development, innovation and investment decisions.
• Develop and maintain competitive intelligence framework and research methodologies, including internal and external data sources, tracking systems, and reporting workflows.
• Conduct competitive market benchmarking, opportunity assessment, client portfolio analysis and white-space research.
• Support strategic projects related to growth initiatives, lateral hiring analysis, geographic expansion and product / service development.
• Ensure compliance with ethical and professional standards in competitive intelligence activities.
• Engage in coaching, mentoring and developing competitive intelligence skills and capabilities across the Strategic Intelligence team.

Manager – Strategic Intelligence

Artificial Intelligence

• Lead implementation of Medallion architecture (Bronze, Silver, Gold layers).
• Oversee lifecycle management of enterprise data platforms.
• Advance the firm’s Data Modernization capabilities.
• Operationalize scalable data ingestion transformation, governance and reporting frameworks.
• Operations Management (including incident, problem, and change monitoring)
• Promote a culture of accountability and transparency with clear line of sight to goals
• Promote a culture of continuous improvement and service excellence
• Demonstrate ability to manage timeframes involving multiple functions
• Think critically and make quick decisions to address Firm challenges effectively
• Translate technical concepts for non-technical audiences
• Demonstrate flexibility and agility in adapting to changing needs and priorities
• Facilitate solutions for Microsoft tools like Azure OpenAI Service, Microsoft Purview, SharePoint Syntex, and Copilot into legal workflows
• Collaborate with IT to ensure robust architecture, data governance, and security for Azure-based AI solutions
• Ensure alignment between AI initiatives and enterprise cloud strategy, data privacy regulations, and legal risk frameworks.

Data Engineer

Senior Data Engineer

Manager – Strategic Intelligence

Senior Manager, Data & Generative AI