Dataflows Gen2 Jobs

1 job found

2mo ago

Business Systems Data Analyst / Power BI & Fabric Developer III

Halff Richardson, TX

Richardson, TX

2mo ago Closed

Full time Analyst Analytics Business Analytics

This position is no longer accepting applications (closed Jun 16, 2026).

Job Description

Onsite opportunity in Richardson, TX, focusing on Power BI and Microsoft Fabric development to transform ERP and operations data into analytics-ready structures at Halff.

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.

View full job page →

Get Dataflows Gen2 Jobs alerts

New Dataflows Gen2 Jobs, daily.