BI Report Developer 1

200 UM Corp (Enterprise); United States; On-site; USD 65,000 - 85,000; Full time

Job summary

The University of Miami Graduate School is seeking a full-time BI Report Developer 1 to design, develop, and maintain business intelligence reports and dashboards at the Coral Gables campus. You will configure metadata, understand user reporting needs, and collaborate with ETL developers and application analysts to deliver robust BI solutions.

You will ensure data quality and governance, supporting graduate admissions, enrollment, time to degree, and outcomes reporting while preparing

Qualifications

• Bachelor's degree in a quantitative field (statistics, data science, information systems, etc.)
• Experience with BI reporting and dashboard design
• Strong data governance and FERPA familiarity

Responsibilities

• Designs, develops, and maintains BI reports and dashboards.
• Creates and configures metadata objects.
• Works with ETL developers to determine report design strategies.
• Analyzes reporting needs and suggests BI solutions.
• Maintains security setup, tool administration, and data modeling.
• Builds and documents dashboards for graduate programs and outcomes.

Skills

SQL

Tableau

Power BI

Python or R

Advanced Excel

Dashboard/report design

Cohort and longitudinal measures

FERPA handling

Clear writing/presentation

Git/version control

Education

Bachelor's degree

Master's degree preferred

Tools

Tableau

Power BI

Git

Job description

The University of Miami, Graduate School, has an exciting opportunity for a full time BI Report Developer 1 to work in Coral Gables, FL.

Core responsibilities:

• Designs, develops, and maintains business intelligence reports and dashboards.
• Creates and configures metadata objects.
• Develops a strong understanding of user reporting needs and makes recommendations on how reports can be developed using BI tools.
• Works with ETL developers to determine report design strategies.
• Works with application analysts to identify and understand source data systems.
• Analyzes possible reporting alternatives in relationship to business needs, costs, effectiveness, and information availability requirements.
• Works on security setup and maintenance, tool administration, and data modeling.
• Develops or assists in the creation of project time estimates.
• Develops and implements application documentation and training materials.
• Provides post-implementation support of user questions and fine-tuning of processes.
• Maintains communication with management and users during the development or maintenance cycle.
• Adheres to University and unit-level policies and procedures and safeguards University assets.

Department Specific Functions:

• Pulls graduate student data each term from the student information system, the admissions system, degree and milestone records, and the National Student Clearinghouse, and keeps one certified source the Graduate School reports from.
• Checks every figure against the official count held by the Registrar and Institutional Research before it is published and explains any difference in writing.
• Freezes each term so that a report run a year later reproduces the number that was published and logs any figure that is restated.
• Collects career and employment outcomes for graduates, and records how each cohort was tracked and how many graduates were found.Reports data problems to the office that owns the data rather than correcting them quietly.
• Writes and maintains the definition of every published measure, including entering cohort, new student, completion, attrition, time to degree, and placement.
• Builds completion, attrition, and time to degree by entering cohort for doctoral and master's programs.
• Uses federal and association categories where they exist, including Integrated Postsecondary Education Data System, National Center for Science and Engineering Statistics, and Association of American Universities Data Exchange definitions, and notes where a University category differs.
• Suppresses small cells, and reports counts rather than percentages when a program is too small to carry a rate.
• Builds and maintains the graduate program outcomes dashboard, covering admissions, enrollment, progress, completion, time to degree, and careers after graduation.
• Sets access so that each user sees their own level, program director, associate dean, dean, graduate dean, and provost, from one data source rather than separate files.
• Builds the annual program review packet and the provost and Faculty Senate exhibits from that same source, so every document agrees.
• Builds the public PhD program data pages in a form a prospective student can read.
• Makes every product accessible, including figures that still read in grayscale print and tables a screen reader can follow.
• Writes a one- or two-page summary with each dashboard, stating what changed, by how much, and what to do about it.
• Identifies programs outside the normal range on applications, yield, enrollment, completion, or time to degree, and prepares the briefing a dean needs for that conversation.
• Gives each recommendation an owner and a review date, and reports back on what was done.
• Reports the number of students behind every percentage and does not claim a cause the data cannot show.
• Meets each school and college on a set schedule to review program outcomes and record what is decided.
• Trains associate deans, program directors, and program staff to use the dashboards on their own.
• Prepares program outcome and career pathway material for graduate students and postdoctoral appointees.

