Responsible for providing analytic support, which includes data collection, trending, reporting and forecasting functions to ensure data integrity. Will design, develop, analyze and determine reporting controls and procedures for the department.
Provide programming support to extract and analyze data from different enterprise systems.
Write SQL queries or use SQL tools to access source data.
Develop new reports and report templates to support business needs by utilizing various reporting tools and data mining techniques.
Develop, implement, and maintain consistent processes for data quality controls to ensure data integrity and make recommendations to improve data integrity,
Monitor and analyze data to determine department improvement areas.
Work collaboratively with customers to complete effective needs analyses to successfully provide analytic support and problem solving assistance to business areas.
Identify trends and participate in problem-solving, investigation, and analyses to make recommendations to business areas to effectively assist them with decision making on operational or other business issues.
Communicate meaningful insights by creating charts and slide presentations and presenting findings and recommendations to business areas.
Generate reports utilized by business unit such as area scorecard, dashboard, status, etc.
Produce monthly, quarterly and annual reports for distribution and provide ongoing user support for ad hoc reporting, questions, queries, and problem support.
May maintain departmental inventory of queries – looking for opportunities to move to a production state with system generated reports, eliminating duplicates, and creating a single source process for repository, and guidelines for execution to minimize taxing the production systems.
May serve as point-of-contact for audit processes and procedures.
Suggest procedural changes as necessary to provide the level of reporting required.
Research, gather, prepare, and substantially edit reports, graphics and other materials.
Develop and maintain document processes to generate reports.
May evaluate all data for presence of PHI fields. Consult with subject matter experts within the department for resolution of security and privacy issues.
May represent department on multiple project teams and process optimization efforts that require analysis, interviews, procedure design, documentation and implementation.
3+ years of data analysis/reporting experience including use of statistical methods
If no degree, 5 years of data analysis experience including use of statistical methods
Experience presenting data findings/analysis and making business recommendations to leadership staff
A degree focus in mathematics, statistics, computer science, finance or business is preferred
Advanced degree preferred.
Experience working in a health care/insurance field is preferred.
Strong customer focus and consulting skills. Ability to consult with all levels of leadership and to determine data needs to most effectively address business issues and problems.
Effective verbal and written communication and presentation skills
Excellent time-management, organizational and prioritizing skills
Excellent Microsoft Office product skills (i.e. MS Word, Excel, PowerPoint, and Access)
Ability to work in a team setting