Job Board

  1. Home
  2. Resources
  3. Job Board
  4. 18863

SQL & Reporting Developer

Application Procedure:

Must apply on Schoolcraft's website: https://jobs.schoolcraft.edu/

Job Duties

  1. Create and maintain SQL queries to extract, compile, transform, compute, and submit data, ensuring compliance with state, federal, and accrediting body reporting requirements. Develop automated reporting solutions to improve efficiency and accuracy.
  2. Review and assess ad-hoc data requests, evaluate requirements, and translate them into clear business rules. Write and optimize extraction and data manipulation queries across multiple platforms to support projects, trend reporting, and stakeholder inquiries. Cleanse, transform, and integrate data from disparate sources to prepare it for analysis, ensuring accuracy and consistency.
  3. Provide comprehensive quality control for reports and queries, ensuring data accuracy and integrity across multiple systems. Investigate data challenges to pinpoint root causes, proposing and implementing effective solutions.
  4. Provide data that supports college initiatives, including quality improvement projects, measuring institutional outcomes, and evaluating student success.
  5. Design and maintain the back-end infrastructure, including datasets, fact and dimension tables, and star schema models, to support interactive dashboards and reports using Power BI. Write DAX code to create custom measures and calculations within dashboards. 

Job Qualifications

Required Qualifications:
  1. Bachelor’s degree in Computer Science, Information Technology, or Programming or related.
  2. Two (2) years of experience and/or course work with SQL.
  3. Two (2) years of experience and/or course work in ETL processes, including data cleansing, standardizing, and preparing data for analysis.
  4. One (1) year experience and/or course work in database design, development, and maintenance.
  5. Ability to collect project requirements and manage deadlines effectively.
  6. Excellent analytical, problem-solving, and communication skills.
  7. A strong desire to learn and acquire new skills, with a particular interest in higher education data.
  8. Strong teamwork, adaptability, and attention to detail.

Preferred Qualifications:
  1. Experience working with higher education data and ERP systems, especially Ellucian Colleague Applications.
  2. Experience with developing Power BI reports and writing DAX measures to create insightful visualizations.
  3. Knowledge of dimensional modeling using star schema architecture.
  4. Understanding of data governance and compliance principles.
  5. Microsoft Power BI, Microsoft Azure Certifications, or other relevant industry recognized credentials.

Institution Description

Schoolcraft College is a public community college offering learning in a variety of formats, enrolling more than 30,000 students each year in both credit programs and personal and professional learning courses. The College has over 130 different academic majors and programs leading to a skills certificate, certificate, associate degree, or post-associate certificate, plus a Bachelor of Science degree in Culinary and Dietary Operations Management.

Our mission is to provide a transformational learning experience designed to increase the capacity of individuals and groups to achieve intellectual, social, and economic goals.

Located at 18600 Haggerty Road in Livonia, Michigan, the main campus is 25 miles northwest of Downtown Detroit and conveniently near I-275.

Benefits

Full benefits available.
Application Due Date: 2025-04-18
Job Start Date: 2025-05-15
Salary: $24 - $37.38
City: Livonia
State/Province/Region: MI
Institution: Schoolcraft College
Reports To: Executive Director of Data Strategy & Effectiveness
Staff # Reporting to Position: 0
Reports In Office: Research and Analytics

Search for openings in IR, effectiveness, assessment, planning, and related fields at higher education institutions in the U.S. and abroad. 

Top of List   Post a Job

 

Job Board