Business Intelligence Analyst II

Universal Technical Institute, Inc. is seeking a Business Intelligence Analyst II who will be responsible for designing and maintaining analytical dashboards and data visualizations. This role requires a combination of technical skills in SQL and data modeling along with analytical thinking to transform raw data into actionable insights.

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