Lead Data Engineer
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Lead Data Engineer building Azure data platforms for Hinshaw & Culbertson, a national law firm. Owning pipelines, warehouse architecture, governance, and production data operations.
Responsibilities:
- Design, build, and maintain ETL/ELT pipelines integrating finance, HR, CRM, document management, and other enterprise systems
- Define and enforce data architecture standards, models, schemas, and storage patterns for cloud data warehouse and lakehouse platforms
- Lead implementation and operation of Azure Data Factory, Azure Databricks, Azure Data Lake Storage, and Azure Synapse Analytics
- Own enterprise data warehouse and lakehouse platforms, including models, ingestion pipelines, performance, reliability, and operational health
- Implement source control, branching, CI/CD, automated testing, deployment workflows, monitoring, and alerting
- Oversee scheduling, execution, reconciliation, and monitoring of production data workflows
- Identify and resolve data pipeline failures, data quality issues, and performance bottlenecks
- Partner with Information Governance and Security teams on data quality, lineage, reconciliation, stewardship, and source-of-truth ownership
- Translate stakeholder requirements into technical solutions and explain data concepts to non-technical audiences
- Ensure data solutions comply with security policies, confidentiality requirements, and regulatory obligations
- Evaluate emerging data, analytics, and AI capabilities and lead proof-of-concepts
- Provide design guidance, code reviews, and technical coaching to junior engineers or database professionals
- Lead data projects from initiation through delivery, coordinating internal teams and external vendors or consultants
- Ensure knowledge transfer and long-term sustainability
Requirements:
- 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, with 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 with monitoring, alerting, and reconciliation
- Experience with source control and deployment practices for data workflows, including Git and CI/CD pipelines
- Excellent written and verbal communication skills, including explaining 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
- Advanced experience with ADLS, Databricks, Azure Data Factory, and Synapse preferred
- Experience implementing enterprise data warehouses, data marts, and lakehouse architectures preferred
- Experience with Azure Data Factory, Talend, Boomi, or similar data integration platforms preferred
- Strong scripting and programming skills in Python, PowerShell, and/or .NET/C# preferred
- Familiarity with Power BI or Tableau preferred
- Experience with data governance, data quality controls, data cataloging, and lineage documentation preferred
- Law firm or professional services experience is a plus
- Relevant certifications, such as Microsoft Certified: Azure Data Engineer Associate, are a plus
Benefits:
- Competitive compensation
- Comprehensive benefits program
- Opportunities to work on enterprise-scale technology initiatives
- Reasonable accommodations to qualified individuals with disabilities
Similar Jobs
Director of Engineering, Data
Director leading Boulevard’s data platform for appointment-based self-care business software. Building scalable infrastructure, governance, analytics products, and ML/AI capabilities while growing the data engineering organization.
Principal Data Engineer
Principal Data Engineer leading scalable Azure/AWS and Databricks platforms for client projects. Driving architecture, resilience, governance, incident management, and strategic data engineering delivery.
Engenheiro de Dados – Pleno
Engenheiro de Dados construindo e gerenciando pipelines confiáveis para grandes volumes de dados na Reply, multinacional italiana de TI. Integrando fontes heterogêneas e soluções Big Data em AWS para apoiar análises e ciência de dados.
Data Engineer – Tieto Tech Consulting
Data Engineer designing scalable Azure, Snowflake, and Databricks data solutions for Tieto's technology consulting practice. Building ETL pipelines and supporting modern cloud data architecture.
Founding Data & AI Engineer – Creative Engine
Founding engineer building a data and AI creative intelligence engine for a performance creative agency. Developing pipelines, video analysis, semantic search, and full-stack dashboards.
Associate Enterprise Data Architect
Associate Enterprise Data Architect working with experienced architects and business leaders at Swisscom. Contributing to enterprise-wide data models and influencing technology decisions.
Big Data Architect
Big Data Architect focusing on data solutions, data products, and real-time streaming architectures. Collaborating in a fast-paced environment with emphasis on Agile practices.
Snowflake Data Engineer
Data Engineer focused on scalable data pipelines and workflows across cloud platforms for Lithia & Driveway. Collaborate with cross-functional teams to ensure reliable data ingestion and support enterprise reporting.
Snowflake Data Engineer
Data Engineer responsible for scalable data ingestion and transformation processes at Lithia & Driveway. Collaborating with teams to optimize cloud-based data solutions.
Engenheiro de Dados Sênior
Senior Data Engineer responsible for scalable data solutions at fast-growing consultancy. Collaborating with business areas for data requirements and architecture design.
Azure Data Lake Data Platform Specialist
Azure Data Lake Specialist designing and implementing scalable data platforms at BCD Meetings & Events. Integrating diverse data sources into a unified data lake and reporting layer.
Senior Databricks Data Engineer
Data Engineer tasked with reconstructing legacy data pipelines using Databricks. Collaborating on ingestion standards and performance optimization to transition to lakehouse architecture.
Ingeniero de Datos Senior
Senior Data Engineer working remotely on international financial projects involving data migration and AWS. Key responsibilities include ETL processes, data validation, and documentation.
Principal Data Engineer
Lead Data Engineering and data platform strategies at Safeguard Global. Focus on data quality, governance, and AI readiness in a global environment.
Lead Data Architect
Lead Data Architect specializing in data platform modernization for Data Meaning. Responsible for assessing architecture and guiding SQL transformations in a Snowflake environment.
AI Data Architect
AI Data Architect to design and govern the AI data platform at 3Pillar, facilitating AI initiatives across various business sectors.
Software Engineer, Technical Leader – Network Data Plane
Technical Leader designing and developing high-performance data plane software for Cisco Hypershield Smart Switches. Collaborating with engineering teams on innovative networking solutions.
Senior Software Engineer, Data Layer
Senior Software Engineer shaping the API platform connecting client applications to Coinbase's backend services. Owning critical systems that serve API requests at scale to improve performance and developer experience.
Data Engineer
Data Engineer focusing on large-scale data systems and ETL processes. Working with cross-functional teams on big data projects and transitioning into Databricks & AI/ML.
Senior Data Architect
Senior Data Architect at Blanc Labs responsible for designing enterprise data architecture strategies. Leading the implementation of AI-enabled data ecosystems across modern data platforms.