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