Business Intelligence Solutions Developer
Belmont University in Nashville is currently recruiting for new talent within the Office of Assessment and Institutional Research (OAIR.) Our office is responsible for internal and external reporting, academic assessment, data governance, business intelligence, and the University Data Warehouse. We are looking for a Business Intelligence Solutions Developer to help support our growing university. Join our dedicated team of talented professionals!
For full details and to apply, visit the link below.
Business Intelligence Solutions Developer - This position will assist in designing and developing star schema models and OLAP cubes for the university data warehouse as well as operational reporting and database management.
Primary Duties and Responsibilities:
Under supervision of the Assistant Provost, the Business Intelligence Solutions Developer I provides support for reporting, business intelligence and data quality through the development, testing and maintenance of BI solutions including complex SQL queries, ETL development and report authoring.
· Develop, test and maintain robust, well-designed reports to fulfill data reporting needs of OAIR and the university.
· Create innovative ways to display data for regular internal review including the development of dashboards and/or other data viewing tools.
· Work with team members to develop and maintain tables, complex views, scripts and queries in an Oracle and SQL Server environments to support the BI and reporting infrastructure.
· Participate in the development and maintenance of business intelligence solutions including the university data warehouse, metadata management, ETL, dashboards, visualizations, reports, multidimensional cubes and other analytical tools.
· Assist with university data governance through creation of technical documentation, business process documentation, training materials, and metadata such as business definitions, technical details and the university data dictionary.
· Develop proficiency with business intelligence, reporting, data warehousing and institutional research concepts.
· The above statements describe the job’s essential responsibilities and requirements. They are not an exhaustive list of the duties that may be assigned to job incumbents.
Required Qualifications:
· Demonstrated skills related to relational databases, star schemas, ETL, reporting, and business intelligence. Knowledge of software used in a typical higher-education setting including Banner, Recruiter, Argos, and/or Degree Works preferred.
· A basic foundation of knowledge and skills in applications programming and systems analysis and related programming support functions.
· Ability to write complex oracle queries to verify and reconcile data for accuracy and consistency.
· Requires excellent oral and written communication skills.
· Highly motivated individual with the ability to work independently or with a team; possess the experience to be fully proficient in performing the work assignments defined by their position.
Required Education: Bachelor’s degree required; preferred in computer science, information systems or related field.
Required Experience: One or more years of related experience including database/SQL experience. Prior experience in higher education and business intelligence preferred.