Senior Business Intelligence Analyst

Quantix SCS, Inc.; Houston (TX); Hybrid; USD 90,000 - 140,000; Full time

Job summary

Quantix Supply Chain Solutions is seeking a Sr. Business Intelligence Analyst to join the BI & Data team.

The ideal candidate will translate business requirements into dashboards, reports, and data models that drive decision-making across Quantix's supply chain divisions. Primary focus is Power BI development and reporting, including building robust data models and translating complex data into clear insights for division leadership and business users.

Qualifications

• 5+ years of experience in business intelligence, data analytics, or a related field.
• 5+ years of hands-on experience with Microsoft Power BI — data modeling, DAX, M, report and dashboard development, row-level security
• 5+ years of experience writing SQL in a complex relational database environment — joins, aggregations, window functions, subqueries, query optimization

Responsibilities

• Design, develop, and maintain Power BI dashboards and reports for division leadership and business users.
• Lead dashboard builds from requirements gathering through UAT and go-live.
• Build and maintain data models, calculated measures, and DAX/M logic within Power BI.
• Configure and maintain Power BI security roles for data access; train users on BI usage.
• Coordinate with EDW Architect on data integration and pipeline design.

Skills

BI Experience

Data storytelling

Requirements gathering

Stakeholder communication

Analytical thinking

Education

Bachelor's degree

Tools

Power BI

SQL

Excel

Azure Synapse

Azure Data Factory

Job description

Description

Position Overview

Quantix Supply Chain Solutions is seeking a Sr. Business Intelligence Analyst to join the BI & Data team. The ideal candidate will have extensive hands-on experience with Microsoft Power BI and SQL, with a proven ability to convert business requirements into compelling dashboards, reports, and data models that drive decision‑making across Quantix's supply chain divisions.

This role is primarily focused on Power BI development and reporting — designing and delivering dashboards, building robust data models, and translating complex data into clear insights for division leadership and business users. The Sr. Business Intelligence Analyst will also support data integration and EDW work within their assigned division scope in coordination with the EDW Architect.

This position reports to the Manager, Data Analytics and works closely with Finance and division leadership across all areas of the organization.

Key Responsibilities

Dashboard & Report Development

• Design, develop, and maintain Power BI dashboards and reports that translate complex data into clear operational and strategic insights for division leadership and business users
• Lead dashboard builds for assigned division(s) from requirements gathering through UAT and go‑live
• Build and maintain data models, calculated measures, and DAX/M logic within Power BI
• Optimize Power BI reports and data models for performance and scalability
• Configure and maintain Power BI security roles (row‑level security) to ensure appropriate data access
• Train and support business users on Power BI usage, report navigation, and best practices

Data Analysis & SQL

• Provide ad hoc data mining and analysis in response to business questions from division leadership
• Perform data validation to ensure accuracy and integrity of reports and dashboards
• Partner with Finance and division leadership to understand data requirements and translate them into technical solutions

Data Integration & EDW Support

• Build tables in the development environment to test and validate data in coordination with the EDW Architect (the EDW Architect) before production promotion
• Partner with Finance and division stakeholders to define and document data definitions and business rules for assigned division scope
• Own data definition documentation — ensure business rules, field definitions, and reporting logic are clearly captured and maintained
• Participate in data quality validation processes and flag data integrity issues for resolution
• Coordinate with the EDW Architect on pipeline design and technical documentation

AI & Advanced Analytics

• Support AI‑assisted analytics initiatives built on the Quantix EDW — including structured data prep and integration of AI outputs into dashboards
• Identify opportunities to apply advanced analytics to improve division reporting and operational insight
• Stay current with emerging tools and techniques in Power BI, BI development, and AI‑assisted analytics

Collaboration & Communication

• Work directly with stakeholders to gather requirements and deliver customized analytics solutions
• Clearly communicate findings, data limitations, and recommendations to both technical and non‑technical audiences
• Serve as a resource and technical guide to junior analysts on the BI & Data team
• Other duties as assigned

Requirements

Qualifications

Required

• Bachelor's degree in Information Systems, Computer Science, Business, Data Analytics, Finance, or a related field — or demonstrated equivalent experience
• 5+ years of experience in business intelligence, data analytics, or a related field
• 5+ years of hands‑on experience with Microsoft Power BI — data modeling, DAX, M, report and dashboard development, row‑level security
• 5+ years of experience writing SQL in a complex relational database environment — joins, aggregations, window functions, subqueries, query optimization
• Strong proficiency with Microsoft Excel
• Demonstrated ability to translate complex datasets into actionable insights for non‑technical stakeholders
• Strong attention to detail and proven ability to manage multiple priorities and deliver on deadlines
• Highly motivated, proactive self‑starter; works well independently and as part of a team

Preferred

• Experience with Azure data services — Azure Synapse Analytics, Azure Data Factory, Azure SQL, or Microsoft Fabric
• Understanding of data warehousing concepts (star schema, dimensional modeling)
• Experience in transportation, logistics, or supply chain industries
• Knowledge of other BI tools (e.g., Tableau, Qlik)
• Relevant Power BI certifications
• MBA or advanced degree

Work Environment

• Full‑time remote position
• Collaborative team environment within the BI & Data team, reporting to the Manager, Data Analytics with close partnership with Finance and division leadership
• Minimal travel required (0–15%)

Disclaimer

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.