Business Intelligence Developer

About ECC:

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.

Work Schedule:

8:00 AM to 5:00 PM Monday through Friday

Rate of Pay:

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

Job Summary:

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.

Required Knowledge, Skills & Abilities:

Bachelor's degree in data science, computer science, information systems, statistics, business analytics, or a related field; or equivalent combination of education and experience.

Advanced proficiency with data visualization tools such as Tableau and Power BI.

Minimum four years of experience in data analysis, business intelligence, or dashboard/report development.

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

Strong understanding of relational database design, data warehousing, and ERP systems (e.g., Ellucian Colleague).

Proficiency with statistical software (e.g., SPSS preferred, SAS, or R) and programming/syntax experience.

Ability to manage and prioritize multiple projects independently and meet deadlines.

Demonstrated success collaborating with senior leadership, IT, and academic/administrative teams.

Experience presenting statistical analysis and research findings to audiences with varying levels of technical expertise.

Ability to translate complex data into clear, actionable insights for non-technical users.

Strong written and verbal communication skills, including training and presentation experience.

Desired Knowledge, Skills & Abilities:

Master's degree

Essential Duties:

Develop and maintain dashboards and data visualizations using tools such as Tableau, SQL, Excel, and SPSS to support decision-making across the College.

Prepare and manage data sources, update dashboards as needed, and ensure accuracy and integrity of institutional data.

Provide training and support to faculty, administrators, and staff to promote effective use of dashboards and improve data literacy.

Respond to ad hoc data requests, extract and prepare datasets from Ellucian Colleague, and perform advanced statistical analyses, including predictive modeling and hypothesis testing.

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)

Visual Acuity:

Close visual acuity (e.g. computer, assembly)

Work Environment:

Moderate noise

Environmental Conditions:

Typical office or administrative

Current SSECCA Union Member Information:

The initial posting date for this position is 01/09/2026. Elgin Community College Support Staff Association (SSECCA) members that apply by 01/16/2026 and meet the posted minimum qualifications will receive full consideration.

Equal Employment Opportunity Statement:

Elgin Community College does not discriminate, or tolerate discrimination, against any member of its community on the basis of race, color, national origin, ancestry, sex/gender/gender identity, age, religion, disability, pregnancy, veteran status, marital status, sexual orientation, or any other status protected by applicable federal, state or…