Job ID: FL-Doc162111 (97590511)
(Cancelled) SSIS/SSAS Admin with OLAP, SSAS, SQL, ad-hoc reports, SOAP, APIs and PaaS/IaaS experience.
Location: Tallahassee FL (Department of Health Office of Information Technology (OIT) Bureau of Clinic Management and Informatics)
Duration: 12 months
CONTRACTOR QUALIFICATIONS AND EXPERIENCE:
-Four years development and reporting experience with Office of the National Coordinator for Health IT certified electronic health record software.
-Three years of experience with database structures and design.
-Three years of experience writing relational and Online Analytical Processing (OLAP) database queries using SQL.
-Three years of experience working with SQL Server Analysis Services (SSAS) and SQL Server Integration services (SSIS) or similar.
-Three years of experience performing requirements analysis and generating ad-hoc reports.
-Three years of experience conducting technical specifications reviews and providing guidance and
feedback.
– Four years of experience in Logi Analytics developing dashboards and working with dimensional and
analysis grids and developing Logi plugins.
-Two years of experience in Intersystems Cache development using Cache Object Script and Zen reports
-Three years of experience with healthcare interoperability tools and technologies using clinical document architecture to develop and design Continuity of Care Document and Quality Data ReportingArchitecture I and III.
-Three years of experience with healthcare interoperability tools and technologies using Health Level 7.
-Four years of experience with web services including Representational State Transfer APIs and Simple Object Access Protocol (SOAP) methodologies.
-Five years of experience in application development using cloud infrastructure not limited to Platform as a Service (PaaS) and Infrastructure as a Service (IaaS).
6. CONTRACTOR RESPONSIBILITIES:
6.1.1. Design, develop and submit reporting tools and data management routines that populate centralized datasets used for reporting based on functional specifications as directed by the Department. Reporting tools will provide access to key performance indicators identified by the Department as a priority, Clinical Quality Measures established by the National Quality Forum, Uniform Data System (UDS) measures, Healthcare Effectiveness Data, and Information Set
(HEDIS) measures and Federal EHR Meaningful Use Objectives as assigned by the Department.
6.1.2. Evaluate and submit business requirements and determine key performance indicators to be
evaluated by the Department to establish priority as assigned by the Department.
6.1.3. Analyze and submit business requirements for key performance indicators identified by the
Department as a priority, Clinical Quality Measures established by the National Quality Forum
Uniform Data System (UDS) measures, Healthcare Effectiveness Data, and Information Set
(HEDIS) measures and Federal EHR Meaningful Use Objectives, to develop report specifications
utilizing Microsoft Office tools. Successful task execution produces specifications that capture
the goals of the defined business requirements.
6.1.4. Facilitate specification reviews with business analysts and team managers as assigned by the
Department.
6.1.5. Ensure a defined agenda is communicated to participants, provide a common understanding of
terms and definitions, synthesize ideas, track discussions, and provide clear summaries of the
discussion and decisions in oral and written form.
6.1.6. Create and submit system designs, applying industry standard system analysis and design
practices for system feature enhancements or additions and bug fixes as assigned by the
Department.
6.1.7. Modify, create and submit application code and database code, applying industry
standard system development practices as assigned by the Department.
6.1.8. Troubleshoot and determine resolutions to system issues and bugs identified by the HMS Support
group and the Applications Management team as assigned by the Department.
Contract Exhibit G – Resume Acknowledgement Form