Central Minnesota Educational Research and Development Council

Experienced in Education

Come Work With Us!

Administrative Solutions

cmERDC
St. Cloud Office
570 First Street SE
St. Cloud, MN 56304




Available Positions

Learning Solutions

Twin Cities Office
3550 Lexington Ave North
Suite 101
Shoreview, MN 55126



Available Positions


================================= Job Descriptions =====================================

Data Warehouse Specialist/Developer

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.

Responsibilities:

  • 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.

Basic Qualifications: 

  • 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.

Preferred Qualifications: 

  • 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 integration efforts, please send or email your resume with cover letter to:

Learning Solutions − Data Warehouse Specialist/Developer
c/o cmERDC
Attn: Chris Palmer
570 1st Street SE
St. Cloud, MN 56304

cpalmer@erdc.k12.mn.us

cmERDC is an Equal Opportunity Employer


FMLA regulations require all employers to post the updated FMLA notice.