Under supervision of the Associate Provost, the Business Intelligence Solutions Developer II works cooperatively with staff from the Frist College of Medicine to support reporting, business intelligence and data quality through the development, testing and maintenance of BI solutions including complex SQL queries, ETL development, integration tools, and report authoring.

Primary position responsibilities: 

Work cooperatively with staff from the Frist College of Medicine to design, develop and maintain tables, complex views, scripts and queries in an Oracle and SQL Server environment to support the BI and reporting infrastructure for Frist College of Medicine.Provide leadership in the design, development, and maintenance of business intelligence solutions, including creating/maintaining the university data warehouse, metadata management, database modeling, ETL, multidimensional cubes and other analytical tools.Support 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.Work cooperatively with staff from Information Technology and other areas as needed to ensure university-wide standards are met for data warehousing, reporting and business intelligence.Design, develop and maintain SQL queries and application programs to manage the transfer of data among systems, utilizing MS and Oracle SQL, Python or Boomi or other standard programming languages and tools.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.