DataJobs.io
← Back to all jobs

Job Description

At Gallagher, you will help build and evolve data infrastructure that supports data generation, extraction, transformation, and loading for analytics and data science teams. This onsite role in Rolling Meadows, IL focuses on scalable pipelines, secure data separation across AWS regions, and tooling that enables teams to deliver actionable insights.

Compensation: USD 100,000 - 195,000 per year

What you can expect: a collaborative, people-first culture with accessible leadership, comprehensive benefits designed to support well-being, and career development and ongoing learning opportunities. You’ll also have the opportunity to contribute to meaningful work with global reach and local impact.

Responsibilities

  • Develop, maintain, and test infrastructures for data generation.
  • Create and maintain optimal data pipeline architecture to assemble and deliver data aligned with business needs.
  • Assemble large, complex datasets that satisfy functional and nonfunctional business requirements.
  • Identify, design, and implement internal process improvements, including automation of manual workflows to optimize data delivery and scalability.
  • Build infrastructure to support efficient extraction, transformation, and loading from a wide variety of data sources using SQL and big data technologies.
  • Work with stakeholders including the Executive, Product, Data, and Design teams to support data infrastructure needs and resolve data-related technical issues.
  • Keep data separated and secure across national boundaries using multiple data centers and AWS regions.
  • Create data tools that help analytics and data science team members build and optimize products.
  • Oversee data generation infrastructure.
  • Build analytics tools that provide actionable insights and support data science and analytics teams with best-in-class product development.
  • Collaborate with stakeholders to address data-related technical issues and strengthen infrastructure capabilities.

Requirements

  • Typically requires a University Degree and minimum 5 years of prior relevant experience, or equivalent experience.

Skills & Technologies

  • Core: SQL, Python, Azure Data Factory, Spark, AWS.
  • Preferred: SQL, Python, Azure Data Factory, Data Bricks, Spark (experience is a plus), data transformation, cloud data experience, distributed data warehouse knowledge, and data lakes.
  • Preferred: communication and stakeholder management skills.

How You’ll Work

  • Apply advanced knowledge of sub-functions typically obtained through advanced education and work experience.
  • Manage products, systems, and/or projects and work independently with limited supervision.
  • Face IT-function-related problems that are sometimes difficult and moderately complex.
  • Coach and review the work of lower-level professionals.

Similar Jobs