Business Intelligence Developer

ATI Physical Therapy Company   •  

Chicago, IL

Industry: Healthcare


5 - 7 years

Posted 95 days ago

This job is no longer available.

Role Description:

The BI Developer is a member of the Business Intelligence team within ATI’s IT Solution Delivery department, which supports clinical, operational, and administrative teams across ATI. This individual is responsible for developing, testing and implementing BI and reporting solutions to enable and effectively deliver its initiatives. The Business Intelligence Developer will work closely with internal stakeholders and external clients to understand technical requirements, and will collaborate with Application Developers and QA Testers to deliver key projects and initiatives.

Key Activities:

- Develop, deploy, and supportMS SQL Server BI solutions utilizing Integration Services (SSIS) and Reporting Services (SSRS)

- Design, code, test, maintain and document programs to support and automate data integrations and decision support tools

- Build Fact and Dimension tables to support analytical and reporting models

- Build dimensional models and data marts to supportreporting and analysis

- Develop scalable and configurable solutions to deliver external client reporting and analysis

-  Manage and influence changes to data warehouses from modelling requirements, producing technical specifications, regression testing and releasing to production environments

- Build self-serve reporting, including parameterized reports with drill-down capabilities

- Adhere to standard development, testing, deployment and source control processes

- Author key reports, dashboards and analytical tools for all aspects of the business

- Effectively document and communicate technical data into business language

Key Skills:

- BI Development: Microsoft SQL Server Reporting Services (SSRS), Analysis Services (SSAS), and Integration Services (SSIS); MS Power BI and Tableau a plus

- Database: Microsoft SQL Server 2012, 2014, and/or 2016

- Expert-level T SQL and SSIS experience connecting multiple data sources preferred

- Extensive experience writing and optimizing stored procedures, packages and queries

- Skilled at developing dashboards and reporting solutions

- Skilled at optimizing complex SQL for performance and process improvement

- Agile Development experience on Scrum teams

- Excellent analytical, communication, writing, planning, and organizational skills

Preferred Experience:

- 5+ years of experience in Database, Data Warehouse & Business Intelligence development


-Bachelor’s Degree in Management Information Systems, Computer Science, or Information Systems (or equivalent work experience)