We are in need of a Data Management Specialist with strong SSIS skills and raw data handling experience. This also includes identifying data issues, conducting complex analysis and maintaining data standards for Student Information System.
- Extract, Transform and Load raw data into relational database using SSIS.
- Review data and ensure accurate understanding of the data elements and table structures to come up with SSIS package edits.
- Setup Development/Staging environments for data cleansing and transformation.
- Create/Update data dictionaries, data achieving, backup and recovery plans.
- Work with BI team to gather data requirements and business usage.
- Testing to assure transactional data output matches dimensional data output.
- Bachelor's degree or equivalent education/ experience.
- 5+ years of work experience handling raw data, ETL or Data warehouse
- Ability to write complex Microsoft SQL code
- Expert knowledge using Microsoft SSIS, SQL Server Management Studio
- Experience with Microsoft TFS
Job ID: 18-00083