The Decision Support BI Programmer position will work with stakeholders to gather requirements, document requirements and design solutions. Typically works with management, business analysts, project managers, and end-users to ensure that delivery expectations are met. The position requires a broad business perspective and a willingness to step into multiple roles.
Reporting to the Director of Information Systems (IS), the BI Developer role at UCPG is primarily focused on developing physician practice plan and physician revenue cycle business intelligence solutions leveraging the Microsoft BI suite of products (SQL Server, Integration Services, Analysis Services, Reporting Services).
Design data marts, cubes, reports, dashboards and scorecards using data from disparate and varied database sources within a large academic medical center. Data marts will be sourced from GE Centricity Business and other systems involved in physician revenue cycle and practice management.
Develop VBA macros and scripts to automate routine tasks in the physician revenue cycle management system, and GE Centricity Business.
Design, build, query, analyze, troubleshoot and maintain cubes and data marts using Microsoft SSIS, SSAS; SQL and MDX query languages.
Develop dashboard and scorecard solutions utilizing a mixture of BI tools, including but not limited to Microsoft SQL Server Reporting Services, Microsoft SharePoint and Performance Point Services.
Work with management, business analysts, other team members and clients to document business requirements and prepare technical design documents. Coordinate with all users to ensure development efforts provide business value.
Develop macros and scripts to facilitate automation of tasks using VBA. Research new technology; strive to elevate BI solutions at UCPG to the next level.
Education, Experience, and Certifications:
Bachelor's degree in computer science or another relevant computer related field required.
Advanced degree in mathematics, computer science, electrical engineering, or a related field preferred.
Dual degree or concentration in system design preferred.
Microsoft developer certifications preferred.
Three years of relevant programming experience required
Experience implementing Extract, Transform, Load (ETL) solutions with data from multiple systems required
Experience writing SQL queries and designing reports required
Experience writing VBA macros preferred
At least two years' experience with data warehousing, data modeling and Microsoft BI tools (SSAS, SSRS, SSIS, MDX) preferred
Healthcare experience preferred
Technical Knowledge or Skills:
Excellent verbal and written communication and relationship-building skills; able to build strong, open and honest relationships required
Good team skills, able to work with a wide range of stakeholders to achieve successful solutions required
Excellent organizational skills required
Ability to comply with HIPAA standards confidentiality and security of PHI required.
Knowledge of concepts, practices, and procedures of software development required.
Excellent verbal and written communication skills required.
Ability to use standard software development applications and tools required.
Ability to use analytical and quantitative skills and diagnostic techniques to resolve problems required.
Ability to manage complex technical details required.
Ability to communicate technical concepts to non-technical staff required.
Ability to work in a collaborative team environment required.
Confidentiality related to sensitive University matters such as, strategic initiatives, trade secrets, quiet periods, and scientific discoveries yet to be put in the public domain required.
Ability to work on a flexible schedule which will include occasional late night and/or weekend hours required.
Reference Contact Information
The University of Chicago is an Affirmative Action/Equal Opportunity/Disabled/Veterans Employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national or ethnic origin, age, status as an individual with a disability, protected veteran status, genetic information, or other protected classes under the law. For additional information please see the University's Notice of Nondiscrimination.
Staff Job seekers in need of a reasonable accommodation to complete the application process should call 773-702-5800 or submit a request via the Applicant Inquiry Form.
The University of Chicago's Annual Security & Fire Safety Report (Report) provides information about University offices and programs that provide safety support, crime and fire statistics, emergency response and communications plans, and other policies and information. The Report can be accessed online at: securityreport.uchicago.edu. Paper copies of the Report are available, upon request, from the University of Chicago Police Department, 850 E. 61st Street, Chicago, IL 60637.
Internal Number: JR00083
About University of Chicago
One of the world's premier academic and research institutions, the University of Chicago has driven new ways of thinking since our 1890 founding. Today, UChicago is an intellectual destination that draws inspired scholars to our Hyde Park and international campuses, keeping UChicago at the nexus of ideas that challenge and change the world.