Lead Data Engineer: Azure Data Platform & Analytics

Hinshaw & Culbertson LLP; Chicago (IL); On-site; USD 140,000 - 220,000; Full time

Job summary

Hinshaw & Culbertson LLP seeks a hands‑on Lead Data Engineer to design, build, and operate enterprise data integration and analytics platforms. You will own pipelines, data models, and production data operations, setting engineering standards to improve reliability and data quality.

You will partner with IT, Security, Governance, Finance, and practice groups to reduce silos, enable reporting, analytics, and AI initiatives while upholding security and compliance standards.

Qualifications

• Bachelor’s degree or equivalent practical experience.
• 8+ years in data engineering and ETL/ELT development.
• 3+ years designing cloud data platforms (Azure preferred).
• Strong SQL skills and relational DB design.

Responsibilities

• Design, build, and maintain ETL/ELT pipelines across core systems.
• Define data models, schemas, and storage patterns for cloud warehouses/lakehouse.
• Lead Azure data services implementation and operations.
• Own enterprise data warehouse and lakehouse platforms including ingestion pipelines.
• Implement DevOps/DataOps practices: CI/CD, testing, deployment & monitoring.
• Oversee production data workflows, resolve data quality and performance issues.
• Partner with governance and security teams on data quality and lineage.
• Collaborate with stakeholders to translate requirements into technical solutions.
• Ensure compliance with security policies and regulatory obligations.
• Lead continuous improvement and evaluate new data/AI capabilities.
• Provide technical leadership and mentorship to engineers.

Skills

MS SQL

Azure

Python/PowerShell/.NET

Git/CI-CD

Power BI/Tableau

Data modeling

Data governance

Communication

Education

Bachelor's degree in CS/Data Engineering/IS

Tools

Azure Data Factory

Azure Databricks

Azure Data Lake Storage

Azure Synapse Analytics

Talend/Boomi or similar

Git

Job description

Hinshaw & Culbertson LLP seeks a hands‑on Lead Data Engineer to design, build, and operate enterprise data integration and analytics platforms. You will own pipelines, data models, and production data operations, setting engineering standards to improve reliability and data quality.

You will partner with IT, Security, Governance, Finance, and practice groups to reduce silos, enable reporting, analytics, and AI initiatives while upholding security and compliance standards.