Business Intelligence Developer

The Business Intelligence Developer transforms institutional data into actionable insights that drive strategic planning, operational efficiency, and student success. This role designs, develops, and maintains interactive dashboards and visualizations (currently using Tableau), automates reporting processes, and ensures data accuracy and integrity. The BI Developer works closely with stakeholders to understand data needs, create user-friendly reporting solutions, and promote a culture of data-informed decision-making. Additional responsibilities include building data pipelines, streamlining reporting workflows, and providing training and support to enhance data literacy across the college., 1. Develop and maintain dashboards and data visualizations using tools such as Tableau, SQL, Excel, and SPSS to support decision-making across the College.

1. Prepare and manage data sources, update dashboards as needed, and ensure accuracy and integrity of institutional data.
2. Provide training and support to faculty, administrators, and staff to promote effective use of dashboards and improve data literacy.
3. Respond to ad hoc data requests, extract and prepare datasets from Ellucian Colleague, and perform advanced statistical analyses, including predictive modeling and hypothesis testing.
4. Collaborate and consult with College committees and stakeholders on data analysis and reporting needs

Other Duties:

Perform other duties as assigned which pertain to the job description.

Physical Demands:

Light (up to 25 lbs occasionally or 10 lbs frequently)

1. Bachelor’s degree in data science, computer science, information systems, statistics, business analytics, or a related field; or equivalent combination of education and experience.
2. Advanced proficiency with data visualization tools such as Tableau and Power BI.
3. Minimum four years of experience in data analysis, business intelligence, or dashboard/report development.
4. Two or more years of experience with data warehouses or data management systems and common query/reporting tools (e.g., SSMS, SQL, TOAD, Cognos, SSRS, Crystal Reports).
5. Strong understanding of relational database design, data warehousing, and ERP systems (e.g., Ellucian Colleague).
6. Proficiency with statistical software (e.g., SPSS preferred, SAS, or R) and programming/syntax experience.
7. Ability to manage and prioritize multiple projects independently and meet deadlines.
8. Demonstrated success collaborating with senior leadership, IT, and academic/administrative teams.
9. Experience presenting statistical analysis and research findings to audiences with varying levels of technical expertise.
10. Ability to translate complex data into clear, actionable insights for non-technical users.
11. Strong written and verbal communication skills, including training and presentation experience.

Desired Knowledge, Skills & Abilities:

Master’s degree

This is a Full-Time Support Staff position at grade 215, with an annual salary range of $73,983 to $98,644. The salary offer will be based on education and experience, in alignment with the College’s compensation philosophy and the current Collective Bargaining Agreement (CBA), if applicable.

Benefits:

• Medical, Dental, Vision Insurance
• Life and Long-Term Disability Insurance
• Flexible Spending Account (FSA, DCA, Commuter)
• Retirement Plans (Pension, 457b, 403b)
• Time Off with Pay
• Professional Development/Expense
• Tuition Reimbursement
• Employee Assistance Program (EAP)
• Sick Banks

FLSA Status: Exempt

Grant Funded: No

Elgin Community College serves over 9,000 students at every stage of their educational journeys, including university transfer programs, career and technical education, continuing education classes, and adult basic education. As a community, we pride ourselves on nurturing a welcoming campus where every person-students, staff members, faculty members, and campus visitors-feels valued. The work of each ECC employee is central to the college’s mission, and as an employer, the college fosters a positive environment through professional challenges, excellent benefits, and opportunities for recognition and camaraderie.