Records and documentation:

• Handles student records under the Family Educational Rights and Privacy Act, and keeps identifiers only where they are needed.
• Keeps a written methods document with sources, definitions, suppression rules, and known limits, and publishes it with the reports.
• Keeps all code in version control so that another analyst can reproduce any published figure.
• This list of duties and responsibilities is not intended to be all-inclusive and may be expanded to include other duties or responsibilities as necessary.

Core Qualifications:

• Bachelor's degree required, as in the core profile.
• Relevant fields include statistics, data science, information systems, higher education, educational measurement, economics, sociology, public policy, and any field in which the candidate carried out quantitative research.
• Master's degree preferred in one of those fields or in institutional research.
• Minimum 3 years of relevant experience required.
• Learning Agility: Ability to learn new procedures, technologies, and protocols, and adapt to changing priorities and work demands.
• Teamwork: Ability to work collaboratively with others and contribute to a team environment.
• Technical Proficiency: Skilled in using office software, technology, and relevant computer applications.
• Communication: Strong and clear written and verbal communication skills for interacting with colleagues and stakeholders.

Required skills:

• SQL, including multiple table joins and aggregation.
• One enterprise business intelligence platform at an advanced level, Tableau or Power BI.
• One programming language, Python or R.
• Excel at an advanced level, including pivot tables and lookups.
• Dashboard and report design for mixed audiences, including access by role and accessible, printable figures.
• Cohort and longitudinal measures: completion, attrition, time to degree, and yield.
• Handling of student records under FERPA, including small cell suppression.
• Clear writing and presentation for deans, faculty, and students.

Preferred skills:

• Workday.
• Slate.
• Qualtrics or a comparable survey platform.
• IPEDS submissions, NSF Survey of Earned Doctorates, AAUDE, and National Student Clearinghouse StudentTracker.
• Git or another version control system.
• Experience in a graduate or doctoral program setting.
• Any relevant education, certifications and/or work experience may be considered.

The University of Miami is recognized as one of the nation's premier research institutions and academic health systems and is among the largest employers in South Florida. With more than 20,000 faculty and staff, the University is committed to excellence and guided by a mission to positively impact the lives of students, patients, and communities locally and globally. We are dedicated to fostering a culture where every individual feels valued and empowered to contribute meaningfully. United by shared values, the University community works together to build an environment defined by purpose, collaboration, and service.

The University of Miami is an Equal Opportunity Employer. Applicants and employees are protected from discrimination based on certain categories protected by Federal law.

Job Status: Full time Employee Type: Staff

The mission of the University of Miami is to transform lives through education, research, innovation, and service. A vibrant and diverse academic and healthcare community, the University of Miami and the University of Miami Health System ("UHealth") have rapidly progressed to become one of the nation's top research universities and academic medical centers in the nation. The University comprises 12 schools and colleges serving undergraduate and graduate students in more than 350 majors and programs. Visit welcome.miami.edu/about-um to learn more about our points of pride. The University ranks No. 55 on U.S. News & World Report’s 2022 Best Colleges list and ranked No. 49 in the 2022 Wall Street Journal/Times Higher Education College Rankings. Bascom Palmer Eye Institute is ranked the #1 eye hospital in the USA and offers some of the nation's premiere eye doctors to treat every eye condition for adults. Sylvester Comprehensive Cancer, part of the Miller School of Medicine, received the prestigious National Cancer Institute designation in 2019. The University of Miami and UHealth have also ranked among the Forbes Best Employers and Best Employers for Women on several occasions, most recently in 2022. With more than 17,000 faculty and staff, the University strives for excellence, and is driven by a powerful mission to transform and impact the lives of its students, patients, members of the community, and people across the globe.

The University of Miami is an Equal Opportunity Employer. Applicants and employees are protected from discrimination based on certain categories protected by Federal law.