Gallagher Microsoft BI Developer in Rolling Meadows, Illinois

Arthur J. Gallagher & Co., one of the world's largest insurance brokerage and risk management services firms, provides a full range of retail and wholesale property/casualty (P/C) brokerage and alternative risk transfer services globally, as well as employee benefit brokerage, consulting and actuarial services. Gallagher also offers claims and information management, risk control consulting and appraisal services to clients around the world. If you're looking for a professional career with an industry leader then you have come to the right place. Wherever your interests lie, we're sure you will agree on one thing: our continued prosperity hinges on our greatest resource --- our people.


The candidate must demonstrate broad knowledge of BI development in a dimensional database environment while using the Microsoft BI Stack (PowerBI, SSRS, SSIS, SSAS). Candidate will be responsible for designing, developing, testing and troubleshooting BI solutions. The candidate must possess good communication skills and be able to work with business partners to understand and analyze requirements. The developer will use their MS BI Stack knowledge (2012 and later) to implement robust, maintainable solutions that meet business requirements.

Job Responsibilities:

  • Troubleshoot and optimize new and existing MS BI Stack solutions

  • Design, development, and testing of MS BI Stack Solutions, and reusable components to implement specified business requirements

  • Develop scripts for data file processing and process integration tasks.

  • Create technical specification documents and design process diagrams

  • Develop functional specifications for data acquisition, transformation and load processes

  • Conduct code reviews and participate in technical design

  • Prepare unit test, integration test plan documents and perform unit test, system integration test; document test results

  • Support BI Team during functional, UAT, regression, and performance testing


  • Bachelor's degree and 3 or more years related experience required.

  • Competent to work on most phases of applications systems analysis and programming activities, but requires instruction and guidance in other phases.


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 require, 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, color, religion, sex, age, veteran status, disability, national origin, or any other legally protected status. 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: Corp - Home Office

Title: Microsoft BI Developer

Location: Illinois-Rolling Meadows

Requisition ID: 45130