BI Developer & Report Writer

Salary : $72,735 -$83,000 Depending on experience and qualifications.

Position Summary :

Information Technology Services at Rosalind Franklin University of Medicine and Science invites applications for a full-time BI Developer & Report Writer. The University encourages applications from individuals belonging to groups underrepresented in their field and those who can add new and valuable perspectives to the academic environment.

The BI Developer & Report Writer is an integral member of the Information Technology (IT) department, responsible for the technical development, infrastructure, data extraction, transformation, and loading (ETL) for institutional reports and enterprise dashboards. This role works in close collaboration with Institutional Effectiveness and Decision Support (IEDS) and Student Enrollment Management teams to translate business requirements into technical specifications, ensuring timely delivery and data accuracy of standardized reports. This position is critical in supporting the institution's data-driven decision-making processes by providing reliable and insightful reporting solutions that contribute to the university's mission and strategic goals, including the mentoring of junior report writers.

Our generous benefits package includes medical, dental, and vision plans; paid parental leave; short term and long term disability plans; life insurance; flexible spending accounts; and a 403(b) retirement plan which includes a 8% employer contribution after 2 years of service. RFUMS is committed to employee wellbeing and work-life balance. Full time staff are eligible for 3 weeks of vacation / personal leave, 15 sick days, and 9 paid holidays, paid winter break, plus two floating holidays.

This position may be eligible for a remote or hybrid work arrangement.

Who We Are

The Department of Information Technology Services (ITS) provides students, faculty, and staff with technology resources and support services that foster the mission, vision, and strategic plan of Rosalind Franklin University. Our vision is to be an enabler of innovation and a valued community partner that enhances the education of future health care professionals, assists researchers in the process of scientific discovery, and improves the technology skills of the RFU community.

ITS is responsible for the planning, management, and direction of technology initiatives in support of the academic and administrative operations at RFU. We are committed to developing and maintaining highly effective, reliable, secure information systems that support instructional, administrative and research functions.

ITS is composed of professional staff spread across multiple teams with a common set of skills and ambition, and a desire to collaborate both internally and externally with the RFU community.

Essential Duties & Responsibilities

• Report Development :

Develop, design, and maintain BI dashboards and institutional reports using tools such as Power BI, SSRS, or similar platforms for various departments, including Admissions, Registrar, Financial Aid, HR, Finance, Sponsored Research, and Student Affairs, ensuring data integrity and user-friendliness.

Serve as a custodian of the technical reporting infrastructure and metadata repository, focusing on data types, lengths, formats, constraints, and physical locations, to ensure data quality and accessibility.

Ensure the timely availability and secure distribution of standardized reports to operational, academic, and administrative units, with appropriate access controls.

Partner with Institutional Effectiveness and Decision Support (IEDS) and Student Enrollment Management teams to develop standardized, validated data sets for institutional reporting.

Required Education and Experience

Required Knowledge, Skills, and Abilities

Preferred Qualifications

Typical Physical Demands & Working Conditions

EOE, Including Disability / Vets