Business Intelligence Analyst II

Role Description

The Business Intelligence Analyst II is responsible for designing, developing, and maintaining high quality analytical dashboards and data visualizations using Power BI and/or Qlik. This role combines strong technical capability in SQL and data modeling with deep analytical thinking and business acumen. The BI Analyst works closely with business stakeholders to understand processes, data flows, and core operational questions, transforming raw data into meaningful insights that drive decision-making.

• 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.
• Builds, enhances, and maintains interactive dashboards and reporting solutions, using intuitive visual designs that effectively communicate insights and support data-driven decision-making.
• Applies analytical techniques appropriate to the problem – trend analysis, segmentation, cohort analysis, correlation analysis, KPI development, etc.
• Develops strong understanding of the business processes, systems, and data that power the organization’s KPIs.
• Partners with Business Analysts and business leaders to clarify requirements, validate assumptions, and ensure alignment between reporting and real-world processes.
• Documents logic, definitions, and data flows to support transparency and repeatability.
• Other duties as assigned.

Qualifications

• Bachelor’s degree in Information Technology, Computer Science, Math, Engineering, or related field or equivalent industry certification and experience (required).
• Minimum seven (7) years’ experience in data gathering, data organization, and data analysis utilizing Microsoft SQL (required).
• Experience should include five (5) years of Business Intelligence, Data Warehouse, and ETL or related experience (preferred).
• Experience with QlikView dashboards (preferred).
• Strong knowledge and experience with relational database platforms, including SQL Server.
• Working knowledge of applicable regulatory requirements (e.g., SOX, FERPA, GLBA, DoE Blue Book, Accreditation Standards, etc.) as they relate to data integrity and privacy.
• Advanced SQL Querying skills (required).

Requirements

• Apply knowledge and skills to complete tasks with minimal supervision.
• Identify straightforward problems and recommend potential solutions.
• Communicate clearly and effectively with peers and stakeholders.
• Demonstrate active listening and empathy in interactions.
• Participate in presentations or facilitate small group discussions.
• Manage multiple tasks in a dynamic environment.
• Use productivity software and collaboration tools with confidence.
• Show initiative and accountability for assigned outcomes.
• Perform routine tasks and seek guidance for new situations.
• Make timely decisions that keep the organization moving forward.
• Apply effective and efficient processes with a focus on continuous improvement.
• Build open and comfortable relationships with diverse groups.
• Learn actively from both successes and failures while solving new problems.

Benefits

• Tuition Waiver: Enjoy a tuition waiver after 6 months of employment for you AND your immediate family offered at UTI and Concorde campuses.
• Paid Time Off: Competitive paid time off programs for employees (Vacation, Sick, Flexible).
• Retirement Matching: 50% match on the first 6% of your contributions after 90 days.
• Paid Parental Leave: 4 weeks of paid leave for both birthing and non-birthing parents to bond with a new baby.
• Competitive Insurance: Health, vision, and dental coverage for you and your dependents.
• Pet Insurance: Competitive coverage for your furry family members through ASPCA.
• Health Plan Enrollment: Eligibility starts first of the month following completing one full month of employment.

Work Environment

Work is performed indoors in a climate-controlled environment when on site at assigned company location. Employees must be able to safely ambulate when on company premises. This position is eligible for a remote work location to meet business needs. Employees must meet minimum technical standards for eligibility and participation. Overnight and/or Local travel required (up to 5%).