Experience Inc. Jobs

Job Information

Gallagher Data Modeler / ETL Developer in Rolling Meadows, Illinois

Gallagher Bassett is the premier provider of global claims services, dedicated to exceptional customer service and demonstrably superior outcomes. GB helps people, teams and businesses overcome adversity and loss through the guiding expertise of over 5,000 claims professionals, all committed to going beyond expectations in the continuous pursuit of a better way.

Position Summary

Gallagher Bassett is searching for a meticulous and experienced Data Modeler/ETL Lead to join our talented team. Your central responsibility as the Data Architect will be to develop, optimize and oversee conceptual and logical data systems.

To succeed in this role, you must be able to conceive and portray the data picture. This individual initiates, evaluates, and influences projects, he or she is involved from the perspective of the entire organization. The ideal candidate will also have proven experience in data modeling, data integration, data analysis, with excellent analytical, communication, and problem-solving abilities.


  • Competitive salary and benefits

  • Fun and flexible work environment

  • Apprenticeship model with significant development opportunities and emphasis on professional growth

  • Challenging, thought-provoking work on high-performing team with significant impact to the organization


  • Design and implement effective and scalable database solutions and models to store and retrieve organization data.

  • Responsible for the architecture, modeling, design, development, testing, implementation and maintenance of the ETL, procedures and structures which populate and grow our databases, data marts and tables.

  • Provide direction to fellow ETL developers on solution design and implementation. Ensuring standards are being followed.

  • Develop data flows that can leverage both on premise and cloud architectures.

  • Work with stakeholders including the business analytics teams and IS architecture teams to assist with data-related technical issues and support their data infrastructure needs.

  • Monitor system performance by performing regular tests, troubleshooting and integrating new features.

  • Guide and coach staff members on standards, guidelines, best practices and adherence to set standards.


  • Bachelor's degree and 5 years related experience or an equivalent combination of education, training, and experience is required.

  • Competent to work at the highest technical level of all phases of applications systems analysis and programming activities.

Job Qualifications:

  • 7 years of architecting and building medium to large scale enterprise data warehouses preferred in Microsoft SQL Server, Azure Data Warehouse/Database.

  • 3 years of data modeling experience utilizing tools such as Erwin, Power Designer, Enterprise Architect.

  • Proficiency with data integration tools such as SISS and Azure Data Factory, in-depth hands-on experience with SQL, TSQL, and data formats such as XML and JSON.

  • In-depth understanding of data integration, data quality, and multi-dimensional design.

  • Proven experience with implementing data warehouse architecture standards, processes, and methodologies.

  • Excellent organizational and analytical abilities with problem solving skills.

  • Able to hit the ground running with a can-do attitude.

  • Good written and verbal communication skills.

U.S. Eligibility Requirements:

  • Interested candidates must submit an application and resume/CV online to be considered

  • Must be 18 years of age or older

  • Must be willing to submit to a background investigation; any offer of employment is conditioned upon the successful completion of a background investigation

  • Must have unrestricted work authorization to work in the United States. For U.S. employment opportunities, Gallagher hires U.S. citizens, permanent residents, asylees, refugees, and temporary residents. Temporary residence does not include those with non-immigrant work authorization (F, J, H or L visas), such as students in practical training status. Exceptions to these requirements will be determined based on shortage of qualified candidates with a particular skill. Gallagher will require proof of work authorization

  • Must be willing to execute Gallagher's Employee Agreement or Confidentiality and Non-Disclosure Agreement which requires, among other things, post-employment obligations relating to non-solicitation, confidentiality and non-disclosure

Gallagher offers competitive salaries and benefits, including: medical/dental/vision plans, life and accident insurance, 401(K), employee stock purchase plan, educational expense reimbursement, employee assistance program, flexible work hours (availability varies by office and job function) training programs, matching gift program, and more.

Gallagher believes that all persons are entitled to equal employment opportunity and does not discriminate against nor favor any applicant because of race, sex, color, disability, national origin, religion, creed, age, marital status, citizenship, veteran status, gender, gender identity / expression, actual or perceived sexual orientation, or any other protected characteristic.‚Äč Equal employment opportunity will be extended in all aspects of the employer-employee relationship, including, but not limited to, recruitment, hiring, training, promotion, transfer, demotion, compensation, benefits, layoff, and termination. In addition, Gallagher will make reasonable accommodations to known physical or mental limitations of an otherwise qualified applicant with a disability, unless the accommodation would impose an undue hardship on the operation of our business.


Job: Information Technology

Organization: GB Overhead

Title: Data Modeler / ETL Developer

Location: Illinois-Rolling Meadows

Requisition ID: 73532