Job ID: PA-583641 (95291213)
SSIS Developer with data analytics, Power BI, SSRS, Crystal Reports and data warehouse experience
Location: Hampden Township, PA (Pennsylvania Department of Corrections (DOC))
Duration: 6 months
Positions: 1 (1/3)
Skill Required / Desired Amount of Experience Expertise Rating
4 year college degree or equivalent technical study with advanced study Highly desired
ETL Experience (including SSIS or other ETL tools) Required 4 Years
Data Analytics experience Required 3 Years
Power BI Highly desired 2 Years
Data Warehouse knowledge and experience Highly desired 2 Years
– Optimize, develop and maintain integration solutions using SQL Server SSIS and ETL Framework (BIDS) as necessary to connect legacy data stores, the data warehouse
– 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 any complex data-related issues as well as provide support to production
– Develop and deploy ETL job workflow with reliable error/exception handling and rollback
– Drive process improvement and improve process efficiency
– Document all ETL and data warehouse processes and flows
– Communicate issues, risks and concerns proactively to management
– Must have experience working on SSRS
– Power BI experience is preferred.
– Experience with Crystal Report will be beneficial.
– May be involved with manual testing.
– Performs other related duties as required
Leave a Reply