Business Intelligence Analyst II

Universal Technical Institute, Inc. is seeking a Business Intelligence Analyst II who will be responsible for designing, developing, and maintaining analytical dashboards and data visualizations. This role involves collaborating with business stakeholders to transform raw data into actionable insights that drive decision-making.

Responsibilities:

• Serves as primary liaison with business leaders to help define analytical solutions to business issues and manage the resulting projects from inception to delivery
• Develops complex data solutions via SQL and other data extraction techniques to prepare data for analysis, ensuring alignment between the data and the underlying business processes that the data reflects
• Designs, develops, monitors, and/or maintains analysis and reporting solutions as well as the communication of results to business stakeholders
• Build, enhance and maintain interactive dashboards and reporting solutions, using intuitive visual designs that effectively communicate insights and support data-driven decision-making; apply best practices in visual storytelling, user experience and information design
• Apply analytical techniques appropriate to the problem – trend analysis, segmentation, cohort analysis, correlation analysis, KPI development, etc. and provide stakeholders with tools/dashboards that support ongoing self-service insight
• Develop strong understanding of the business processes, systems and data that power the organization’s KPIs
• Partner with Business Analysts and business leaders to clarify requirements, validate assumptions, and ensure alignment between reporting and real-world processes
• Document logic, definitions and data flows to support transparency and repeatability
• Other duties as assigned

Requirements:

• Bachelor's degree in Information Technology, Computer Science, Math, Engineering, or related field or equivalent industry certification and experience
• Minimum seven (7) years' experience in data gathering, data organization, and data analysis utilizing Microsoft SQL
• Strong knowledge and experience with relational database platforms, including SQL Server
• Advanced SQL Querying skills
• SSIS, SSAS, SSRS, and Power BI
• Experience should include five (5) years of Business Intelligence, Data Warehouse, and ETL or related experience
• Experience with QlikView dashboards