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.
Education: Bachelor’s degree required; preferred in computer science, information systems or related field.
Experience: 5 years of progressive experience in directly related projects. Experience in a University environment, especially medical education preferred.
Minimum Qualifications (Knowledge, Skills, and Abilities):
- Ability to identify issues, obtain relevant information, relate and compare data from different sources, and identify alternative solutions.
- Interprets and seeks information, uses independent reasoning to diagnose the root cause of situations or issues, identifies and tests solutions and thinks beyond what is typical or customary. Uses information to determine benefits and impact in making decision and/or recommendations.
- Ability to coordinate and administer programs/project activities and protocols. Ability to manage resources, monitor activities, and assess risks and quality issues associated with the program/project.
- Ability to present information to individuals or groups; ability to deliver presentations suited to the characteristics and needs of the audience. Ability to convey information clearly and concisely to groups or individuals either verbally or in writing to ensure that they understand the information and the message. Ability to listen and respond appropriately to others. Ability to impact and influence others to further the institution’s strategic objectives.
- Ability to use Microsoft Office (Excel, PowerPoint, Word) and basic databases and software.
- Database expertise including complex SQL queries and database design.
- Strong knowledge of Kimball model data warehouse architecture.
- Familiarity with data systems commonly used in medical education.
- Experience with API integration methodologies, especially Boomi.
- Programming techniques and language proficiency including Python.
- Experience working in a fast-paced environment and the ability to respond to high-pressure situations. Ability to thrive in an environment of hard work.
- Ability to work effectively with a wide range of constituencies in a diverse community.
Job Type: Full-time
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Health insurance
- Life insurance
- Paid time off
- Retirement plan
- Vision insurance
Schedule:
Work Location: In person
