at Arthur J. Gallagher Service Company, LLC in Rolling Meadows, Illinois, United States
Job Description
100% telecommute role. Reports to company headquarters in Rolling Meadows, IL. Can work remotely or telecommute.
Job Duties:
- Build the infrastructure required for optimal ETL/ELT pipelines to ingest data from a wide variety of data sources
- Design solutions for data analytics and data science team members that assist them in building and optimizing our product into an innovative industry leader.
- Design analytics solutions that utilize the data pipeline to deliver actionable insights into customer acquisition, operational efficiency and other key business performance metrics.
- Work with partners including the Executive, Product, Data and Design teams to assist with datarelated technical issues and support their data infrastructure needs.
- Orchestrate large, complex data sets that meet functional/non-functional business requirements.
- Seek out, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability.
- Partner with data and analytics talent to strive for greater functionality in our data systems.
Required Minimum Position Qualifications: Bachelor’s degree in Engineering (any), Information Technology, or related field of study; and 5 years of experience in the job offered or related occupation in which the required experience was gained.
Position also requires demonstrated experience in the following:
- SQL queries against any RDBMS with query optimization
- Unit testing, software change management, and software release management
- Dev-Ops processes (including CI/CD) and Infrastructure as Code fundamentals
- Azure Data Factory, ADLS Gen 2, Logic Apps, Azure Functions, Databricks, Apache Spark, or SQL DW
- Data Lake, using Microsoft Azure Data Lake Storage
- Python, Scala, and Power Shell Scripting
- Performing root cause analysis
- Agile process and principles
