Business Intelligence Analyst III

University-of-Louisville; Louisville (KY); On-site; USD 70,000 - 100,000; Full time

Job summary

The University of Louisville is seeking a Business Intelligence Analyst III to develop and support the reporting needs for the enterprise data warehouse and other data sources on Belknap Campus in Louisville, KY. You will gather requirements, build data marts, reports, and visualizations, and work with a wide range of users to deliver actionable insights with minimal supervision.

The role requires a Bachelor’s degree with 4 years of experience (or equivalent) and strong SQL/Power BI skills, plus

Qualifications

• Bachelor's degree in a related field and 4 years of relevant experience or equivalent education/experience.
• Preferred: Bachelor's in CIS/Math/Technical area with 5 years of experience.
• Proficient with MS Office 365 – Outlook and Excel; AI experience is a plus.
• Strong communication, teamwork, and project leadership abilities.
• Experience with enterprise reporting systems and SQL tuning.

Responsibilities

• Elicit data requirements for data marts, reports, and applications.
• Build and publish data marts, reports, and visualizations.
• Coordinate development across campus and maintain reports.
• Train users and ensure delivery of timely and accurate insights.

Skills

SQL

MS SQL Server

PowerBI

PowerShell

Education

Bachelor's degree in CIS/Math/Technical area

Tools

MS SSRS

MS SSIS

MS SSMS

Job description

Department:Location:Belknap CampusTime Type:Full timeWorker Type:RegularJob Req ID:R109645Minimum Requirements:Bachelor's degree in a related field and four (4) years of relevant experience or an equivalent combination of education and experience. Grade 8 (Salaried)Position Description:The University of Louisville is seeking to hire a Business Intelligence Analyst III. The main duties are to provide development and support for the reporting needs related to the enterprise data warehouse and other data sources. The job will include requirements gathering, development and maintenance of a variety of data, business intelligence tools and reports using institutionally designated approaches and technologies to ensure success in delivery of customer solutions for reporting.Be able to work with a wide variety of users at all levels of the institution and operate with minimal supervision and direction. Have strong oral and written communication skills and be able to organize and make presentations when required. Be capable of working with teams to complete projects and assignments and should be able to manage multiple projects as one time and take projects from initiation to completion on scheduleEssential Duties and ResponsibilitiesElicit data requirements for data marts, reports, and applications. Build and publish data marts, reports, and visualizations. Facilitate development of data definitions and metadata documentation. Coordinate distributed application development efforts to support specialized needs across campus. Maintain existing reports and visualizations. Organize reports and train users on reporting tools.Preferred QualificationsBachelor's Degree in CIS/Math/Technical area and 5 years of experience.Proficient in MS Office 365 – Outlook and Excel and demonstrated AI experience.Effective oral, written, and interpersonal communication skills.Demonstrated ability to work in a team environment and lead small projects including change management.Proficient with SQL including query building and tuning. Experience with enterprise reporting systems.Experience with MS SQL Server, MS SSRS, MS SSIS, MS SSMS, PowerBI, and PowerShell a plus.CompetenciesFlexible self-starter who is able to understand priorities and manage work in alignment with those priorities. Demonstrated ability to be organized, make deadlines, and stay within scope and budget on projects. Regularly uses analytical and critical thinking skills to avoid problems, resolve issues, leverage system functionality, and improve processes. Proactive mindset that plans ahead, avoids problems, and has a focus on risk mitigation. Able to build relationships through trust, communication and credibility. Strong customer service focus. Able to work in or lead a team. Normally requires minimal direction, but able to take direction and criticism. Commitment to professional and personal development. Expert with standard reporting tools.Your application should include a brief narrative of a situation where you used raw data to create a dataset in MS SQL Server and then used PowerBI to make that data actionable. The example should include the steps you took to complete the project.Compensation will be commensurate to candidate experience.Equal Employment OpportunityThe University of Louisville is an Equal Employment Opportunity employer. The University strives to provide equal employment opportunity on the basis of merit and without unlawful discrimination on the basis of race, sex, age, color, national origin, ethnicity, creed, religion, disability, genetic information, sexual orientation, gender, gender identity or expression, veteran status, marital status, or pregnancy. In accordance with the Rehabilitation Act of 1973 and the Vietnam Era Veteran Readjustment Act of 1974, the University prohibits job discrimination of individuals with disabilities, Vietnam era veterans, qualified special disabled veterans, recently separated veterans, and other protected veterans. The University acknowledges its obligations to ensure affirmative steps are taken to ensure equal employment opportunities for all employees and applicants for employment. It is the policy of the University that no employee or applicant for employment be subject to unlawful discrimination in terms of recruitment, hiring, promotion, contract, contract renewal, tenure, compensation, benefits, and/or working conditions. No employee or applicant for employment is required to endorse or condemn a specific ideology, political viewpoint, or social viewpoint to be eligible for hiring, contract renewal, tenure, or promotion.Consistent with applicable law, demographic information is collected for aggregate reporting requirements. Demographic information provided through this application is not available to hiring managers/committees and is not considered in hiring or employment decisions.Assistance and AccommodationsComputers are available for application submission at the Human Resources Department located at 2315 South First Street Walk, Room 02C - Louisville, Kentucky 40292.If you require assistance or accommodation with our online application process, please contact us by email at [e-mail] or by phone [phone].