Business Systems Data Analyst / Power BI & Fabric Developer III - Various Locations!

Halff has an immediate opening for a Business Systems Data Analyst / Power BI & Fabric Developer to join our Business Systems team. This role is for a well-rounded analytics professional who can design polished, executive-ready Power BI dashboards while also working directly in SQL Server, Microsoft Fabric, semantic models, and curated reporting datasets. The successful candidate must be able to learn complex ERP, accounting, project, HR, and operational data; research unfamiliar source structures; validate results against trusted systems and reports; and create reusable governed datasets that other report authors and business users can rely on. This is not a visualization-only role; the person in this position must be able to investigate source data, determine the correct grain and business meaning of fields, build or refine reporting datasets, and explain why the numbers are correct.We are looking for a well-rounded analytics professional who can create polished, professional Power BI dashboards while also working hands-on with SQL Server, Microsoft Fabric, semantic models, and curated reporting datasets. The ideal candidate is comfortable learning complex ERP, accounting, project, and operational data; researching unfamiliar data structures; validating results against trusted sources; and helping build reusable datasets rather than relying solely on others for data engineering support. Experience with Deltek Vantagepoint, the AEC / professional services industry, project accounting, or similar ERP-driven environments is highly valued.What You Will DoLearn about Halff and our 75th AnniversaryLead the design, development, and optimization of polished Power BI dashboards, including report layout, usability, DAX measures, relationships, semantic models, and performance tuningResearch and understand existing SQL Server VP/DataMart datasets, Microsoft Fabric data assets, semantic models, and reporting logicDesign and maintain curated reporting datasets and semantic models in Microsoft Fabric to support scalable, governed analyticsTransform complex ERP, accounting, project, HR, and operational data into clean, reliable, analytics-ready structuresHelp improve and expand ETL processes in SQL Server and Microsoft Fabric, working with internal team members and consultantsTrace data from source systems through SQL, Fabric, semantic models, and Power BI reports to validate accuracy and explain resultsValidate dashboards and datasets against source systems, legacy reports, accounting outputs, and other trusted reporting sourcesCollaborate with internal clients to translate business needs into technical requirements, identify appropriate data sources, and deliver vetted dashboards and datasetsDocument dataset definitions, business rules, data lineage, assumptions, and known limitationsSupport front-office, production/operations, and management reporting needs as part of a cross-trained Business Systems teamWhat You Will NeedBachelor’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 degreeA minimum of 4 years' experience as a Business Analyst, Data Analyst, or in a related analytical roleStrong Microsoft SQL Server experience, including writing, troubleshooting, and optimizing complex T-SQL queries, views, and stored proceduresAdvanced Power BI experience, including DAX, data modeling, semantic models, report design, performance tuning, and row/column-level securityStrong understanding of data modeling concepts, including fact/dimension design, grain, star schema design, snowflake schema design, relationships, and reporting performanceDemonstrated ability to research unfamiliar business data, understand source-system context, and turn complex operational data into trusted reporting structuresExperience validating data and dashboards against other reporting sources to ensure accuracy, consistency, and business confidenceAbility to work with business leaders, accounting/finance, operations, and technical team members to understand business needs and deliver practical data solutionsFamiliarity with Microsoft Fabric or similar modern data platform concepts, including curated datasets, pipelines, lakehouse/warehouse patterns, or medallion architectureAbility to manage small to medium-sized projects of moderate complexityStrong curiosity, persistence, and ability to quickly learn new business systems, tools, terminology, and processesStrong Microsoft Office skillsNice-to-Have SkillsExperience with Deltek Vantagepoint/Vision or other Deltek productsExperience with AEC, professional services, project accounting, or ERP-driven project financial dataExperience creating dashboards for project performance, billing, utilization, backlog, revenue, labor, financial, or operational reportingExperience with Microsoft Fabric medallion architecture, data pipelines, lakehouses, warehouses, notebooks, or Dataflows Gen2Experience developing reusable governed datasets for enterprise reportingExperience with UKG Pro or other HR management systemsExperience maintaining or developing business workflows using ERP-native workflow tools or external automation platformsUnderstanding of compliance, data governance, security, lineage, and documentation practices in reporting and system designCompany OverviewHalff is a full-service infrastructure consulting firm planned, designed, engineered, constructed — and purposed — for people. Since 1950, we’ve been creating smart solutions that improve lives and communities by turning ideas into reality.Halff was founded on a core tenet: Focus on people, treat them well, and success will follow. It’s no wonder, then, that our employees and the culture they create result in our firm consistently being named a Top Workplace in America.Our industry-leading professionals collaborate to meet tough challenges in creative ways. You can view Halff's full complement of services hereHalff has more than 30 offices in Texas, Oklahoma, Louisiana, Florida, Arkansas, Arizona and Georgia. For a full list of our locations, click hereWe Offer Excellent Benefits, Including But Not Limited ToMedical, dental, prescription and life insurance Long-term and short-term disability insurance Paid time off (PTO) and 8 company paid holidays (and Veteran's Day for our veterans) 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 Click here for a more comprehensive list of Halff's benefits Salary is competitive and commensurate with experience.All qualified applicants will receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity, religion, national origin, disability, veteran status, or other legally protected status.Halff is a drug-free workplace. This offer of employment is contingent upon the receipt of a clear drug screen and background check prior to your first day of employment. This position may be subject to random drug testing pursuant to federal regulations.#ExpProf