|
Commonwealth of Pennsylvania |
|
|
POSITION DESCRIPTION FOR JOB POSTING |
|
|
Position Number: 00135044 |
Description Activated On: 2/13/2026 9:21:13 AM |
Position Purpose: Describe the primary purpose of this position and how it contributes to the organization’s objectives. Example: Provides clerical and office support within the Division to ensure its operations are conducted efficiently and effectively. This position is assigned to the Data Warehouse Development Unit (DWDU), Enterprise Knowledge Management (EKM) Section, Division of Enterprise Applications (DEA), Bureau of Information Systems (BIS), Department of Human Services (DHS), and Office of Administration (OA). The position has specific responsibility for the complex technical work in the analysis, planning, design, development, programming, testing, debugging, maintenance, and documentation of Extraction, Transformation, and Load (ETL) processes utilizing the Informatica PowerCenter and Structured Query Language (SQL) toolsets for the Enterprise Data Warehouse (EDW), and provides support for EDW logical and physical data model design utilizing the ERWin data modeling tool. This position is a key contributor to the creation of the EDW for use by all Pennsylvania (PA) Department of Human Services (DHS) program offices, PA Department of Health, PA Department of Aging, and the Pennsylvania Insurance Department (PID). |
|
Description of Duties: Describe in detail the duties and responsibilities assigned to this position. Descriptions should include the major end result of the task. Example: Types correspondence, reports, and other various documents from handwritten drafts for review and signature of the supervisor. The individual in this position provides Enterprise Data Warehouse technical support for the 69,818 ETL (Extraction / Transformation / Load) processes and the 13,826 tables created to support and be utilized by the 1,436 active users, 245 cubes and over 21,000 BI reports. The individual in this position provides EDW support for all mappings and data in the data warehouse as well as the EDW infrastructure. Major mission critical systems supported in the EDW include: • OIM EDW data - Client Information System (CIS) – mission critical EDW data that is utilized for adhoc Oracle-based SQL manipulation and analysis as well as in support of the Business intelligence suite of Cognos cubes, packages and BI reports for the Office of Income Maintenance that included eligibility programs (MA, TANF, SNAP, and LIHEAP). This application is administered by approximately 6000 County Assistance Office workers spread across 93 offices. This application is used to process applications, collect case data, determine eligibility, authorize benefits, issue client notices and conduct ongoing case maintenance using the Electronic Client Notice System (eCIS). Included in the suite of applications is: o eCIS – part of the CIS suite of applications. Mission critical application that provides a single location and user experience to perform application processing and case maintenance activities such as application processing for various DHS programs, maintaining and renewing active case records, indexing attaching and viewing scanned documents for validation, and receiving and viewing results of federal and state data exchanges. o COMPASS – part of the CIS suite of applications. Mission critical application that provides a self-service portal for PA citizens for online application submission for 5 commonwealth agencies, citizen accounts for application updates and change reports, and a renewal process to maintain benefits. o Low Income Heating and Energy Assistance Program (LIHEAP) – mission critical application that allows individuals to apply for assistance in paying their heating/air conditioning bills. o Temporary Assistance for Needy Families (TANF) – mission critical application that allows families to apply for temporary assistance to do unforeseen circumstances. • OMAP EDW data that support Business Intelligence applications - The Office of Medical Assistance Programs administers the joint state/federal Medical Assistance (also known as Medicaid) program that purchases health care for close to 1.9 million Pennsylvania residents. Local County Assistance Offices determine eligibility for Medical Assistance. Medical Assistance purchases services through contracts with managed-care organizations and under an indemnity, or traditional, fee-for-service system. Medical Assistance data is utilized for adhoc Oracle-based SQL manipulation and analysis as well as in support of the Business Intelligence cubes, packages and BI reports that are critical in the analysis and compliance with federally mandated BI reporting requirements. • OCDEL EDW data that support Business Intelligence applications - Pennsylvania’s Enterprise to Link Information for Children Across Networks (PELICAN) – Develop and manage mission critical BI application that integrates the Department’s childcare and early learning programs under a single management information system. Skills required to maintain these applications: gathering requirements, requirement decomposition, and the development of multi-dimensional logical and physical data models, complex database queries, and business metadata. Technologies used are the Informatica PowerCenter tool, SQL language, and the ERwin data modeling tool on an Oracle data warehouse database. Program offices and Business Partners are supported by this position: • Medical Assistance • Income Maintenance • Child Development and Early Learning (OCDEL) • Budget Office • Long Term Living • Mental Health and Substance Abuse • Department of Aging • Department of Insurance • Department of Health • 67 PA County governments • City governments (Philadelphia, Pittsburgh, etc.) • 40 Health and Human Services Organizations. (Community partners, client advocate groups, Mental Health/Mental Disability groups, etc.) • 20+ Intermediate Units • Multiple Educational organizations (Penn State, Temple University, etc.) Skills required to maintain these applications: gathering requirements, requirement decomposition, the development of multi-dimensional logical and physical data models, complex ETL and database SQL query processes, and business metadata. Technologies used are Informatica PowerCenter, the Erwin data modeling took, and SQL software on an Oracle data warehouse database. This position is responsible for all ERWin logical and physical data model development utilized by the Data Warehouse Development Unit for the purposes of EDW development initiatives. Developer on complex systems software development teams ensuring the utilization and compliance with Software Engineering Processes (SEP) and Systems Development Life Cycle (SDLC) methods to include: 1) Requirements management, 2) Configuration/Change Management, 3) Defect tracking and resolution, 4) Test planning, coverage and proficiencies, 5) Version Control and production release cycles, 6) User and systems level documentation, 7) Programming/Development and Software Standards, 8) Implementation and deploy plans and strategies. Functions as a technical team member in the design, establishment, management, and configuration of new EDW data and models, technologies, applications and database architectures within the standard Environments. Mentors junior level applications developers in the design, development, assembly, testing, and deployment of complex software use to support agency missions. Supports and participates in total quality management, continuous quality improvement, team-based processes, and customer-focused service in all activities of BIS. Assists in the creation and review of SEP and ARB documents and project plans for Software Life Cycle Management (SLCM) compliance initiatives within the Unit. Assists with the review and preparation of EDW applications for migration to production, installs and field tests applications, and provides technical assistance to project team members and customers. Assists in the coordination of systems User Acceptance Testing (UAT) activities in accordance with SEP and SQA testing standards as well as systems pilots in alignment with Pilot Evaluate Plans (PEP). Independently develops and expands EDW technical and soft skill foundations, proficiencies, and core competencies. Attends required training. Assists in identifying employee training areas. Adheres to and enforces in all instances to both the Commonwealth’s and the Department’s Code of Conduct and to all existing Departmental policies relative to affirmative action. |
Decision Making: Describe the types of decisions made by the incumbent of this position and the types of decisions referred to others. Identify the problems or issues that can be resolved at the level of this position, versus those that must be referred to the supervisor. Example: In response to a customer inquiry, this work involves researching the status of an activity and preparing a formal response for the supervisor’s signature. Work is assigned based on priorities. Work is reviewed based on the tasks and dates on the project work plan. The employee is responsible for oral and written status reports and to report all problems or potential problems to the supervisor. |
||||||||||||||||||||
Requirements Profile: Identify any specific experience or requirements, such as a licensure, registration, or certification, which may be necessary to perform the functions of the position. Position-specific requirements should be consistent with a Special Requirement or other criteria identified in the classification specification covering this position. Example: Experience using Java; Professional Engineer License Experience: Licenses, registrations, or certifications: 1. N/A 2. N/A 3. N/A 4. 5. 6. |
||||||||||||||||||||
Essential Functions: Provide a list of essential functions for this position. Example: Transports boxes weighing up to 60 pounds.
|