The primary responsibility of the job is to define, produce and maintain data and reports by developing a comprehensive understanding of the billing system (Epic), the generated data from the system, and by gathering, refining and translating business requirements from users to apply to available data. The individual will have strong analytic and query writing skills in order to maximize the value of the data by evaluating data integrity and applying concepts to further categorize and define data from the billing system. The person will help identify and scope issues and employ effective problem-solving strategies to assure all aspects of data processing and analysis meet end-user/customer needs. The successful candidate will provide a high level of support to the Business and Revenue Unit and Community Health Services (CHS) and Prevention Division program leadership, often in a time-sensitive manner. The position may provide project leadership to same or lower level staff.

Teamwork

1. Work effectively with team members to understand work processes and downstream reporting needs.  Understand the scope of programs in CHS/Prevention divisions and standard reporting metrics used by the programs.  
2. Lead a group of analysts with similar job duties for information sharing and consistency/ standardization of data definitions and reporting metrics.
3. Facilitate and lead planning and process improvement teams in support of systems and participate as a key member on upgrade or new system acquisition team.

1. Develop data mining programs to extract and reprocess data; analyze computer generated information from multiple sources to ensure data integrity across all systems 
2. Analyze data integrity by querying and reporting on a highly complex department-wide data system within a major relational database and solving related data processing problems;
3. Normalize data, troubleshoot and resolve the most complex information processing and reporting problems, and work with appropriate specialized IT staff and/or vendors to resolve problems.
4. Analyze proposed changes with system upgrades and recommend strategies for implementation, ensure data integrity during/following all installs and conversion processes.

1. Gather, define, map, refine, and translate complex report specifications.  
2. Build complex queries to extract data to generate ad-hoc and routine reports; design, test and revise formats and analyze data to ensure information meets user needs.
3. Conduct ad hoc data analysis for purposes of ensuring accurac­y of information.
4. Organize and generate data reports in multiple user formats (i.e. Excel, Tableau), laying out and presenting data, producing and distributing polished reports.  
5. Provide support to end-users to assure data integrity, version control of relevant documents, and assist with the appropriate prioritization of report development.   
6. Train all staff on how to develop and/or use reports which include the development of training materials and report documentation; serve as an on-going resource, providing direction, training and guidance to users.

1. Perform data analysis of report information, evaluate findings to ensure accurate interpretation of mission-critical data, and work with users to design report format and content changes to accurately reflect information.
2. Propose efficiencies and business process improvements, troubleshoot, track, resolve and document significant system problems and issues requiring advanced technical expertise.  
3. Perform other duties as assigned.