Sr Business Intel Developer

Responsibilities

• Completes all development work assigned.
• 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.
• Creates and reviews data audit and quality processes for the validation of deliverables.
• Utilizes software to generate metrics and develops actionable recommendations.
• Serves as the lead application administrator for the Business Intelligence application which includes upgrades, patching, configuration and directory/security administration.
• Serves and assists as a systems administrator for the infrastructure supporting the business intelligence (BI) applications listed above including configuration, troubleshooting and periodic maintenance.
• Supports the development of strategies for warehouse implementation, data acquisitions and archive recovery.
• Develops SQL queries and modifications to facilitate problem resolution and reporting needs.
• Leads design sessions to capture requirements and data for report development.
• Develops/reviews report specifications and ensures those requirements are met across all functional areas (e.g. procurement, finance, student, executive/University-wide etc.).
• Translates/ reviews business requirements into report objects with appropriate security.
• Analyzes team member’s reports to ensure they meet user requirements.
• Develops, reviews and enables solutions (reports, visualizations) to support the University’s goals.
• Validates the audit and reconciliation processes associated with reporting.
• Ledds activities supporting development and maintenance of security architecture, security administration and workflow automation within the applications suite.
• Ensures conformance to departmental/university standards and procedures by reviewing and preparing necessary paperwork and documentation.
• Executes unit tests.
• Works closely with application testers on the preparation of test plans, test data and integrated unit testing.
• Maintains a broad knowledge of technology, equipment, and/or systems.
• Designs and delivers executive reports as well as function specific reporting.
• Develops and enables reporting solutions to interact with cloud-based solutions.
• Writes ad-hoc queries and reports using various reporting/database tools to support research, financial, and executive initiatives.
• Analyses and synthesizes complex and diverse information gathered from senior management and end-users to develop new reports and reporting systems as needed.
• Designs, develops and implements complex dashboard reports and visualizations for data warehouse and clarity.
• Outlines strategies for the development and maintenance of environments that support the applications used for report writing.
• Serves as a mentor and change management lead in the delivery of reporting training.
• Performs other related duties, including presentation of seminars, courses and instruction on computer services as required.

Qualifications

• Bachelor’s Degree in related discipline required.
• Master’s degree preferred.
• 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.
• 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.

Skills and Abilities

• 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.
• 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.
• In depth experience and developmental knowledge with SQL programming preferred.
• Ability to provide on-call support as required preferred.