Data Architect at Balfour Beatty Us in Dallas, TX | Kablio

Role

Description

data pipelines

semantic modeling

report development

design reviews

requirement gathering

data governance

Design, build and optimize data pipelines, semantic models and reports
Facilitate design reviews, demo sessions and end-user training
Mentor and coach BI developers/analysts; conduct code reviews and knowledge-sharing sessions
Partner with business customers to gather requirements, scope new initiatives and translate needs into technical designs
Define project scopes, schedules and priorities for multiple concurrent BI initiatives
Track milestones, manage risks and report status to stakeholders
Implement best practices for data modeling (Star/Snowflake schemas), performance tuning and security
Establish and evangelize standards for data governance, testing and documentation

Requirements

sql server

azure

power bi

aws

microsoft certified

5+ years

SQL Server BI: SSAS, SSIS (on EC2)
Microsoft Certified: Azure Data Engineer Associate and/or Microsoft Fabric Data Engineer (preferred)
Azure & Microsoft Fabric: Data Factory on Fabric, Synapse Analytics, OneLake, Data Activator, Azure Analysis Services
Proven track record migrating SQL Server BI solutions to Azure/Fabric
Experience with data modeling, ETL design patterns and semantic layer development
Exposure to BIML a plus
Adaptability: Eager to learn new technologies and adjust to evolving business needs
Analytical Thinking: Strong problem-solving skills, attention to detail and data-driven mindset
Collaboration: Comfortable facilitating workshops, requirement sessions and cross-functional teaming
AWS BI: S3, Redshift, Lambda
AWS (S3, Redshift, Lambda ETL, Power BI)
Bachelor’s degree in Computer Science, Information Systems or related field
Technical Leadership: Ability to set architecture direction, enforce standards and drive continuous improvement
Delivery Management: Skilled at scheduling, prioritizing tasks and managing stakeholder expectations
Deep hands-on experience with Power BI and DAX for advanced calculations, custom visuals and performance tuning
5+ years of hands-on BI development and architecture across both AWS and SQL Server stacks
Strong expertise in:
SQL Server stack on EC2 (SSAS, SSIS, BIML, Power BI)
Communication: Excellent verbal and written skills for working with both technical teams and non-technical stakeholders

Benefits

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

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

A leader in construction and infrastructure development, Balfour Beatty US operates across key sectors, including transport, utilities, and residential.
With a focus on complex and high-impact projects, the company has a proven track record in delivering large-scale infrastructure, including airports, highways, and hospitals.
Specializing in heavy civil engineering and civil construction, Balfour Beatty US has been part of major projects shaping urban landscapes.
The company’s portfolio spans public and private sector projects, reflecting its versatility and capability to meet diverse construction needs.
Known for its technical expertise, Balfour Beatty US often works with cutting-edge technology to ensure efficient delivery of projects.
The firm’s history stretches back decades, evolving from regional construction roots to a major player in the U.S. infrastructure scene.
Balfour Beatty US continues to build iconic structures, including bridges, roads, and utilities, contributing significantly to communities across the country.

Culture + Values

Relentless Allies who Deliver Excellence & Enhance Our Communities
Lean – we create value for our customers and drive continuous improvement
Expert – our highly skilled teammates and partners set us apart
Trusted – we deliver on our promises and we do the right thing
Safe – we make safety personal
Sustainable – we act responsibly to protect and enhance our planet and society
Talk Positively
Collaborate Relentlessly
Encourage Constantly
Make a Difference
Value Everyone

Environment + Sustainability

54.7% reduction

Carbon Emissions Decrease

Carbon emissions have been reduced by 54.7% since 2010.

Halve by 2030

Emissions Target

Aiming to reduce emissions by half by 2030 as part of the UN Race to Zero campaign.

70% waste diverted

Recycled Waste

70% of construction waste is recycled, reducing landfill impact.

Zero-net-energy building

Sustainable Design

Constructed California's first zero-net-energy building, achieving LEED Platinum certification.

Joined UN Race to Zero campaign, aiming to reach net zero by 2050
Lives by five sustainability focus areas: climate change; nature positive; resource efficiency; supply chain integrity; community engagement
One tree planted for every employee annually
Eliminate single-use plastics and reduce business travel
Electric vehicle fleet in operations
Plant & Fleet Services: semi-autonomous machine control cuts fuel use by 37%, project hours by 46%, and operating hours by 34%
Sterling Natural Resource Center recycles 8–10 mgd, replenishes local aquifer and diverts liquid food waste into biogas production

Inclusion & Diversity

2020

Together Allies Summit Annual Since

The company has hosted the Together Allies Summit annually since 2020 to advance a people-first culture that prioritizes inclusion and belonging.

Affinity groups include BRAVE (veterans), Building PRIDE (LGBTQ+), Connecting Women, NOBLE (Black leaders), REGAL (AAPI advocacy), Somos (culture unity)
Affinity groups open to all employees to foster connection, mentorship and inclusive culture
Committed to ensuring workplaces harness diverse talent and perspectives as a business imperative

