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.
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.
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
- Gallagher Jobs