Business Intelligence Developer

Maryville Academy

Chicago, IL

JOB DETAILS
SALARY
$85,000–$90,000 Per Year
SKILLS
Application Programming Interface (API), Business Intelligence, Communication Skills, Community and Social Services, Data Quality, Data Sets, Financial Systems, HRIS/HRMS, Healthcare, Information Technology & Information Systems, Leadership, Medical Record System, Metrics, Microsoft SQL Server, Nonprofit, Power BI, Process Improvement, Python Programming/Scripting Language, Quality Assurance, Relational Databases (RDBMS), Reporting Dashboards, Social Work, Team Player
LOCATION
Chicago, IL
POSTED
10 days ago

Job description:

Make Data MatterImprove Lives Through Insight

Were a mission-driven non-profit serving our community through ~15 social service programsand were looking for a BI Developer to help us transform how we use data to drive outcomes, improve services, and support the people we serve.

If you enjoy turning messy, real-world data into clear, trusted insightsand want your work to have real impactthis role is for you.

Key Responsibilities

Youll be the owner of our reporting and analytics layer, helping programs and leadership make better decisions through data.

  • Build and enhance Power BI dashboards used across programs and leadership
  • Develop shared datasets to ensure consistent metrics (e.g., clients served, outcomes)
  • Clean, combine, and shape data from multiple sources (EHR, Forms, API, Excel.)
  • Partner with program staff and PQI to define what our metrics actually mean
  • Investigate and explain data discrepancieshelping build trust in reporting
  • Create intuitive, user-friendly dashboards that non-technical staff can rely on
  • Work with data sourced primarily from multiple systems, with future expansion into financial and HR systems.
  • Support data validation, data quality initiatives, and basic governance practices.
  • Collaborate with IT and system owners across teams.

Required Qualifications

  • 3-6 years in BI, reporting, or analytics

  • MS SQL (Experience with full relational databases, EHR preferred)

  • Data modeling basics (fact/dimension, relationships)

  • DAX and Power Query

  • Ability to work with imperfect, real-world data

  • Proven ability to work independently in a lean team environment

  • Strong communication skillsyou can explain numbers to non-technical users

  • Curiosity and ownershipyou dont just build reports, you improve them

Nice to have:

  • Experience in healthcare, social services, or nonprofit environments
  • Python (Requests, Pandas)

Why This Role Matters

  • Your work will directly support program outcomes and community impact
  • Youll reduce confusion and duplicationbringing clarity to how we measure success
  • Youll play a key role in our journey toward trusted, accessible data across the organization

Pay rate: $85,000-90,000 per year

About the Company

M

Maryville Academy