Power BI Analytics Engineer: Dashboards & Data Modeling

Halff Associates, Inc.; Richardson (TX); On-site; USD 70,000 - 105,000; Full time

Benefits offered by this job

Health insurance

401(k) plan

Paid time off

Holiday pay

Employee Stock Ownership Plan (ESOP)

Health Savings Account (HSA)

Job summary

Halff Associates, Inc. is seeking a Power BI Developer (Business Analyst/Power BI) to design, develop, and validate polished dashboards and semantic models.

The role requires the ability to translate business needs into technical reporting solutions and to validate data across source systems. The ideal candidate will have experience with Power BI, SQL Server, and Microsoft Fabric, plus strong communication and project coordination skills, in a cross-functional Business Systems team environment.

Qualifications

• Bachelor's degree in Business Analysis, Finance, Accounting, Computer Science, Information Systems, Data Analytics, or a related area; equivalent experience may be considered in lieu of a degree.
• Intermediate Power BI experience, including DAX, data modeling, semantic models, report design, performance tuning, and row/column-level security
• Strong troubleshooting / critical thinking skills
• Strong curiosity, drive, persistence, and ability to quickly learn new business systems, tools, terminology, and processes.
• Excellent verbal and written communication skills.
• Demonstrated ability to research unfamiliar business data, understand source-system context, and turn complex operational data into trusted reporting structures.
• Intermediate SQL Server experience, including writing, troubleshooting, and optimizing complex T-SQL queries, views, and stored procedures.
• Strong understanding of data modeling concepts, including fact/dimension design, grain, star & snowflake schema design
• Experience validating data and dashboards against other reporting sources to ensure accuracy, consistency, and business confidence.
• Ability to manage small to medium-sized projects of moderate complexity.

Responsibilities

• Assist in the design and development of polished Power BI dashboards, including report layout, usability reviews, DAX measures, semantic models
• Validate dashboards and datasets against source systems, legacy reports, accounting outputs, and other trusted reporting sources
• Trace data from source systems through SQL, Fabric, semantic models, and Power BI reports to validate accuracy and explain results
• Research and understand 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 support scalable, governed analytics
• Collaborate with internal clients to translate business needs into technical requirements, identify appropriate data sources, and deliver vetted dashboards and datasets
• Document dataset definitions, business rules, data lineage, assumptions, and known limitations
• Support front-office, production/operations, and management reporting needs as part of a cross-trained Business Systems team

Skills

Power BI

SQL Server

Data modeling

DAX measures

Semantic models

Data validation

Communication

Project management

Education

Bachelor's degree

Tools

Microsoft Fabric

Deltek Vantagepoint

Job description

Halff Associates, Inc. is seeking a Power BI Developer (Business Analyst/Power BI) to design, develop, and validate polished dashboards and semantic models.

The role requires the ability to translate business needs into technical reporting solutions and to validate data across source systems. The ideal candidate will have experience with Power BI, SQL Server, and Microsoft Fabric, plus strong communication and project coordination skills, in a cross-functional Business Systems team environment.