Database Analyst/State Reporting

Top reasons to work for SMA Healthcare:

  • Career growth and advancement potential
  • Great benefits such as: 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)


Essential Job Functions:

  • 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.

Qualification Requirements: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Minimum Education and/or Experience:  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 which would afford the applicant with the required knowledge, skills, and abilities. 

Knowledge/Skills/and Abilities: 

  • 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.

Necessary Special Requirements: Possession of a valid Florida driver's license, acceptable driving record, and proof of personal automobile insurance if required to drive an SMA vehicle and/or use a personal vehicle for SMA business. Complete State of Florida mandatory background screening prior to start of employment.  Complete SMA required training during the first six (6) months of employment and updated if required.

Physical: Mobility and ability to bend and reach during an 8-12 hour day. Able to lift minimum 10 pounds. Visual and auditory acuity sufficient to evaluate, intervene, treat, and record client health care needs. Fine motor skills for legible and accurate charting, daily correspondence and presentation, either manually or orally. Work endurance ability to work 8-12 hour shifts with a meal break, as possible. Routine 8-12 hour shifts. Hours and days off may vary. Extra hours may be required. Work assignment locations may vary.

Application: This position description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications which may be required of the employee assigned to the position. It should not be used to limit the nature and extent of assignments such individuals may be given.