Rosalind Franklin University of Medicine and Science · 2 months ago
BI Developer & Report Writer
North Chicago, IL, US
Full-time
Hybrid
Mid, Senior Level
$73K/yr - $83K/yr
5+ years expRosalind Franklin University of Medicine and Science is seeking a full-time BI Developer & Report Writer to join their Information Technology Services department. This role is responsible for the technical development, infrastructure, and reporting solutions that support data-driven decision-making processes within the university.
Health CareUniversities
Responsibilities
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
Develop reports for academic departments as requested by IEDS
Provide data extracts from supported systems to IEDS for accreditation, state, and federal reporting
Automate recurring reports for operational and academic units as needed to improve efficiency and reduce manual effort
Ensure technical accuracy of data and availability of reports and dashboards
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
Translate business requirements received from IEDS and functional offices into clear and actionable technical specifications
Perform ETL processes to load data into reporting systems and the data lake
Proactively address impacts on reporting due to system upgrades, new modules, and backend integrations, with clear communication to stakeholders
Troubleshoot data, system, and reporting issues, recommending and implementing corrective actions as needed
Ensure the timely availability and secure distribution of standardized reports to operational, academic, and administrative units, with appropriate access controls
Ensure data integrity, consistency, and security in all reporting and data management processes
Partner with Institutional Effectiveness and Decision Support (IEDS) and Student Enrollment Management teams to develop standardized, validated data sets for institutional reporting
Participate in the formal report request process, collaborating with IEDS from intake to development
Mentor and guide junior report writers, including reviewing their work, providing technical and professional feedback, and supporting their continued development in BI tools and methodologies
Establish and promote standards and best practices for report design, visualization, and data governance
Participate in cross-functional project teams and contribute to continuous process improvement initiatives
Qualification
Required
Education: Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field
Minimum of 5+ years of experience in report writing, data warehousing, and Business Intelligence (BI) dashboard development
Proven expertise with Microsoft SQL Server Reporting Services (SSRS) for report creation and management
Strong proficiency in Power BI for dashboard development, data modeling, and visualization
Experience with ETL processes and tools
Familiarity with institutional data definitions and reporting standards in a higher education context to ensure compliance and accurate reporting
Experience with data governance principles and practices
Advanced SQL querying and scripting
Proficiency in database systems and data warehousing concepts
Experience designing dimensional models
Familiarity with version control for reports and dashboards
Excellent analytical and problem-solving skills
Strong SQL and data extraction skills
Strong communication and interpersonal skills, with the ability to effectively collaborate with both technical and non-technical stakeholders
Ability to work independently and as part of a team
Detail-oriented with a strong commitment to data accuracy and quality
Ability to organize, prioritize, and schedule work assignments
Strong documentation skills
Preferred
Knowledge of Ellucian Colleague data structures
Experience working in a Higher Education environment performing the duties shared above
Experience with other BI tools and data visualization platforms is a plus
Benefits
Medical, dental, and vision plans
Paid parental leave
Short term and long term disability plans
Life insurance
Flexible spending accounts
403(b) retirement plan which includes a 8% employer contribution after 2 years of service
3 weeks of vacation/ personal leave
15 sick days
9 paid holidays
Paid winter break
Two floating holidays
Company
Rosalind Franklin University of Medicine and Science
Rosalind Franklin University of Medicine and Science is a school in North Chicago.
501-1000 employees
H1B Sponsorship
Rosalind Franklin University of Medicine and Science has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2024 (4)
2023 (3)
2022 (1)
2021 (1)
2020 (1)
Funding
Current Stage
Late StageTotal Funding
$14.96MKey Investors
National Institutes of HealthEndeavor HealthNorthShore University HealthSystem
2025-12-18Grant· $1.73M
2024-09-26Grant· $9.8M
2024-01-30Grant· $1.75M
Leadership Team
Aron Sousa
President of Rosalind Franklin University of Medicine and Science
Recent News
Company data provided by crunchbase