Share this Job
Apply now »

BI Solution Analyst

Req #:  120309
Facility:  Support Centers
Department:  Data Analyst
City:  Downers Grove
Posting Budget Status:  Day
Shift Type:  Full Time - Permanent
Posting FTE:  1

Advocate Health Care, the largest health system in Illinois and one of the largest health care providers in the Midwest. Our Corporate Support & Operations Services are equally committed to advancing Advocate's goal of building lifelong relationships with patients by delivering the best health outcomes and highest level of service through an integrated approach to care and wellness.

The Finance Information Systems and Reporting department is a central hub for Advocate operations and health care administration information. We provide a centralized data warehouse, operational reports and analytics, Electronic Content Management (ECM), and customized application development. This department builds long term, sustainable solutions that transforms data into critical information to strategically improve operational outcomes. Team members have the opportunity to own a project from the beginning stages through development and forward. The Reporting Solutions Analyst position is primary responsibility for the development, maintenance, and support of Advocate's Daily Productivity Reporting and other Health Care Administration and Business Operations Reporting. The Reporting Solutions Analyst will develop, implement, and maintain data~warehousing structures and system and site reports, dashboards, and custom applications. This involves both a traditional development lifecycle and an Agile development methodology. This position is also responsible for support to Crystal Enterprise Reporting Liaisons across the system and site level. This position delivers operational and administration information in a way that fosters critical thinking and guides our leadership team to make key decisions that directly impact operations.

The Reporting Analyst is primarily responsible for Design, Coding, and Testing, for assigned BI Reports and required database objects.
This Analyst will support the full scope of department projects by performing Quality Checks of peer's development, Upgrade Testing, and Impact Research of new system initiatives.
The Reporting Analyst is required to maintain development level documentation and open communication with internal team members and customers.


Position Requirements:

  • BS/BA degree or equivalent with a minimum of 5 years' experience in IT, BI, or Data Warehouse
  • 2 years' experience with one or more principles in financial, human resource, nursing administration or other healthcare administration
  • 5 Experience with self~managed prioritization to meet deadlines
  • 5 Experience with Requirements Gathering
  • 4 years current development experience with Crystal Reports (v9 or higher)
  • 4 years current development experience / proficiency writing T/SQL, and creating stored procedures or other database objects
  • At least 2 years of current experience with Business Intelligence Solutions (pref. BusinessObjects Enterprise XIr2 or higher)
  • 6 months or more Experience with BI Visual Analytic Software, preferably Tableau Desktop Software
  • Nice to have: 1 year of experience with multi~dimensional / OLAP database structures such as SQL Server Analysis Services
  • Nice to have: 1 year of OnBase Workflow user experience Strong Data Discovery Skills with ability to find patterns and identify exceptions
  • Ability to exhibit critical soft skills including: Excellent active listening and communication skills, flexible and adaptable attitude, can adjust to shifting priorities, demands, and timelines, ability to elicit cooperation from a wide variety of sources, including other divisions, and ability to discuss technical issues to non~technical audience
  • Proficient with MS Outlook, Word, Excel
  • Experience with Visio or like application 

About Advocate Health Care


Advocate Health Care, named among the nation’s Top 5 large health systems based on quality by Truven Analytics, is the largest health system in Illinois and one of the largest health care providers in the Midwest. Advocate operates more than 250 sites of care, including 12 hospitals that encompass 11 acute care hospitals, the state’s largest integrated children’s network, the state’s largest emergency and Level I trauma network, one of the area’s largest home health care companies, and the region’s largest medical group. Advocate Health Care has 4 teaching hospitals and is a not-for-profit, mission-based health system affiliated with the Evangelical Lutheran Church in America and the United Church of Christ.

Nearest Major Market: Chicago

Apply now »