Database Architect

** Candidates must reside in Pennsylvania **

OBJECTIVES OF ENGAGEMENT

This contract position reports to the Metrics and Analytics Section Chief. The Functional Architect provides analytical support for the Office of Long Term Living's programs. This position will assist in the collection, preparation, validation and distribution of data to various requesting stakeholders. The position will also lead in the design of standard operating procedures (SOP), process flow diagrams and the tracking of all outgoing data requests.

RESOURCES



OLTL shall provide office space within its office at OLTL, in the Forum Place Building, Harrisburg, PA. In addition, OLTL will supply all necessary hardware, software, network connection, phone and fax for daily use as needed to complete assigned work items. This position is telework eligible.

TASKS TO BE PERFORMED



Specific work items for the contractor are:



Determines and documents requirements for diagnosis level reporting

Follows current process and continuously improves data reporting based on quality standards

Provides expertise for defining functional architecture and infrastructure, using LEAN principles

Lead analyst in the oversight and tracking of data requests by using the existing data governance structure

Lead analyst in the design of SOP and process flow diagrams for effective cross training and knowledge transfer

Provide succinct analysis in addition to providing data charts and graphs

Support the Program Development and Innovation section on special studies and research requested by DHS or OLTL bureaus

Provide innovative ways to use existing data to improve program outcomes and efficiencies, including predictive analytics and business intelligence

Collaborate and build relations with program and policy staff

Assist in the development and support of monitoring OLTL's program performances

Participate and recommend specifications for new program performance measures

Assist in the development and data dashboards and other data visualizations

Maintain project documentation and work plans

Create executive level reports and presentations

Provide support in other projects as assigned by the Section Chief or above level management

Attend meetings as assigned by the Section Chief or above level management



CONTRACTOR SKILLS AND EXPERIENCE REQUIREMENTS



Bachelor's Degree.

Minimum of three (3) years of healthcare industry experience, preferably with a health plan, a pharmacy, or health tech environment.

A working knowledge of healthcare operations to include: enrollment, claims, customer service and appeals.

Demonstrated project management experience.

Applied analytical skills.

Strong written and verbal communication skills.

Proficiency in Microsoft office suite, including Access, Excel, power point and word.

Proven ability to lead a team and successfully complete assignments.

Ability to extract data from various data sources and warehouses.

Ability to create executive level presentations.

Working knowledge of Medicaid and Medicare

Proficiency in SAS

Proficiency in SQL

Experience in Healthcare Quality measures, utilization studies, and Healthcare analytics

Skill	Required / Desired	Years Used	Last Used
Bachelor's Degree	Required
Data collection, preparation, validation and distribution	Required
Applied data analytical skills	Required
Extraction of data from various data sources and warehouses.	Required
Data visualization tools (such as Power BI or Tableau)	Required
Proficiency in Microsoft office suite, including Access, Excel, power point and word	Required
Proficiency in SQL	Required
Experience creating executive level presentations.	Required
Proven ability to lead a team and successfully complete assignments.	Required
Healthcare industry experience, preferably with a health plan, a pharmacy, or health tech environment.	Required
Working knowledge of healthcare operations to include: enrollment, claims, customer service and appeals.	Required
Experience in Healthcare Quality measures, utilization studies, and Healthcare analytics	Highly desired
Proficiency in SAS	Highly desired
Working knowledge of Medicaid and Medicare	Highly desired

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.