BI Architect, Insurance (Chicago)

Gallagher Bassett NZ Ltd Rolling Meadows , IL 60008

Posted 6 months ago

Risk Placement Services, Inc. is one of the nation's largest specialty wholesale insurance brokerage firms. We work with top-rated carriers to design robust coverage for our clients. Our employees are fueled by a culture built around teamwork, creativity and responsiveness.

Specialties of RPS:

Wholesale Broker and Managing General Agent, Casualty, Property, Analytics, Healthcare, Workers Compensation, Transportation, Executive Lines, Technology & Cyber, Public Entity, Personal Lines.

Position Summary:

The BI Architect provides data management expertise to our clients in evaluating requirements and developing data architecture and BI solution design. Data management includes appropriate structure, stewardship of data, semantics/syntax of data attributes, coding structures, and mapping schemes.

  • A certain degree of creativity and latitude is required as well as flexibility in job role and working hours during critical deliveries

  • Liaise and attend meetings necessary to perform duties and aid business and technical development

Essential Duties and Responsibilities:

  • Partners with business departmental teams to define and document business requirements

  • Architect, Designing, building, enhancing, maintains, and support data marts, and analytic engines, BI reports and Bi Transformation Code

  • Queries, analyzes, and interprets complex data stored in the target systems

  • Identify data quality issues and see through to resolution

  • Test and validate data flow, data cubes and reports

  • Assist in the Design of logical Data Warehouse architecture and data model, and implement physical design (schema, indexes, partitions, etc.)

  • Assist Design of ETL architecture including CDC, mappings, data flows, procedures, schedules, etc

  • Designing, developing, and testing data management matching, merging, consolidation, purging, and cleansing and extraction, transformation, and loading (ETL) functionality

  • Apply Microsoft BI expertise in system architecture design and hands on development and maintenance of BI systems

  • Use agile methodology to perform requirement gathering, functional analysis, Iterative Design and development, testing, and deployment.

  • Installing, configuring, and, if necessary, customizing analytics management tools

  • Assist with hardware, software, and data communications architecture and sizing

  • Contribute to the development and support of ongoing production services


  • Bachelor's Degree in computer science

  • Microsoft Power BI certification is preferred

  • 7 years of experience working with insurance data; understands relationships of premiums, claims, and reinsurance data

o Understands KPIs, contract, claim, and reinsurance data life cycles

  • 7 years of experience in data warehousing and/or business intelligence unit working with business and IT

  • Very strong technical knowledge in ETL tools (SQL Server SSIS), Databases (SQL Server 2012), OLAP tools (Microsoft SSAS), Reporting Tools (Microsoft SSRS, Power BI)

  • Ability to work along or in conjunction with the DBA

  • Prior experience with implementation on AZURE Data Factory Architecture

  • Knowledge of SQL DW upgrade and cloud migration strategies

  • Experience with the setup and configuration of Power BI (Power Query, Data Management Gateway, SSAS Tabular Connector)

  • Understanding of operational issues and constraints (e.g. error handling, security)

  • Has good knowledge of standard methodologies, concepts, best practices, and procedures within a Business Intelligence environment

U.S. Eligibility Requirements:

  • 18 years of age or older.

  • Willing to submit to a background investigation; any offer of employment is conditioned upon the successful completion of a background investigation.

  • Unrestricted work authorization to work in the U.S. For U.S. employment opportunities, Risk Placement Services, Inc. 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. RPS will require proof of work authorization.

  • Willing to execute RPS' Employee Agreement or Confidentiality and Non-Disclosure Agreement which requires, among other things, post-employment obligations relating to non-solicitation, confidentiality and non-disclosure.

RPS 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.

Risk Placement Services, Inc. is a division of Arthur J. Gallagher and 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, RPS 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.


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Retail Management Chicago Southside And Surrounding Area

Gamestop Corp.

Posted 2 weeks ago

VIEW JOBS 10/7/2019 12:00:00 AM 2020-01-05T00:00 Job Snapshot * Location: 1645 West Algonquin Road Rolling Meadows, IL * Job Type: GameStop Retail Management * Experience: Not Specified * Date Posted: 10/15/2019 Job Description PLEASE NOTE: Your application for this position includes all locations within the district. District Manager – role is similar to an innovative business entrepreneur and owner, with special emphases on comp sales, used sales, talent retention, trades, guest experience, and loss prevention. Within GameStop's broadly defined parameters, District Leaders have the autonomy, authority, and responsibility to inspire outstanding business results through others as the leaders of their district's performance development strategy. Store Manager – directly influences the performance of everyone who interacts with guests and supports a solution selling environment. The Store Leader is responsible for fostering a selling culture that creates unique, complete solutions that exceed guest's expectations. The Store Leader ensures best-in-class guest service for every GameStop guest by using elements of GameStop's buy, sell, trade, and reservation business model, the Circle of Life. The Store Leader makes discretionary decisions involving all sales initiatives, operational effectiveness, marketing, scheduling, employment, and all other aspects of the day-to-day business processes of a GameStop store, which will demonstrate the commitment to a unique solutions selling experience for all guests. Job Requirements Qualified District Manager candidates will possess the following: * 3 years of successful, related experience as a multi-unit leader required * Bachelor of Arts or Bachelor of Science from a regionally accredited college or university in a related field of study, such as business administration, is required, although equivalent experience may be accepted as a substitute * Proven ability to work productively with others, welcome and adapt well to change, communicate thoughts and feelings effectively, and receive and respond to feedback from others maturely Travel Requirements: 60 to 70% with occasional overnight stays. Qualified Store Manager candidates will possess the following: * Must be at least 18 years of age and present state-required proof of age documents * Must be able to provide genuine and friendly assistance to every guest during every visit * High school diploma or GED required; An Associate's or accredited Bachelor's degree with an emphasis in business, marketing, merchandising, or related field preferred * Three or more years of retail sales, guest service, and/or management/leadership experience required; at least 1 year of retail management experience preferred * Must be able to work alone and move throughout the store unassisted, for extended periods (up to 12 hours per day) * Must be able to lift and/or move objects and displays (up to 30 lbs.), bend, stoop, reach with arms and hands, and climb on ladders * Must be able to occasionally travel unassisted via car and/or plane to offsite conferences and meetings (less than 10%) * Must be able to work a minimum of 44 hours per week Gamestop Corp. Rolling Meadows IL

BI Architect, Insurance (Chicago)

Gallagher Bassett NZ Ltd