Data Architect & Analytics Development

Information Technology
RPS President
71159 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 Data Analytics Architect provides data Analytics expertise to our clients in evaluating requirements and developing data architecture, Data Models and BI solution design and Partner with Data Science team in developing and supporting predictive modeling efforts.

Essential Duties and Responsibilities

  • Produces written reports and recommendations for internal consumption, including problem statement, methods, interpretation of findings, and business implications.
  • Design of logical Data Warehouse architecture and data model, and implement physical design (schema, indexes, partitions, etc.) Strong ability of data modeling using Er-Studio or similar software
  • Assist Design of ETL architecture including , mappings, data flows designs using  Alteryx
  • Leading testing of data quality and completeness for modeling attributes.
  • Strong Knowledge of Alteryx Analytics is a must, to help with segmentation, fuzzy matching, data enrichments, trend analysis
  • Coordinating with business analysts and data engineers to gather data for analysis, and Developing predictive models, leveraging internal and external data, to solve high impact business problems with innovate solutions.
  • Provides ad-hoc support to internal clients for data mining and other analytics. Ability to use Power Bi to visualize Analytics Results


  • Bachelor's Degree in computer science
  • Strong Experience in Data Space including Logical Design, Data Governance , Data mining , Data Science
  • 5 years in Alteryx Analytics
  • 5 years of experience in data warehousing and/or business intelligence
  • 3 years of experience working with insurance data;
  • 3 Years technical knowledge in ETL tools such as Informatica Power Center, Informatica DQ
  • Knowledge of working with Power Bi
  • Excellent problem solving skills as well as critical thinking and conceptual thinking abilities.
  • Degree in data science, statistics, mathematics, computer science, finance, or economics. 
  • 2 years of experience using statistical modeling techniques to build models that influence company decision-making.

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


Rolling Meadows, Illinois, United States

📁 Information Technology

Requisition #: 71513


Rolling Meadows, Illinois, United States

📁 Information Technology

Requisition #: 71421

Corp - GTS BI & App Dev

Rolling Meadows, Illinois, United States

📁 Information Technology

Requisition #: 72642