Business Intelligence Analyst Ii

JOB PURPOSE:

This position will develop, document, and maintain reporting and analytics that inform leadership on key indicators/metrics as well as drive increased levels of quality of care, clinical outcomes, and financial success. The BI analyst is responsible to ensure the accuracy and timeliness of routine and ad hoc reporting for the department. The BI analyst will work with both internal and external customers and is held accountable for the successful roll-out of information as well as customer satisfaction.

RESPONSIBILITIES:

• Develop and deliver business intelligence solutions and associated reporting using various EDW applications and BI tools (specifically using SQL Server, Tableau Server, Power BI, etc.); revise reporting dashboards as needed.
• Analyze and understand data from various source systems to validate data quality and ensure that business reporting needs are fulfilled through a formal, documented process.
• Provide support for market analytics and performance improvement activities including the design, collection, preparation, and presentation of data.
• Assist the department in identifying and performing appropriate analyses to enable sound decision-making.
• Leverage multiple data sources to develop scheduled and ad-hoc reports to enable process and trend analysis.
• Create useful reports for end-users, including all levels of management both on a standard and ad hoc basis.
• Identify development needs to improve and streamline operations.
• Work with business users, report writers, Data Warehouse team, and enterprise data architect to refine/adapt/maintain ETL mappings as business user needs change or the data environment changes.
• Delivers superior customer service to all customers.

SALARY RANGE:

$100,000.00 - $115,000.00

Weekly Hours: 40

Schedule: 8:30 AM - 5:30 PM

QUALIFICATIONS:

EDUCATION:

• Bachelor's degree in Computer Science, Information Technology, Finance or similar; Master's degree preferred.

EXPERIENCE:

• 5+ years of experience using Microsoft SQL Server (version 2016 or later) including both creating and maintaining complex T-SQL queries, views, and stored procedures.
• Must be able to compose SQL queries independently by hand.
• Experience in managed care, healthcare administration, business administration, strategy, or management consulting is preferred.
• Advanced knowledge of MS Excel (including pivot tables, IF statements, VLOOKUP, HLOOKUP, VBA, etc.) and Access (criteria statements, table links, database, and report creation), as well as other standard MS Office applications (Word, PowerPoint).

OTHERS:

• Effective critical thinking, problem-solving, and communication skills.
• Demonstrated analytical skills, including utilization of large data sets.
• Rely on extensive experience and judgment to plan and accomplish goals.
• Knowledge of reporting tools a plus, e.g., Business Objects, Tableau, Power BI, and/or other business intelligence/analytics tools.
• Understand risk adjustment models in a health-based reimbursement environment.