What are the responsibilities and job description for the SAR2 A4 SC3 (Data Warehouse/ETL/BI/API Developer) position at SmartIPlace?
Position: SAR2 A4 SC3 (Data Warehouse/ETL/BI/API Developer)
Location: Hybrid in Mechanicsburg, PA (Need local)
Visa: Any Visa (No fake visa) Need PP number to check i94
C2C
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 ID'd upon after compliant PATCH and DOC-related clearance has been processed and approved.
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
Location: Hybrid in Mechanicsburg, PA (Need local)
Visa: Any Visa (No fake visa) Need PP number to check i94
C2C
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 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.***
- Optimize, develop and maintain integration solutions using SQL Server SSIS and ETL Framework (BIDS) as necessary to connect legacy data stores, the data warehouse
- Develops, maintains and optimizes al effort related to Data Warehouse (SSIS, Stored procedures, Views etc.)
- Creates data warehouse components using best practices methodologies
- Builds and maintains through documentation of the data and how it is moved through layers
- Perform data conversion from OLTP to DW using tools like SSIS/Data Factory
- Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity
- Ensure the stabilization and high performance of existing ETL processes
- Troubleshoot and complex data related issues as well as provide support to production
- Develop and deploy ETL job workflow with reliable error/exception handling and rollback
- Must have experience working on SSRS
- Power BI experience is preferred
- Experience with Crystal Report will be beneficial
- API Development experience is preffered
- May be involved with manual testing
- Perform other related duties as required
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
