Division of cmERDC
Twin Cities Office
3550 Lexington Ave North, Suite 101
Shoreview, MN 55126
We are currently seeking a Data Warehouse Specialist/Developer to design, develop, implement and support Viewpoint®, our K-12 data warehouse solution, and data integration utilities. This position will work with Product Specialists, our customers and other software developers to maintain and enhance our products and services.
Design, develop, implement and maintain ETL (extract, transform, load) processes to extract data from Student Information Systems, assessment systems and other customer data sources and convert extracted data into formats required by data warehouse solution.
Ensure data accuracy.
Conduct root cause analysis and resolve production problems and data issues.
Write stored procedures for loading data and generating reports.
Design, develop, implement, and maintain web (and desktop) based solutions to enhance and monitor the ETL processes for collecting data, staging data, cleansing data, standardizing data, and publishing data into our data warehouse solution.
Provide regular written and verbal communications to management, team and customers concerning projects and efforts. Provide input into team planning and direction.
Bachelor's Degree in MIS or related field required. Additional technology related experience may be used in lieu of higher education (two years of experience in lieu of each year of higher education).
Experience working with data stored in a relational database environment. Minimum of four years' experience or equivalent proficiency with SQL database technology.
Solid understanding of data, database structures, data warehousing concepts and data modeling.
Experience with school district data.
Experience with Microsoft SQL Server Enterprise Edition including Microsoft SSIS.
Experience working with spreadsheet applications to assist in importing data.
Programming experience using C# and Microsoft Visual Studio.
Strong problem-solving skills.
Ability to manage multiple competing tasks at the same time.
If you desire a challenging opportunity to contribute to our data integration efforts, please send or email your resume with cover letter to:
Learning Solutions − Data Warehouse Specialist/Developer
Attn: Chris Palmer
570 1st Street SE
St. Cloud, MN 56304
cmERDC is an Equal Opportunity Employer
If you see something on this site that interests you and you feel that you have a unique contribution to make,
We look forward to hearing from you.