A

Arthur J. Gallagher & Co.

Global insurance brokerage, risk management, consulting

Data Engineering Manager

Engineering LeadershipConfirmed live in the last 24 hours
Full-timeRolling Meadows, IL, USANo salary listedIn-person

About the Job

Requirements

  • A relevant technical Bachelor of Science degree in Information Technology.
  • Proven experience leading cross-functional teams, managing business users, and aligning technical and business objectives.
  • At least 5 years of experience leading a technical team.
  • At least 7 years of data engineering experience using technologies such as Snowflake, Azure Data Factory, ADLS Gen 2, Azure Functions, Databricks, Synapse, and SQL Server.
  • Demonstrated experience delivering data foundations for AI or machine learning workloads, such as feature pipelines, training datasets, embeddings and vector search, model deployment support, or large language model applications on enterprise data.
  • Practical understanding of governing AI use of sensitive data, including access control, masking, lineage, and auditability.
  • Understanding of the pros, cons, and best practices of implementing a data lake using Microsoft Azure Data Lake Storage.
  • Experience structuring a data lake for reliability, security, and performance.
  • Experience implementing ETL for data warehouse and business intelligence solutions.
  • Ability to read and write effective, modular, dynamic, parameterized, and robust code, and to establish and follow code standards and ETL frameworks.
  • Strong analytical, problem-solving, and troubleshooting abilities.
  • Understanding of unit testing, software change management, and software release management.
  • Knowledge of DevOps processes, including continuous integration and continuous delivery, and infrastructure as code fundamentals.
  • Experience performing root cause analysis on data and processes to answer business questions and identify opportunities for improvement.
  • Experience working within an agile team.
  • Demonstrated ability to communicate with and influence stakeholders at all levels.
  • Demonstrated ability to manage relationships with business users, address their concerns, and ensure their needs are met through communication and collaboration.
  • Experience navigating ambiguity and uncertainty in projects, with a track record of delivering successful outcomes.
  • Proven experience managing deliverables across multiple teams and providing ongoing support for data systems and integrations.

Responsibilities

  • Lead requirements gathering, scope definition, and technical design for data and integration workflows, providing strategic and architectural direction to the team.
  • Set and enforce engineering standards for code review, ETL/ELT frameworks, testing, documentation, and definition of done.
  • Identify risks in data initiatives and develop mitigation strategies; own production data systems and integrations, including service-level agreements, monitoring and alerting, incident response, and blameless post-incident reviews.
  • Contribute to platform and tooling selection, capacity planning, vendor evaluation, and budget forecasting, including cloud and platform consumption costs.
  • Hire, onboard, coach, and retain data engineers across onsite and offshore locations; own performance management, career development, and succession planning.
  • Build a scalable team operating model with clear ownership, sustainable on-call and support rotation, and fewer single points of failure.
  • Provide leadership, direction, and coordination for development and support teams across time zones, ensuring effective communication and collaboration.
  • Partner with data science and analytics leaders to align engineering capacity with modeling, reporting, and AI priorities.
  • Act as a liaison between technical teams and business users, ensuring data solutions meet business needs and addressing concerns directly.
  • Manage deliverables across multiple teams and products, ensuring timely completion and alignment with business priorities.
  • Communicate platform health, delivery status, and roadmap changes to technical and non-technical audiences.
  • Build and maintain infrastructure for ETL/ELT pipelines that ingest data from varied sources using cloud-native tools such as Azure Data Factory, Databricks, and Snowflake.
  • Construct and maintain enterprise integrations across Snowflake, Azure Synapse, Azure SQL, and SQL Server, including a plan to retire overlapping or legacy platforms.
  • Own data modeling standards, including dimensional modeling, Data Vault, or equivalents, and the semantic layer consumed by analytics and business intelligence tools.
  • Establish data quality, observability, lineage, and cataloging practices so consumers can assess dataset trust without assistance.
  • Design and implement process improvements by automating manual work, optimizing data delivery, and redesigning infrastructure for scalability and lower cost.
  • Build data tools and curated datasets used by analytics and data science teams, including reporting foundations for the business intelligence platform; reduce recurring support through automation, instrumentation, and permanent fixes.
  • Design and operate data foundations for AI, including feature pipelines, training and evaluation datasets, and reproducible, point-in-time-correct data for modeling.
  • Evaluate and integrate platform AI capabilities, such as in-warehouse large language model functions, managed model endpoints, and agent orchestration frameworks, and make build-versus-buy recommendations.
  • Establish guardrails for AI use of enterprise data, including personally identifiable information handling and masking, access controls, prompt and response logging, output evaluation, and auditability aligned with governance and regulatory requirements.
  • Promote effective and responsible AI use within the engineering team, including coding assistants, automated testing and documentation, and pipeline generation, measuring impacts on delivery throughput and quality.

About the Company

Arthur J. Gallagher & Co.

Global insurance brokerage, risk management, consulting

Arthur J. Gallagher & Co. is a global insurance brokerage and risk management firm. It helps businesses, public entities, and individuals manage risk and obtain insurance through three segments: brokerage, risk management, and corporate. The brokerage unit offers a full range of retail and wholesale insurance brokerage and consulting services to match clients with coverage. The risk management unit handles contract claim settlements, claim administration, loss control consulting, and risk management information services to reduce exposures. The corporate unit oversees the company’s clean energy and other investments. The firm differentiates itself by providing end-to-end risk solutions across insurance placement, claims handling, risk counseling, and investment activities, rather than focusing on a single service. Its goal is to help clients manage risk effectively, protect assets, and pursue value through diverse investments, including clean energy.

Company size
10,001+
Company stage
IPO
Headquarters
Itasca, IL
Founded
1927

Recently Posted Jobs

Explore more opportunities at Arthur J. Gallagher & Co.

See more jobs