Lead Data Engineer

Hinshaw & Culbertson; 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

Lead Data Engineer

Firm Overview

Hinshaw & Culbertson LLP is a national law firm with more than 500 attorneys and professionals across the United States. Founded in 1934 and headquartered in Chicago, the firm provides sophisticated legal counsel to clients in highly regulated industries, including insurance, financial services, healthcare, and professional services, as well as to government agencies, educational institutions, and nonprofit organizations. Learn more at hinshawlaw.com.

Job Summary

The Lead Data Engineer is a hands-on technical leader responsible for designing, building, and operating enterprise-grade data integration and analytics platforms across the firm. This role owns core data pipelines, data models, and production data operations, and establishes engineering standards that improve reliability, data quality, and delivery speed. The Lead Data Engineer partners closely with IT, Information Security, Information Governance, Finance, Knowledge Management, Marketing/Business Development, and practice groups to reduce data silos, clarify data ownership, and deliver trustworthy data for reporting, analytics, and emerging AI initiatives.

Essential Job Functions

• Enterprise Data Integration & Pipelines: Design, build, and maintain robust ETL/ELT pipelines that integrate data from core firm systems (finance, HR, CRM, document management, and other enterprise platforms). Ensure data is delivered accurately, securely, and on schedule.
• Data Architecture & Modeling: Define and enforce data architecture standards, including data models, schemas, and storage patterns for cloud-based data warehouse and lakehouse platforms. Optimize for performance, scalability, and analytical use.
• Cloud Data Platform Management: Lead the implementation and operation of Microsoft Azure-based data services, including Azure Data Factory, Azure Databricks, Azure Data Lake Storage, and Azure Synapse Analytics. Manage development, test, and production environments with focus on cost efficiency and reliability.
• Own the firm’s enterprise data warehouse and lakehouse platforms, including data models, ingestion pipelines, performance, reliability, and ongoing operational health."\
• DevOps / DataOps Practices: Implement source control, branching strategies, CI/CD pipelines, automated testing, deployment workflows, monitoring, and alerting for data pipelines and related code.
• Production Data Operations: Oversee scheduling, execution, reconciliation, and monitoring of production data workflows. Proactively identify and resolve failures, data quality issues, and performance bottlenecks before they impact reporting or operations.
• Data Governance & Quality: Partner with Information Governance and Security teams to implement data quality standards, lineage documentation, reconciliation processes, and stewardship models. Help define and enforce “source of truth” ownership for critical datasets.
• Cross-Functional Collaboration: Work with business stakeholders to translate requirements into technical solutions and communicate complex data concepts in clear, non-technical terms. Ensure solutions align with firm strategy and operational priorities.
• Security & Compliance: Ensure data integration and storage solutions comply with firm security policies, client confidentiality requirements, and applicable regulatory obligations. Implement access controls, encryption, and auditing where appropriate.
• Innovation & Continuous Improvement: Evaluate emerging data, analytics, and AI capabilities and lead proof-of-concepts that improve reliability, usability, and business value.
• Technical Leadership & Mentorship: Provide design guidance, code reviews, and technical coaching to junior engineers or database professionals as applicable. Establish repeatable patterns and standards.
• Project & Vendor Management: Lead data-focused projects from initiation through delivery, coordinating internal teams and external vendors/consultants. Ensure knowledge transfer and long-term sustainability.

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

Preferred Skills

• Advanced experience with Azure data services (ADLS, Databricks, Azure Data Factory, Synapse).
• Experience implementing enterprise data warehouses, data marts, and lakehouse architectures.
• Experience with data integration tools such as Azure Data Factory, Talend, Boomi, or similar platforms.
• Strong scripting and programming skills (Python, PowerShell, and/or .NET/C#) for data processing and custom integrations.
• Familiarity with business intelligence and analytics tools such as Power BI or Tableau.
• Experience with data governance frameworks, data quality controls, data cataloging, and lineage documentation.
• Experience in a law firm or professional services environment is a plus, including familiarity with systems such as Elite 3E, Aderant, iManage, NetDocuments, Intapp/InterAction, or similar platforms.
• Relevant certifications (e.g., Microsoft Certified: Azure Data Engineer Associate) are a plus.

Why Join Hinshaw?

At Hinshaw, we foster a collaborative and inclusive work culture. We offer competitive compensation, a comprehensive benefits program, and opportunities to work on enterprise-scale technology initiatives that directly support the firm’s strategic objectives. The Lead Data Engineer will play a critical role in shaping the firm’s data foundation and enabling analytics, reporting, and innovation across the organization.

Equal Opportunity Statement

Hinshaw & Culbertson LLP is an Equal Opportunity Employer. The firm is committed to providing equal employment opportunities and reasonable accommodations to qualified individuals with disabilities.