Data Warehouse/ETL/BI/API DeveloperLocation: Harrisburg, PAClient: State of PADuration: Long TermThis position is hybrid (one day onsite for now but it can change to more days). The resource is expected to go onsite to get commonwealth-issued equipment and possibly do badging.The interview process is: 1. Phone Interview 2.
virtual via Teams 3. if needed, then onsite in-person.DOC is looking for a Data Warehouse, ETL, Business Intelligence Developer and API Developer staff augmentation resource.Start date can be identified upon after compliant PATCH and DOC-related clearance has been processed and approved.This requisition's PO is funded through 6/30/25, so use that date in the RTR. Contract end date is dependent on the final schedule and projected needs.
Historically additional funding should then last a year and occur from 7/1/25-6/30/26.Responsibilities:Optimize, develop and maintain integration solutions using SQL Server SSIS and ETL Framework as necessary to connect legacy data stores, the data warehouseDevelops, maintains and optimizes all effort related to Data Warehouse (SSIS, Stored procedures, Views etc.)Creates data warehouse components using best practices methodologiesBuilds and maintains through documentation of the data and how it is moved through layersPerform data conversion from OLTP to DW using tools like SSIS/Data FactoryIdentify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrityEnsure the stabilization and high performance of existing ETL processesTroubleshoot and complex data related issues as well as provide support to productionDevelop and deploy ETL job workflow with reliable error/exception handling and rollbackMust have experience working on SSRSPower BI experience is preferredExperience with Crystal Report will be beneficialAPI Development experience is preferredMay be involved with manual testingPerform other related duties as requiredQualifications:4 year college degree or equivalent technical study with advanced studyRequired: ETL experience (Including SSIS or other ETL tools)Required: 6 Years Data Analytics experienceRequired: 6 Years Data Warehouse knowledge and experienceRequired: 4 Years MS SQL Reporting Server (SSRS)Required: 3 Years Power BIRequired: 1 Year Web API development experience