Sr Business Intel Developer

The Senior Business Intelligence Developer is responsible for completing all development work assigned. The Senior Business Intelligence Developer collaborates with cross functional teams and provides leadership for design, development, configuration, testing, implementation, maintenance, security of reporting and associated applications supporting University systems and applications. This position creates and reviews data audit and quality processes for the validation of deliverables. The Sr Business Intelligence Developer utilizes software to generate metrics and develops actionable recommendations and may serve as the primary administrator for the business intelligence application tools. This position provides support to research teams or management by collecting and analyzing data and reporting results based on the needs of end users and collaborates with various functional teams based on their area of focus and IT to achieve business results.

Responsibilities

Completing all development work assigned; Collaborating with cross functional teams and providing leadership for design, development, configuration, testing, implementation, maintenance, security of reporting and associated applications; Creating and reviewing data audit and quality processes for the validation of deliverables; Generating metrics and developing actionable recommendations; Serving as primary administrator for business intelligence application tools; Providing support to research teams or management by collecting and analyzing data and reporting results; Serving as lead application administrator for Business Intelligence application including upgrades, patching, configuration and directory/security administration; Developing SQL queries and modifications to facilitate problem resolution and reporting needs; Leading design sessions to capture requirements and data for report development; Developing/reviewing report specifications and ensuring requirements are met across functional areas; Translating/reviewing business requirements into report objects with appropriate security; Developing/reviewing/enabling solutions (reports, visualizations) to support University goals; Validating audit and reconciliation processes associated with reporting; Leading activities supporting development and maintenance of security architecture, security administration and workflow automation; Ensuring conformance to departmental/university standards and procedures; Executing unit tests; Designing and delivering executive reports; Developing and enabling reporting solutions to interact with cloud-based solutions; Writing ad-hoc queries and reports using various reporting/database tools; Analyzing and synthesizing complex and diverse information to develop new reports; Designing, developing and implementing complex dashboard reports and visualizations; Supporting University’s communications outlets for reporting tools; Coordinating with other resources to achieve goals; Serving as mentor and change management lead in delivery of reporting training; Performing other related duties

Requirements

Bachelor’s Degree in related discipline required; 5 years of relevant experience, including experience with developing reports and dashboards with one or more Business Intelligence tools such as PowerBI, Business Objects, MicroStrategy, Qlik, IBM Cognos, Tableau required; Equivalent combination of education training and/or experience required; Excellent verbal and written communications skills required; Proven customer oriented approach to problem solving required; Ability to handle multiple tasks at one time and meet required deadlines required; Contribute individually and as a technical lead on the team that manages multiple business environments; interface with user communities to translate business needs into solution requirements required

Nice to have

Master’s degree preferred; Experience in higher education field, medical or healthcare industry preferred; Experience with project management methodologies, including Agile, from planning through implementation preferred; 5 years Student, HCM & Finance experience, specifically with reporting preferred; Experience in the Oracle on Unix DBMS environments preferred; Experience with EPIC reporting preferred; Proficiency with reporting tools IBM Cognos, SQL, SSRS and Tableau preferred; Ability to learn new technologies quickly preferred; Ability to translate business needs into solution requirements preferred; Knowledge of implementing expressions and business logic within an object oriented environment preferred; In depth experience and developmental knowledge with SQL programming preferred; Ability to provide on-call support as required preferred; Tableau Desktop Associate Level 1, Level 2 preferred; Workday Report Writer curriculum certificate preferred; Epic Clinical Data Model and/or Epic Revenue Data Model may be required within 12 months of hire preferred