BI Developer

JOB SNAPSHOT: 
Employee Type:  Full-Time
Location: 

Chicago, IL, US, 60601

Job Type:  Information Technology
Secondary Location: 
Years of Experience: 

Position Summary:

The BI Developer will reporting out of a data mart and help establish reporting solutions for all of RSG and their affiliates. 

Essential Functions:

  • Design, develop, test, and deploy SSIS/DTS packages and stored procedures to perform all ETL related functions
  • Review and optimize stored procedures feeding into current reporting
  • Assist in establishing OLAP capabilities for end users in Tableau
  • Provide daily troubleshooting of full reporting architecture
  • Backup up the current DBA

Education/Experience/Skills:

  • 5+ years experience with TSQL development
  • 2+ years experience designing and developing SSRS reporting
  • 1+ years experience designing and developing Tableau reporting
  • BA/BS degree in a technology related field a plus, not required. 
  • Very strong TSQL development skills
  • Strong SSRS report design skills
  • SSIS and SSAS experience
  • Experience with data warehousing and BI concepts including data modeling, cube design, and ETL
  • Familiarity with SQL Server skills such as security, replication, backup, and performance testing a plus

Disclaimer

Ryan Specialty Group is an Equal Opportunity Employer


Nearest Major Market: Chicago