Position: SAR2 A4 SC3 (Data Warehouse/ETL/BI/API Developer)
Location: Mechanicsburg PA
Client: Commonwealth of PA
Agency: DOC
Interview Type: phone and webcam interview
Position ID: 749363
DOC is looking for a Data Warehouse ETL Business Intelligence Developer and API Developer staff augmentation resource.
Start date can be IDd upon after compliant PATCH and DOCrelated clearance has been processed and approved.
***This requisitions 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/256/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 commonwealthissued equipment and possibly do badging.***
***The interview process is 1. Phone Interview 2. virtual via Teams 3. if needed then onsite inperson.***
(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 preffered
(14) May be involved with manual testing
(15) Perform other related duties as required
Skill
Required / Desired
Your Amount of Experience in years/month
4 year college degree or equivalent technical study with advanced study
Required
ETL experience (Including SSIS or other ETL tools)
Required
6
Data Analytics experience
Required
6
Data Warehouse knowledge and experience
Required
6
MS SQL Reporting Server (SSRS)
Required
4
Power BI
Required
3
Web API development experience
Required
3
api development,manual testing,data conversion,bids,dw,views,etl,ssis,sql server ssis,stored procedures,etl framework,oltp,crystal report,other,data warehouse,power bi,ssrs,data
ETL or BI Developer
