BUSINESS INTELLIGENCE ANALYST

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. Analyst is responsible to ensure accuracy and timeliness of routine and ad hoc reporting for the department. 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, etc); revise reporting dashboards as needed.
• Analyze and understand data from various source systems in order 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 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.
• Take lead on cross functional teams to coordinate, gather/define functional and business requirements for Agile sprints, perform data and business process analysis, prioritize, collaborate with Data Warehouse team and SMEs, and implement reporting projects with IT and other departments
• Work with business users, report writers and enterprise data architect to refine/adapt/maintain ETL mappings as business user needs change or the data environment changes
• Improve the data collection process for analysis and reporting.
• Delivers superior customer service to all customers.

Qualifications:
Education and Experience:

• Bachelor’s degree or equivalent combination of education and experience in Quantitative Analysis, MBA preferred.
• 4+ years experience using Microsoft SQL Server (version 2012 or later) including both creating and maintaining complex T-SQL queries, views and stored procedures.
• Experience in healthcare administration, business administration, strategy, or management consulting 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)
• Effective critical thinking, problem solving, and communication skills
• Demonstrated analytical skills, including utilization of large data sets
• Knowledge of reporting tools a plus, e.g., Business Objects, Tableau, or other business intelligence/analytics tools
• Understand risk adjustment models in a health based reimbursement environment.