Analytics Consultant-Behavioral Health at Kishwaukee Hospital Sycamore, IL

The salary range for this position is $35.19 - $49.27 (Hourly Rate).

Placement within the salary range is dependent on several factors such as relevant work experience and internal equity. For positions represented by a labor union, placement within the salary range is guided by the rules outlined in the collective bargaining agreement. We offer a wide range of benefits that provide employees with tools and resources to improve their physical, emotional, and financial well‑being while providing protection for unexpected life events.

Please visit our Benefits section to learn more.

• $10,000 Tuition Reimbursement per year ($5,700 part-time)
• $10,000 Student Loan Repayment ($5,000 part-time)
• $1,000 Professional Development per year ($500 part-time)
• $250 Wellbeing Fund per year ($125 for part‑time)
• Matching 401(k)
• Excellent medical, dental and vision coverage
• Life insurance
• Annual Employee Salary Increase and Incentive Bonus
• Paid time off and Holiday pay

Work Location: On‑site, Sycamore, IL

Bachelor’s degree in a relevant field and 2+ years of experience in a role querying and/or analyzing data are required to be considered for this position.

Previous healthcare experience, ideally with a health system, is preferred.

The Analytics Team at Northwestern Medicine delivers thoughtful, highly engaging analytics products to our clinical and administrative leadership. These solutions directly impact and help drive the clinical and financial performance of our health system.

Northwestern Medicine is looking for a data driven, business‑minded, results oriented Analytics Consultant to join our team. The Analytics Consultant uncovers insights that drive strategy and optimal decision making for the Executive team and leaders across the organization. In this role, you will be charged with understanding the ‘who, what, and whys’ of our business – working cross‑functionally to dig into trends and surface value‑creating opportunities.

The core functions of the Analytics Consultant include defining, extracting, analyzing, and presenting data cogently to answer the questions being asked. Synthesize raw data into actionable information in the form of reports and presentations. Serve as a functional and content expert user of EDW, including but not limited to Epic Clarity data. Work with the business to define requirements, formulate queries, validate results, and generate reports using Microsoft SQL Server Reporting Services.

Evaluate data quality and interpret results in a clear, concise manner. Own analytics projects and be accountable for gathering customer requirements, execute analytics work efforts, and exceed customer expectations. Work collaboratively with and support multi‑departments efforts and projects. Provide training and support through the organization on the use of analytics tools.

Qualities required:

• Be a Data Champion! Effective analysis is only possible with good data – be an advocate of data accessibility, accuracy and quality.
• Be Curious! Find data nuggets, trends and other analytical goodies that help support our mission, vision, and values and advance our department as a whole.
• Be a Team Player! Collaboration is what makes us great – come prepared to work with a diverse cross‑section of technical and business professionals.

• Bachelor’s degree in relevant field
• 2+ years of experience in a role querying and/or analyzing data
• Experience working with business users to determine analytical solutions to meet business needs
• Experience using SQL for data extraction, manipulation, and reporting
• Demonstrated competency with Microsoft Excel, PowerPoint, and/or Access
• Effective problem solving and critical thinking skills
• Ability to communicate complex quantitative analysis in a clear, precise, and actionable manner
• Effective problem solving and multi‑tasking skills
• Excellent verbal and written communication skills

• Previous experience working with Epic Clarity data
• Experience using the Microsoft Business Intelligence stack (SSRS, SSMS, SSIS, SSAS)
• Experience using a software package for statistical analysis (R, Python, etc)
• Previous healthcare experience, ideally with…