DOC - SAR2 A4 SC3 (Data Warehouse/ETL/BI/API Developer)
Salary undisclosed
Apply on
Original
Simplified
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/NA/NA, 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/NA-6/NA/26.***
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/NA/NA, 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/NA-6/NA/26.***
***This position is hybrid (one day onsite (1NA0 Technology Parkway, Mechanicsburg, PA 1NA50) for now but it can change to moredays).***
***The resourceis 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.***
(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 | Amount | Consultant Experience |
|---|---|---|---|
| 4 year college degree or equivalent technical study with advanced study | Required | 0 | |
| 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 |
| No. | Question | Consultant Answer |
|---|---|---|
| Question1 | Background Check: This position requires an in depth background check, including fingerprinting, and requires successful results. Do you accept this requirement? | |
| Question3 | Where does your candidate currently reside? Please provide city and state. ***Candidates must be located within the Greater Harrisburg/ Mechanicsburg/ Central PA Area to be considered for this position.*** | |
| Question4 | Resume wise, please do not include filler material (e.g. describing a company's core capabilities/description). Please only include relevant info (e.g. what was done at the job/project). Is this reflected in the resume? | |
| Question5 | This position is 40 hours per week. Is this understood? | |
| Question6 | Do you understand, and will abide by, the provision in your subcontract with OST that it is PROHIBITED for government equipment to be taken or used outside of the United States by your contractors? The consequences of this occurring can and will result in repercussions to you, the prime vendor, regardless if the candidate works for a sub-vendor of yours. It will also result in immediate termination of the contractor, and make them ineligible for rehire in the program. | |
| Question7 | The interview process is- 1. Phone Interview (in the candidate's summary of qualifications did you include the phone number?) 2. virtual via Teams (in the candidate's summary of qualifications did you include the e-mail address?) 3. if needed, then onsite in-person.*** |
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job Similar Jobs
