Database Analyst/State Reporting

About the position

The Database Analyst/State Reporting position at SMA Healthcare involves maintaining compliance with applicable statutes and regulations, participating in compliance activities, and managing data collection and submission requirements for state and other funders. The role includes designing and maintaining databases for state reporting, compiling and analyzing data from multiple systems, and developing the Electronic Medical Records application. The analyst will also be responsible for documenting processes, maintaining data integrity, and providing support for end-user issues.

Responsibilities

• Maintains current knowledge related to applicable statutes, regulations, guidelines and standards necessary to perform job duties in accordance with the requirements of the Corporate Compliance Plan.
• Complies with the requirements of the Code of Conduct, Corporate Compliance Plan and Compliance Policies and Procedures, including training requirements.
• Participates in compliance activities under the direction of the Department Manager and Corporate Compliance Officer.
• Responsible for all data collection and submission requirements to meet contract obligations for managing entities and the state of Florida as well as any other funders.
• Designs, tests, and maintains the database for State Reporting and other contractual reporting.
• Compiles, analyzes and reports data from multiple database systems utilizing SQL and other related methods and technologies including Microsoft Reporting Services and Crystal Reporting.
• Performs monitoring, updating and maintenance of existing information systems.
• Perform development of the Electronic Medical Records application, increasing application efficiency and integration with other enterprise applications.
• Develop and maintain written process and procedure guides for regularly required reports.
• Maintains data dictionaries by revising and entering definitions.
• Identifies software malfunctions and initiates corrective action to maintain workflow and minimize system downtime.
• Analyzes and resolves end-user problems submitted via Help Desk work orders.
• Documents in the Help Desk any changes made to client charts.
• Analyzes data and recommends appropriate processes and data structures to support business data analysis and reporting needs.
• Determine application data access requirements and set up user accounts according to standardized roles and job duties to ensure client confidentiality.
• Recommends data integrity procedures/updates as needed. Implements approved standards.
• Investigates and repairs data integrity issues.
• Recommends and implements ways to improve efficiency of the information systems.
• Occasionally participates in the instruction of departmental personnel.
• Designs and writes report specifications and data extracts for the information systems.
• May be involved in the research, evaluation, and recommendation of new software.
• Assists with the implementation and development of any new information systems.
• Performs miscellaneous job-related duties as assigned.

Requirements

• Bachelor's degree in Business Administration, Computer Science, Mathematics, or related field, or 2 years of progressively responsible experience in application development or an equivalent combination of education and training.
• Thorough knowledge of database development and standards.
• Knowledge of systems analysis.
• Proficient in Crystal Report writing for versions 8 and up and Access database development.
• Some knowledge and use of SQL.
• Ability to learn and use third party software as needed.
• Ability to analyze data and develop conclusions.
• Ability to anticipate problems and devise solutions.
• Ability to train others in the use of agency information systems.
• Ability to adapt to changing technologies and adopt new tools and systems.
• Ability to multitask while maintaining attention to detail of each task.
• Ability to process or understand technical manuals and learn new techniques quickly.
• Ability to plan work flow and implement appropriate actions.
• Ability to document new or updated processes.
• Ability to enter and retrieve information from a computer system; operate modern office machines.
• Ability to establish and maintain effective working relationships with other employees, medical and clinical professionals, outside agency staff, clients, and the general public demonstrating strong customer service skills.
• Ability to communicate effectively both orally and in writing.
• Ability to work in sometimes stressful environment.
• Ability to perform team-oriented job tasks with a conscientious awareness of detail and accuracy.

Benefits

• Career growth and advancement potential
• Health, Dental, Vision, Life, & Disability Insurance
• Tuition Reimbursement
• Paid Personal Leave and Paid Holidays
• 403b Retirement Plan (matches one to one of employee contribution for the first 3%, then a 50% match on the next 6% of employee contribution)