Senior Business Intelligence Analyst

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

📋 Description

• Create, develop, and sustain Power BI dashboards and reports.

• Oversee the construction of dashboards for designated divisions, from requirement gathering through user acceptance testing (UAT) to launch.

• Develop and maintain Power BI data structures, calculated measures, and DAX/M logic.

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

• Set up and manage Power BI row-level security roles.

• Educate and assist business users in utilizing Power BI, navigating reports, and adhering to best practices.

• Conduct ad hoc data mining and analysis for divisional leadership.

• Ensure the accuracy and integrity of report and dashboard data.

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

• Create development-environment tables to test and verify data with the EDW Architect prior to production deployment.

• Define and document data definitions and business rules for assigned divisions.

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

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

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

• Assist with AI-driven analytics initiatives on the Quantix EDW, including data preparation and the integration of AI outputs into dashboards.

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

• Collect stakeholder requirements and provide tailored analytics solutions.

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

• Act as a technical mentor and resource for junior BI analysts.

• Perform additional duties as assigned.

⛳️ Requirements

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

• More than 5 years of experience in business intelligence, data analytics, or a similar field.

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

• More than 5 years of experience writing SQL in a complex relational database environment, including joins, aggregations, window functions, subqueries, and query optimization.

• Strong proficiency in Microsoft Excel.

• Ability to transform complex datasets into actionable insights for non-technical stakeholders.

• Excellent attention to detail and capability to juggle multiple priorities while meeting deadlines.

• Highly motivated, proactive self-starter; capable of working independently as well as part of a team.

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

• Familiarity with data warehousing concepts, including star schema and dimensional modeling.

• Experience in the 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%).