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.

Pay Range: $118,000 - $124,000

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.

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).

Skills

• 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.

Abilities

• Able and willing to communicate, think, learn, and reason.
• Use computers and computer systems (including hardware and software) to process transactions, store documents, enter data, or perform assigned tasks.
• Safely ambulate and/or maneuver when on-site at Company locations.
• Demonstrate and utilize active listening, inductive reasoning, information ordering and category flexibility.
• Ability to use good judgment, problem-solving and decision-making skills.
• Ability to maintain confidentiality and manage sensitive information with discretion.
• Ability to work in a fast-paced environment where deadlines are essential and multiple projects are worked simultaneously.
• Ability to gain, understand and apply information and data as it relates essential functions of the position.
• Ability to foster long-term relationships with stakeholders.
• Ability to apply disparate elements of information to solve complex problems.

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%).

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.