Articles

Role

Description

data pipelines

semantic modeling

report development

design reviews

requirement gathering

data governance

Design, build and optimize data pipelines, semantic models and reports
Facilitate design reviews, demo sessions and end-user training
Mentor and coach BI developers/analysts; conduct code reviews and knowledge-sharing sessions
Partner with business customers to gather requirements, scope new initiatives and translate needs into technical designs
Define project scopes, schedules and priorities for multiple concurrent BI initiatives
Track milestones, manage risks and report status to stakeholders
Implement best practices for data modeling (Star/Snowflake schemas), performance tuning and security
Establish and evangelize standards for data governance, testing and documentation

Requirements

sql server

azure

power bi

aws

microsoft certified

5+ years

SQL Server BI: SSAS, SSIS (on EC2)
Microsoft Certified: Azure Data Engineer Associate and/or Microsoft Fabric Data Engineer (preferred)
Azure & Microsoft Fabric: Data Factory on Fabric, Synapse Analytics, OneLake, Data Activator, Azure Analysis Services
Proven track record migrating SQL Server BI solutions to Azure/Fabric
Experience with data modeling, ETL design patterns and semantic layer development
Exposure to BIML a plus
Adaptability: Eager to learn new technologies and adjust to evolving business needs
Analytical Thinking: Strong problem-solving skills, attention to detail and data-driven mindset
Collaboration: Comfortable facilitating workshops, requirement sessions and cross-functional teaming
AWS BI: S3, Redshift, Lambda
AWS (S3, Redshift, Lambda ETL, Power BI)
Bachelor’s degree in Computer Science, Information Systems or related field
Technical Leadership: Ability to set architecture direction, enforce standards and drive continuous improvement
Delivery Management: Skilled at scheduling, prioritizing tasks and managing stakeholder expectations
Deep hands-on experience with Power BI and DAX for advanced calculations, custom visuals and performance tuning
5+ years of hands-on BI development and architecture across both AWS and SQL Server stacks
Strong expertise in:
SQL Server stack on EC2 (SSAS, SSIS, BIML, Power BI)
Communication: Excellent verbal and written skills for working with both technical teams and non-technical stakeholders

Benefits

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

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

A leader in construction and infrastructure development, Balfour Beatty US operates across key sectors, including transport, utilities, and residential.
With a focus on complex and high-impact projects, the company has a proven track record in delivering large-scale infrastructure, including airports, highways, and hospitals.
Specializing in heavy civil engineering and civil construction, Balfour Beatty US has been part of major projects shaping urban landscapes.
The company’s portfolio spans public and private sector projects, reflecting its versatility and capability to meet diverse construction needs.
Known for its technical expertise, Balfour Beatty US often works with cutting-edge technology to ensure efficient delivery of projects.
The firm’s history stretches back decades, evolving from regional construction roots to a major player in the U.S. infrastructure scene.
Balfour Beatty US continues to build iconic structures, including bridges, roads, and utilities, contributing significantly to communities across the country.

Culture + Values

Relentless Allies who Deliver Excellence & Enhance Our Communities
Lean – we create value for our customers and drive continuous improvement
Expert – our highly skilled teammates and partners set us apart
Trusted – we deliver on our promises and we do the right thing
Safe – we make safety personal
Sustainable – we act responsibly to protect and enhance our planet and society
Talk Positively
Collaborate Relentlessly
Encourage Constantly
Make a Difference
Value Everyone

Environment + Sustainability

54.7% reduction

Carbon Emissions Decrease

Carbon emissions have been reduced by 54.7% since 2010.

Halve by 2030

Emissions Target

Aiming to reduce emissions by half by 2030 as part of the UN Race to Zero campaign.

70% waste diverted

Recycled Waste

70% of construction waste is recycled, reducing landfill impact.

Zero-net-energy building

Sustainable Design

Constructed California's first zero-net-energy building, achieving LEED Platinum certification.

Joined UN Race to Zero campaign, aiming to reach net zero by 2050
Lives by five sustainability focus areas: climate change; nature positive; resource efficiency; supply chain integrity; community engagement
One tree planted for every employee annually
Eliminate single-use plastics and reduce business travel
Electric vehicle fleet in operations
Plant & Fleet Services: semi-autonomous machine control cuts fuel use by 37%, project hours by 46%, and operating hours by 34%
Sterling Natural Resource Center recycles 8–10 mgd, replenishes local aquifer and diverts liquid food waste into biogas production

Inclusion & Diversity

2020

Together Allies Summit Annual Since

The company has hosted the Together Allies Summit annually since 2020 to advance a people-first culture that prioritizes inclusion and belonging.

Affinity groups include BRAVE (veterans), Building PRIDE (LGBTQ+), Connecting Women, NOBLE (Black leaders), REGAL (AAPI advocacy), Somos (culture unity)
Affinity groups open to all employees to foster connection, mentorship and inclusive culture
Committed to ensuring workplaces harness diverse talent and perspectives as a business imperative

Articles