Job Title : Data Engineer

Location Harrisburg, PA

Work Arrangement : Hybrid ( Contract)

Candidates must be in Pennsylvania

Willing to relocate candidates will not be considered, Please donot submit

Need 6+ years of experience as Data Engineer

(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

Required Skills :

ETL experience (Including SSIS or other ETL tools)
Data Analytics experience
Data Warehouse knowledge and experience
MS SQL Reporting Server (SSRS)
Power BI
Web API development experience

Job Type: Contract

Pay: $55.00 - $60.00 per hour

Expected hours: 40 per week

Schedule:

8 hour shift
Day shift
Monday to Friday

Work Location: Hybrid remote in Harrisburg, PA 17101

American Technology Consulting LLC

Latest Jobs

Data Engineer