Business Systems Data Analyst / Power BI & Fabric Developer III

Responsibilities

• Lead the creation, refinement, and optimization of polished Power BI dashboards, covering layout, usability, DAX calculations, data relationships, semantic models, and performance tuning
• Study existing SQL Server VP/DataMart datasets, Microsoft Fabric data assets, semantic models, and reporting logic
• Design and maintain curated reporting datasets and semantic models in Microsoft Fabric to enable scalable, governed analytics
• Transform complex ERP, accounting, project, HR, and operational data into clean, reliable analytics-ready structures
• Collaborate on enhancing ETL processes in SQL Server and Microsoft Fabric with internal teams and external consultants
• Trace data lineage from source systems through SQL, Fabric, semantic models, and Power BI reports to validate accuracy and explain results
• Validate dashboards and datasets against source systems, legacy reports, accounting outputs, and other trusted reporting sources
• Partner with internal clients to translate business needs into technical requirements, select appropriate data sources, and deliver vetted dashboards and datasets
• Document dataset definitions, business rules, data lineage, assumptions, and known limitations
• Support front-office, production and operations, and management reporting as part of a cross-trained Business Systems team

Requirements

• Bachelor’s degree in Business Analysis, Finance, Accounting, Computer Science, Information Systems, Data Analytics, or a related area; equivalent experience may be considered
• At least 4 years of experience as a Business Analyst, Data Analyst, or in a related analytical role
• Strong Microsoft SQL Server experience, including writing, troubleshooting, and optimizing complex T-SQL queries, views, and stored procedures
• Advanced Power BI experience, including DAX, data modeling, semantic models, report design, performance tuning, and row/column-level security
• Solid understanding of data modeling concepts, including fact/dimension design, grain, star schema, snowflake schema, relationships, and reporting performance
• Proven ability to research unfamiliar business data, understand source-system context, and translate complex operational data into trusted reporting structures
• Experience validating data and dashboards against other reporting sources to ensure accuracy and consistency
• Ability to collaborate with business leaders, accounting/finance, operations, and technical teams to deliver practical data solutions
• Familiarity with Microsoft Fabric or similar modern data platform concepts, including curated datasets, pipelines, lakehouse/warehouse patterns, or medallion architecture
• Capability to manage small to medium projects of moderate complexity
• Strong curiosity, persistence, and the ability to quickly learn new business systems, tools, terminology, and processes
• Strong Microsoft Office skills

Technologies

• Power BI
• DAX
• SQL Server
• T-SQL
• Microsoft Fabric
• Dataflows Gen2
• Deltek Vantagepoint
• Deltek Vision
• UKG Pro
• Microsoft Office

Benefits

• Medical, dental, prescription drug, and life insurance
• Short-term and long-term disability insurance
• PTO and eight company holidays, with Veterans Day observed
• Traditional and Roth 401(k) plans
• Employee Stock Ownership Plan (ESOP)
• Health Savings Account (HSA)
• 529 College Savings Plan
• Flexible Spending Accounts (FSA)
• Employee Assistance Plan
• Comprehensive benefits overview available on Halff’s benefits page

Nice-to-have skills

• Experience with Deltek Vantagepoint or Vision or other Deltek products
• Background in AEC, professional services, project accounting, or ERP-driven project financial data
• Experience creating dashboards for project performance, billing, utilization, backlog, revenue, labor, financial, or operational reporting
• Experience with Microsoft Fabric medallion architecture, data pipelines, lakehouses, warehouses, notebooks, or Dataflows Gen2
• Experience developing reusable governed datasets for enterprise reporting
• Experience with UKG Pro or other HR management systems
• Experience maintaining or developing business workflows using ERP-native tools or external automation platforms
• Understanding of compliance, data governance, security, lineage, and documentation practices in reporting and system design

Company overview

Halff is a full service infrastructure consulting firm delivering planning, design, engineering, construction, and people focused solutions since 1950. The firm emphasizes people, a strong culture, and has been named a Top Workplace in America. Halff operates from more than 30 offices across Texas, Oklahoma, Louisiana, Florida, Arkansas, Arizona, and Georgia.