Lead Data Engineer - Azure Data Platform

Hinshaw & Culbertson LLP; United States; On-site; USD 140,000 - 190,000; Full time

Job summary

Hinshaw & Culbertson LLP is seeking a Lead Data Engineer to design, build, and operate enterprise‑grade data integration and analytics platforms across the firm. You will own core pipelines, models, and production data operations, partnering with IT, Security, Finance, and practice groups to deliver trustworthy data for reporting, analytics, and AI initiatives.

The role requires guiding engineering standards, mentoring junior engineers, and driving DevOps practices to ensure reliability and data

Qualifications

• Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related field, or equivalent practical experience.
• 8+ years of hands‑on experience in data engineering, ETL/ELT development, and data integration.
• 3+ years of experience designing and operating cloud‑based data platforms (Microsoft Azure preferred).
• Strong MS SQL skills and experience with relational database design, development, and performance tuning (SQL Server preferred).
• Experience building reliable production data pipelines, including monitoring, alerting, and reconciliation.
• Experience with source control and deployment practices for data workflows (e.g., Git and CI/CD pipelines).
• Excellent written and verbal communication skills, including ability to explain technical concepts to non‑technical audiences.
• Ability to handle sensitive and confidential information with discretion and professionalism.
• Availability for occasional after‑hours work for major releases or production incidents.

Responsibilities

• Design, build, and maintain ETL/ELT pipelines that integrate data from core firm systems and ensure data is delivered accurately, securely, and on schedule.
• Define and enforce data architecture standards, including data models and storage patterns for cloud platforms.
• Lead the implementation and operation of Azure-based data services and manage development, test, and production environments.
• Own the firm’s enterprise data warehouse and lakehouse platforms, including ingestion pipelines and performance.
• Implement DevOps/DataOps practices: CI/CD pipelines, automated testing, monitoring, and alerting.
• Oversee production data operations: scheduling, execution, reconciliation, and issue resolution.
• Partner with governance and security teams to ensure data quality, lineage, and ownership.

Skills

communication

leadership

problem solving

Education

Bachelor’s degree in Computer Science or related field

Tools

Azure Data Factory

Azure Databricks

Azure Data Lake Storage

Azure Synapse Analytics

SQL Server

Git

CI/CD

Python

PowerShell

.NET/C#

Power BI

Job description

Hinshaw & Culbertson LLP is seeking a Lead Data Engineer to design, build, and operate enterprise‑grade data integration and analytics platforms across the firm. You will own core pipelines, models, and production data operations, partnering with IT, Security, Finance, and practice groups to deliver trustworthy data for reporting, analytics, and AI initiatives.

The role requires guiding engineering standards, mentoring junior engineers, and driving DevOps practices to ensure reliability and data