AI Data Engineer
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.