Rosalind Franklin University of Medicine and Science is seeking a BI Developer & Report Writer to enhance their data-driven decision-making processes by providing reliable and insightful reporting solutions. This role will support the institution's mission and strategic goals by ensuring timely delivery and data accuracy of standardized reports and enterprise dashboards.
Requirements
- 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.
- Advanced SQL querying and scripting.
- Proficiency in database systems and data warehousing concepts.
- Experience designing dimensional models.
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.
Other
- Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field.
- 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.
- Excellent analytical and problem-solving skills.
- Strong communication and interpersonal skills, with the ability to effectively collaborate with both technical and non-technical stakeholders.
