Business Intelligence Developer

About the role

Reporting to the Senior Associate Director of Business Intelligence in Development and University Relations (DAUR), the Business Intelligence Developer is responsible for designing, developing, and implementing sophisticated enterprise-level reporting solutions. This position leverages expertise in leading BI platforms such as Evision Argos, Cognos Analytics and Entrinsik Informer to meet complex business intelligence needs. The incumbent will partner with the Senior Associate Director of Business Intelligence to create and enhance custom reports, monitor and tune queries, and participate in business and technical discussions with leadership and end-users to ensure high-quality reporting solutions.

Responsibilities

• Assists with designing and developing tabular, paginated data standard and ad-hoc reports, as well as complex data extracts using MS SQL and Oracle data sources to support strategic and operational needs.
• Implements and optimizes automated workflows to ensure accurate data processing and to support report refreshes for system integrations.
• Participates in functional, technical, and user acceptance testing efforts and resolves defects to ensure solutions are flawless.
• Researches and tests other operational data reporting solutions to expand current reporting capabilities.
• Helps maintain and refine the existing reports, inventory, and data extract programs to meet evolving analytics needs, identifying other BI platforms where appropriate.
• Gathers and documents requirements for major new reporting development projects.
• Helps create and maintain reporting best practices and standards documentation.
• Maintains an in-depth knowledge of DAUR business requirements, specifications, and practices to guide BI/analytics development projects.
• Supports the upgrade and testing of business intelligence platform software releases.
• Develops and documents training materials as needed.

Requirements

• Bachelor’s degree and a minimum of two years of business intelligence development experience or an equivalent combination of education and experience.
• Strong proficiency working with SQL to develop enterprise reporting solutions.
• Proficiency with MS SSRS, MS SQL Server Management Studio, including strong SQL coding experience.
• Excellent problem-solving abilities to identify, analyze, and rectify coding problems.
• Exceptional communication and interpersonal skills, with the ability to collaborate effectively with technical and non-technical colleagues.

Preferred Qualifications

• Experience developing solutions in the WebFOCUS business intelligence platform.
• Previous experience in a higher education environment.

Pay

Minimum Starting Salary: $90,000
Maximum Starting Salary: $110,000
Salary is commensurate with qualifications, experience, and skills.