eAIR Newsletter Reformat

About eAIR

eAIR is the newsletter of the Association for Institutional Research (AIR). From its start in October 1987 to today, eAIR remains one of the most important tools for providing news to the higher education community.

View Articles By Column

Hot Topics

Subscribe

Subscribe to eAIR

Create a free account or update your communication preferences to receive the eAIR newsletter.

Thank You

2021 Editorial Committee

Association at a Glance

Featured Opportunities

Did you know?

AIR welcomes brief conference/event announcements of interest to the IR and higher education communities.
Learn More 

AIR Hub

Recent Discussions

Listings Closing Soon

18863

Apr 18, 2025, 00:00 AM
Title : SQL & Reporting Developer
Salary range low : 24
Salary range high : 37.38
Application due date : 2025-04-18
Job start date : 2025-05-15
Reports in office : Research and Analytics
Reports to : Executive Director of Data Strategy & Effectiveness
Number of staff reports : 0
Remote work :
City : Livonia
State : MI
Institution : Schoolcraft College
Meta Title : SQL & Reporting Developer
Is imported : Yes
Exclude salary : No
Must apply on Schoolcraft's website: https://jobs.schoolcraft.edu/
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.
  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. 
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.
Full benefits available.
Job Type :
  • FULLTIME

VIEW ALL OPEN POSITIONS

POST A JOB