Business Intel Developer I

As a community, the University of Rochester is defined by a deep commitment to Meliora - Ever Better. Embedded in that ideal are the values we share: equity, leadership, integrity, openness, respect, and accountability. Together, we will set the highest standards for how we treat each other to ensure our community is welcoming to all and is a place where all can thrive. Job Location (Full Address): 120 Corporate Woods, Rochester, New York, United States of America, 14623 Opening: Worker Subtype: Regular Time Type: Full time Scheduled Weekly Hours: 40 Department: 500160 Pharmacy SMH Work Shift: UR - Day (United States of America) Range: UR URG 109 Compensation Range: $56,500.00 - $79,100.00 The referenced pay range represents the minimum and maximum compensation for this job. Individual annual salaries/hourly rates will be set within the job's compensation range, and will be determined by considering factors including, but not limited to, market data, education, experience, qualifications, expertise of the individual, and internal equity considerations. Responsibilities: Delivers focused reporting and business analytics. Partners with the requestor to understand the business problems/challenges and creates meaningful and creative solutions that address these problems/challenges. Develops departmental and ad hoc reports in Crystal Reports, SQL tools (SSRS/T-SQL) or Tableau. ESSENTIAL FUNCTIONS Verifies logic for reports and data analysis using advanced functionality within Microsoft SQL tools (SSRS/T-SQL), Crystal Reports, and/or Tableau or other reporting applications. Develops, delivers, and maintains, at the direction of senior team members, efficient reports, visualizations, and dashboard solutions to enhance end-users understanding of information. Partners with requestor to understand clinical, financial, and business requirements related to reporting applications. Assists with assessing and estimating requests to determine scope and effort required, at the direction of senior team members. Prepares and presents concise summaries to explain findings and limitations based upon actionable insight. Makes recommendations for changes as appropriate, in partnership with senior team members. Performs proper testing and validation techniques to ensure accuracy and integrity of reported or extracted data and documents the unit test and validation processes used. Performs analysis of operational data for operational management, performance metrics, identification of trends, and statistical variances. Creates and manages reports critical to the operations and performance of the department to maintain accuracy of recorded data for accreditation and compliance with federal and state regulations. Creates analytics content, including reports, extracts, data visualizations, and data views based on specifications created by department leadership. Utilizes the UR Medical Center's Data Repositories and supporting applications in analysis. Other duties as assigned. MINIMUM EDUCATION & EXPERIENCE Bachelor's degree and 2 years of related experience required Or equivalent combination of education and experience KNOWLEDGE, SKILLS AND ABILITIES Knowledge of SQL, SSRS, Tableau, reporting and analytics project management preferred Critical thinking and strong problem-solving capabilities preferred Proven customer service orientation preferred Strong verbal and written communication skills preferred The University of Rochester is committed to fostering, cultivating, and preserving an inclusive and welcoming culture to advance the Universitys Mission to Learn, Discover, Heal, Create and Make the World Ever Better. In support of our values and those of our society, the University is committed to not discriminating on the basis of age, color, disability, ethnicity, gender identity or expression, genetic information, marital status, military/veteran status, national origin, race, religion, creed, sex, sexual orientation, citizenship status, or any other characteristic protected by federal, state, or local law (Protected Characteristics). This commitment extends to non-discrimination in the administration of our policies, admissions, employment, access, and recruitment of candidates, for all persons consistent with our values and based on applicable law. Notice: If you are a Current Employee, please log into myURHR to search for and apply to jobs using the Jobs Hub. Your application, if submitted using this portal, cannot be moved forward. Learn. Discover. Heal. Create. Located in western New York, Rochester is our namesake and our home. One of the worlds leading research universities, Rochester has a long tradition of breaking boundariesalways pushing and questioning, learning and unlearning. We transform ideas into enterprises that create value and make the world ever better. If youre looking for a career in higher education or health care, the University of Rochester may offer the perfect opportunity for your background and goals. At the University of Rochester, we are committed to fostering, cultivating, and preserving an inclusive and welcoming culture and are united by a strong commitment to be ever betterMeliora. It is an ideal that informs our shared mission to ensure all members of our community feel safe, respected, included, and valued.