Senior Power BI Architect: Dashboards, SQL & Insights

Hirschbach; United States; Hybrid; USD 120,000 - 150,000; Full time

Job summary

Hirschbach Motor Lines seeks a Business Intelligence Architect to lead the Power BI reporting backbone, transforming data from SQL Server and other sources into actionable dashboards used by senior leaders.

The role demands deep Power BI and SQL expertise, strong analytical judgment, and the ability to translate complex data into clear business terms while partnering across IT, data engineering, and operations. Hybrid work options available.

Qualifications

• Bachelor’s degree in Computer Science, MIS, Engineering, or related field.
• 4+ years of BI analysis or development
• 3+ years building and publishing Power BI dashboards and reports
• Advanced SQL with joins, sub-queries, and aggregations against large relational databases
• Experience with SSRS and Azure DevOps
• Experience with other data visualization tools (Tableau or Excel) preferred

Responsibilities

• Design, build, publish, and maintain Power BI dashboards, reports, and visualizations from start to finish
• Write, test, and maintain SQL queries pulling data from SQL Server and other sources
• Collaborate with IT, data engineers, and business partners to deliver actionable insights
• Validate report results against source data to ensure accuracy
• Lead BI projects from intake to delivery and mentor others
• Manage Power BI workspaces, refreshes, gateways, and access

Skills

Power BI

SQL

DAX

Power Query

SSRS

Azure DevOps

Data Visualization

Communication

Project Management

Education

Bachelor’s degree in Computer Science, MIS, Engineering

Tools

Tableau

Excel

Job description

Hirschbach Motor Lines seeks a Business Intelligence Architect to lead the Power BI reporting backbone, transforming data from SQL Server and other sources into actionable dashboards used by senior leaders.

The role demands deep Power BI and SQL expertise, strong analytical judgment, and the ability to translate complex data into clear business terms while partnering across IT, data engineering, and operations. Hybrid work options available.