Information Technology
RPS President
63221 Requisition #

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, Analytics , 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, Analytics Development

·        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

·        Knowledge of Alteryx Analytics to help with segmentation, fuzzy matching, data enrichments, trend analysis

·        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)

·        Working knowledge of Alteryx Analytics

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


My Submissions

Track your opportunities.

My Submissions

Similar Listings

RPS President

Chicago, Illinois, United States

📁 Information Technology

Requisition #: 63220

RPS President

Chicago, Illinois, United States

📁 Information Technology

Requisition #: 63218