Senior Business Intelligence Analyst

This is a fully remote position, open to applicants in Texas.

📋 Description

• Design, develop, and maintain Power BI dashboards and reports to provide operational and strategic insights.

• Lead the entire dashboard development process, from gathering requirements to user acceptance testing (UAT) and deployment.

• Create and manage Power BI data models, calculated measures, and DAX/M logic.

• Enhance Power BI reports and data models to ensure optimal performance and scalability.

• Set up and oversee row-level security in Power BI.

• Educate and assist business users in Power BI utilization, report navigation, and adherence to best practices.

• Conduct ad hoc data mining and analytical tasks for division leadership.

• Ensure the accuracy and integrity of data in reports and dashboards.

• Collaborate with Finance and division leadership to establish data requirements and technical solutions.

• Create development-environment tables to test and validate data in conjunction with the EDW Architect prior to production rollout.

• Define and document data definitions and business rules.

• Maintain comprehensive documentation of business rules, field definitions, and reporting logic.

• Engage in data-quality validation and identify data-integrity issues.

• Work with the EDW Architect on pipeline design and technical documentation.

• Contribute to AI-assisted analytics initiatives within the Quantix EDW, including data preparation and integrating AI outputs into dashboards.

• Identify opportunities for advanced analytics to enhance reporting and operational insights.

• Collect stakeholder requirements and deliver tailored analytics solutions.

• Present findings, data limitations, and recommendations to both technical and non-technical audiences.

• Act as a technical resource and mentor to junior analysts.

• Execute other responsibilities as assigned.

⛳️ Requirements

• Bachelor's degree in Information Systems, Computer Science, Business, Data Analytics, Finance, or a related field — or equivalent practical experience.

• Over 5 years of experience in business intelligence, data analytics, or a related domain.

• More than 5 years of hands-on experience with Microsoft Power BI, encompassing data modeling, DAX, M, report and dashboard creation, and row-level security.

• At least 5 years of experience in writing SQL within a complex relational database setting, including joins, aggregations, window functions, subqueries, and query optimization.

• High proficiency in Microsoft Excel.

• Proven ability to convert complex datasets into actionable insights for non-technical stakeholders.

• Strong attention to detail with the capability to manage multiple priorities and meet deadlines.

• Highly motivated, proactive self-starter; effective both independently and in a team setting.

• Familiarity with Azure data services, such as Azure Synapse Analytics, Azure Data Factory, Azure SQL, or Microsoft Fabric.

• Understanding of data warehousing concepts, including star schema and dimensional modeling.

• Experience in transportation, logistics, or supply chain sectors.

• Knowledge of additional BI tools, such as Tableau or Qlik.

• Relevant Power BI certifications.

• MBA or advanced degree.

🏝️ Benefits

• Full-time remote position.

• Minimal travel required (0–15%).