DeveloperJobs.io
← Back to all jobs

Job Description

Join Gallagher in Rolling Meadows, IL to build and scale the data infrastructure that supports analytics, data science, and product delivery. This onsite role combines hands-on pipeline and data platform work with a collaborative, people-first culture and accessible leadership, along with competitive compensation and comprehensive benefits programs designed to support your well-being.

In this position, you will develop, maintain, and test data pipeline architecture for data generation, extraction, transformation, and loading (ETL/ELT). You will work with SQL and big data technologies to enable secure, reliable data handling across multiple stakeholders, including teams supporting analytics and data science.

What you’ll do

  • Develop, maintain, and test infrastructure for data generation
  • Create and maintain optimal data pipeline architecture to assemble data that supports business needs
  • Assemble large, complex datasets aligned with functional and nonfunctional requirements
  • Identify and implement internal process improvements, automating manual processes to optimize data delivery and redesign infrastructure for scalability
  • Build infrastructure for extraction, transformation, and loading from a wide range of data sources using SQL and big data technologies
  • Work with stakeholders including Executive, Product, Data, and Design teams to resolve data-related technical issues and support infrastructure needs
  • Keep data separated and secure across national boundaries using multiple data centers and AWS regions
  • Create data tools for analytics and data science teams to support building and optimizing products
  • Oversee data generation infrastructure and build analytics tools to provide actionable insights
  • Collaborate with stakeholders to support data infrastructure needs and address technical challenges

Technologies you’ll use

  • SQL
  • Python
  • Azure Data Factory
  • Spark
  • AWS

What you bring

  • Typically requires a University Degree and minimum 5 years of prior relevant experience (or equivalent experience)
  • Experience supporting cloud data environments and distributed data warehouse concepts
  • Communication and stakeholder management skills

Preferred experience

  • SQL, Python, Azure Data Factory
  • Data transformation and cloud data experience
  • DataBricks (experience is a plus)
  • Spark (experience is a plus)
  • Data Lakes

Growth and impact

Gallagher offers career development opportunities and ongoing learning, plus the opportunity to do meaningful work with global reach and local impact.

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

Career level expectations: Advanced knowledge typically obtained through advanced education and work experience; managing products, systems, and/or projects/processes with independent work and limited supervision; facing IT function related problems that are sometimes difficult and moderately complex; coaching and reviewing the work of lower-level professionals.

Similar Jobs