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

Complete all development work assigned; Collaborate with cross functional teams and provide leadership for design, development, configuration, testing, implementation, maintenance, and security of reporting and associated applications; Create and review data audit and quality processes for validation of deliverables; Utilize software to generate metrics and develop actionable recommendations; Serve as primary administrator for business intelligence application tools; Provide support to research teams or management by collecting and analyzing data and reporting results; Serve/assist as lead application administrator for Business Intelligence application including upgrades, patching, configuration and security administration; Develop SQL queries and modifications to facilitate problem resolution and reporting needs; Lead design sessions to capture requirements and data for report development; Develop/review report specifications and ensure requirements are met across functional areas; Translate/review business requirements into report objects with appropriate security; Develop, review and enable solutions (reports, visualizations) to support University goals; Validate audit and reconciliation processes associated with reporting; Lead activities supporting development and maintenance of security architecture, security administration and workflow automation; Execute unit tests; Work with application testers on test plans, test data and integrated unit testing; Design and deliver executive reports and function specific reporting; Develop and enable reporting solutions to interact with cloud-based solutions; Write ad-hoc queries and reports using reporting/database tools; Design, develop and implement complex dashboard reports and visualizations for data warehouse and clarity; Outline strategies for development and maintenance of environments supporting report writing; Support University communications outlets for reporting tools; Coordinate with other resources to achieve goals; Mentor and deliver reporting training; Perform other related duties

Requirements

Bachelor's degree and 5 years of relevant experience required; Or equivalent combination of education and experience; Experience with developing reports and dashboards with one or more Business Intelligence tools, such as PowerBI, Business Objects, MicroStrategy, Qlik, IBM Cognos, Tableau, 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 of Student, HCM & Finance experience, specifically with reporting, preferred; Experience in Oracle on Unix DBMS environment preferred; Experience with EPIC reporting preferred; Proficiency with reporting tools IBM Cognos 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 needed preferred; Certified Tableau Specialist (Tableau Desktop Associate Level 1, Level 2) upon hire preferred; Workday Report Writer curriculum certificate upon hire preferred; Epic Clinical Data Model and/or Epic Revenue Data Model may be required within 12 months of hire preferred