Business Intelligence Architect

Hirschbach•,

12h

About The Position

The Business Intelligence Architect is the primary builder of the organization’s Power BI reporting. IT and data engineering maintain the underlying data tables; this role writes SQL queries to retrieve information from those tables, brings it into Power BI, and develops dashboards and reports used by leaders to make decisions. Working with minimal guidance, the role owns BI work from the initial business conversation through the completed, published product. Success requires deep technical skills in Power BI and SQL, sound analytical judgment, and a working understanding of business operations. The position serves as a go-to BI resource and explains complex data in accessible terms to non-technical audiences. The role designs, builds, publishes, and maintains Power BI dashboards and reports; connects reports to existing data; and configures relationships, calculated columns, calculations, and KPI formulas. It uses Power Query to shape and clean data, manages workspaces, refreshes, gateways, and access, and tunes reports for speed and accuracy as data volume grows. It also builds and supports paginated reports in SSRS when formatted, printable reports are required. The position partners with business stakeholders, IT, and data engineering to identify reporting needs, assess feasibility, agree on solutions and timelines, request new tables or fields, and resolve data-quality issues. It validates report results against source data, monitors KPIs and trends, develops recommendations, presents findings and project updates to senior leadership, and leads multiple BI projects from intake through delivery. Additional responsibilities include tracking work and releases in Azure DevOps, training report users and colleagues, mentoring less experienced colleagues, and controlling project costs related to licensing and development time. The work environment is office-based or hybrid, depending on location and team structure, with frequent cross-departmental communication and extended computer work. The schedule is Monday through Friday during standard business hours, with flexibility required for deadlines, releases, or data issues outside normal hours.

Requirements

A bachelor’s degree in Computer Science, Management Information Systems, Engineering, or a related field, or a suitable combination of education, experience, training, and/or military equivalent.
At least 4 years of experience in Business Intelligence analysis or development.
At least 3 years of hands-on experience building and publishing Power BI dashboards and reports.
Advanced SQL query skills, including joins, subqueries, and aggregations against large relational databases.
Experience with DAX, Power Query, SQL Server Reporting Services (SSRS), and Azure DevOps.
Strong analytical judgment, communication, and project-management skills, including the ability to explain complex data to non-technical audiences.
Ability to work with minimal guidance, manage multiple projects, and meet deadlines.

Nice To Haves

Experience with other data-visualization tools, such as Tableau or Excel.
Microsoft Power BI Data Analyst certification (PL-300).
Experience in transportation, logistics, or supply chain.

Responsibilities

Design, build, publish, and maintain Power BI dashboards, reports, and visualizations from start to finish.
Connect Power BI to existing data tables and configure relationships, calculated columns, report calculations, and KPI formulas.
Use Power Query to shape and clean data for reporting.
Manage Power BI workspaces, scheduled refreshes, gateways, and user access.
Tune reports to load quickly and remain accurate as data volume grows.
Build and support paginated reports in SQL Server Reporting Services (SSRS) when formatted, printable reports are needed.
Write, test, and maintain SQL queries that retrieve data from existing SQL Server tables and other source systems.
Identify where data resides across company systems and which tables are appropriate for business questions.
Join, filter, and summarize data from multiple tables accurately.
Validate report results against source data before release.
Translate complex data into clear business terms for non-technical stakeholders and act as a bridge between technical teams and business partners.
Meet with business partners to identify and document reporting and analytics needs, assess feasibility, and agree on solutions and timelines.
Partner with IT and data engineering on requests for new tables or fields and help identify and resolve data-quality issues.
Build working knowledge of business operations across several parts of the organization so BI work supports company goals.
Monitor KPIs, identify trends, and point out opportunities for improvement.
Solve complex reporting and data problems and develop recommendations and solutions as business needs change.
Present findings, project progress, and challenges to senior leadership, including difficult or sensitive information.
Lead BI projects from intake through delivery with minimal guidance, manage multiple projects at once, and meet deadlines.
Track work, changes, and releases in Azure DevOps.
Develop and lead training on Power BI and other data-analysis tools for report users and colleagues.
Serve as a resource and mentor for colleagues with less BI experience.
Control costs related to projects, including tool licensing and report-development time.