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)
SkillRequired / DesiredAmountof ExperienceExpertise Rating
4 year college degree or equivalent technical study with advanced studyHighly desired
ETL Experience (including SSIS or other ETL tools)Required4Years
Data Analytics experienceRequired3Years
Power BIHighly desired2Years
Data Warehouse knowledge and experienceHighly desired2Years
– 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
PA ITSA – Right to Represent Acknowledgement_20150925.doc