HYBRID - CANDIDATES LIVING IN MAX. 1 HOUR S DRIVING DISTANCE FROM HARRIBURG, PA TO WORK ONSITE AS NEEDED
JD :
DOC - SAR2 A4 SC3 (Data Warehouse/ETL/BI/API Developer). Job# 749363
Client: State of PA, Department of Correction, Harrisburg, PA
Rate: $55/hour on C2C or $50/hour on W2
DOC is looking for a Data Warehouse, ETL, Business Intelligence Developer and API Developer staff augmentation resource.
Start date can be ID'd 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.***
• **This position is hybrid (one day onsite (1920 Technology Parkway, Mechanicsburg, PA 17050) 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.***
Job Details:
(1) Optimize, develop and maintain integration solutions using SQL Server SSIS and ETL Framework (BIDS) as necessary to connect legacy data stores, the data warehouse
(2) Develops, maintains and optimizes al effort related to Data Warehouse (SSIS, Stored procedures, Views etc.)
(3) Creates data warehouse components using best practices methodologies
(4) Builds and maintains through documentation of the data and how it is moved through layers
(5) Perform data conversion from OLTP to DW using tools like SSIS/Data Factory
(6) Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity
(7) Ensure the stabilization and high performance of existing ETL processes
(8) Troubleshoot and complex data related issues as well as provide support to production
(9) Develop and deploy ETL job workflow with reliable error/exception handling and rollback
(10) Must have experience working on SSRS
(11) Power BI experience is preferred
(12) Experience with Crystal Report will be beneficial
(13) API Development experience is preferred
(14) May be involved with manual testing
(15) Perform other related duties as required
SKILLS:
4 year college degree or equivalent technical study with advanced study Required
ETL experience (Including SSIS or other ETL tools) Required 6 Years
Data Analytics experience Required 6 Years
Data Warehouse knowledge and experience Required 6 Years
MS SQL Reporting Server (SSRS) Required 4 Years
Power BI Required 3 Years
Web API development experience Required 3 Years
Location: Harrisburg, PA
Posted: Oct. 21, 2024, 9:28 p.m.
Apply Now Company Website