ETL Integration Specialist
Richmond, VA
H4-EAD/GC-EAD/GC/Citizens only
 
Required:
The ETL Integration Specialist will add value to the business of the Department of Corrections by having strong analytical and SQL skills, resolving moderately complex system problems, following BI best practices, integrations and identify source and metadata relevant to integrations and reporting. They will assist in ensuring that the data and business rules are in alignment to ensure quality business requirements.
 
Key Responsibilities
• The ETL Integration Specialist will interact with the Business Owner, Business Analyst and stakeholders.
• assist with document business requirements.
• provide in-depth analysis and develop integrations
• identify source data and metadata relevant to Data Management Team
• ensure that the data delivered to the business follows DOC and other regulatory policies, as well as data quality policies established with the business. 
• They will work with the developers and testers to ensure quality control within the team.
• Developing SQL Scripts to assist with data quality
• Assist with reporting
 
Technical Requirements
 
• Required with 5 years’ experience
o MS SSIS 2012 - 2016
o SQL Server Advanced Queries
o TFS 2015 or similar Source Control
 
• Additional Skills
o Windows 10 Desktop
o Visual Studio 2017
o SSRS 2012