Data Architect

Balfour Beatty US; Dallas (TX); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Medical, Dental, Vision and Life Insurance

Health Savings Account

401(k) with company match

Flexible Spending Accounts

Vacation Time

Sick Time

Holidays

Tuition Assistance

Employee Referral Bonus

Job summary

A major construction firm in Dallas, TX is seeking a Data Architect to oversee BI platforms and drive migrations to Azure Fabric. Candidates should have a Bachelor’s degree and 5+ years in BI development, with strong AWS and SQL Server experience. This hybrid role offers a competitive benefits package.

Qualifications

• 5+ years of hands-on BI development and architecture across both AWS and SQL Server stacks.
• Deep hands-on experience with Power BI and DAX for advanced calculations, custom visuals and performance tuning.
• Proven track record migrating SQL Server BI solutions to Azure/Fabric.

Responsibilities

• Manage and enhance two BI environments: AWS and SQL Server stacks.
• Lead the end-to-end migration of SQL Server BI solution to Azure Data Factory and Microsoft Fabric.
• Define project scopes, schedules, and priorities for multiple concurrent BI initiatives.

Skills

Technical Leadership

Analytical Thinking

Communication

Delivery Management

Collaboration

Adaptability

Education

Bachelor’s degree in Computer Science, Information Systems or related field

Tools

Power BI

AWS (S3, Redshift, Lambda)

SQL Server (SSAS, SSIS)

Azure Data Factory

Microsoft Fabric

Job description

As an industry leader Balfour Beattyoffers employees a comprehensive benefits package with competitivesalaries and more including:

• Medical, Dental, Vision and Life Insurance
• Health Savings Account
• 401(k) with company match
• Flexible Spending Accounts (Dependent & Medical Reimbursement)
• Vacation Time
• Sick Time
• Holidays
• Tuition Assistance
• Employee Referral Bonus

Summary

Balfour Beatty is seeking a Data Architect to work in Dallas, TX. This is a hybrid position (three days in the office, two from home).

The Data Architect will own the vision, architecture and delivery of our BI platforms across AWS, SQL Server, Azure and Microsoft Fabric. You’ll collaborate closely with business stakeholders, guide a small team of BI developers, and drive our migration from SQL Server to the Azure/Fabric data stack.

Job Responsibilities

Platform Ownership

Manage and enhance two BI environments:

• AWS (S3, Redshift, Lambda ETL, Power BI)
• SQL Server stack on EC2 (SSAS, SSIS, BIML, Power BI)

Lead the end-to-end migration of our SQL Server BI solution to Azure Data Factory, Synapse Analytics, OneLake and other Microsoft Fabric services

• Design, build and optimize data pipelines, semantic models and reports
• Implement best practices for data modeling (Star/Snowflake schemas), performance tuning and security

Delivery Management

• Define project scopes, schedules and priorities for multiple concurrent BI initiatives
• Track milestones, manage risks and report status to stakeholders

Stakeholder Engagement

• Partner with business customers to gather requirements, scope new initiatives and translate needs into technical designs
• Facilitate design reviews, demo sessions and end‑user training
• Mentor and coach BI developers/analysts; conduct code reviews and knowledge‑sharing sessions
• Establish and evangelize standards for data governance, testing and documentation

Requirements

• Bachelor’s degree in Computer Science, Information Systems or related field
• 5+ years of hands‑on BI development and architecture across both AWS and SQL Server stacks
• Deep hands‑on experience with Power BI and DAX for advanced calculations, custom visuals and performance tuning
• Strong expertise in:
  • AWS BI: S3, Redshift, Lambda
  • SQL Server BI: SSAS, SSIS (on EC2)
  • Azure & Microsoft Fabric: Data Factory on Fabric, Synapse Analytics, OneLake, Data Activator, Azure Analysis Services
• Exposure to BIML a plus
• Proven track record migrating SQL Server BI solutions to Azure/Fabric
• Experience with data modeling, ETL design patterns and semantic layer development
• Microsoft Certified: Azure Data Engineer Associate and/or Microsoft Fabric Data Engineer (preferred)

Job Skills

• Technical Leadership: Ability to set architecture direction, enforce standards and drive continuous improvement
• Analytical Thinking: Strong problem-solving skills, attention to detail and data‑driven mindset
• Communication: Excellent verbal and written skills for working with both technical teams and non‑technical stakeholders
• Delivery Management: Skilled at scheduling, prioritizing tasks and managing stakeholder expectations
• Collaboration: Comfortable facilitating workshops, requirement sessions and cross‑functional teaming
• Adaptability: Eager to learn new technologies and adjust to evolving business needs

About us

Balfour Beatty US is an industry‑leading provider of general contracting, at‑risk construction management and design‑build services for public and private sector clients across the nation. Performing heavy civil and vertical construction, our teams build the unique structures and infrastructure that play an important role in how people live, work, learn and play in our communities. Our teammates have an instinctive passion for innovating that is fueled by a relentless curiosity, a drive to employ lean practices and processes and the determination to find a better way.Through Zero Harm®, we are challenging the construction industry’s assumptions about safety. We believe that no level of harm should come to anyone as a result of our business.

Consistently ranked among the nation’s largest building contractors by Engineering News‑Record, our US business is a subsidiary of London‑based Balfour Beatty plc (LSE: BBY).

Balfour Beatty is an equal opportunity employer that recognizes the value of a diverse workforce. All qualified individuals will receive consideration for employment without regard to race, color, age, sex, sexual orientation, gender identity, religion, national origin, disability, veteran status, genetic information, or any other criteria protected by federal, state or local law.

Accessibility:If you need an accommodation as part of the employment process, please contact HumanResources at:

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

View your Equal Employment Opportunity rights under the law: