Balfour Beatty
Data Architect
Become Part of Our Team
As an industry leader Balfour Beatty offers employees a comprehensive benefits package with competitive salaries 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
- Paid Volunteer time
- 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)
Cloud Migration
Lead the end-to-end migration of our SQL Server BI solution to Azure Data Factory, Synapse Analytics, OneLake and other Microsoft Fabric services
Development & Architecture
- 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
Team Leadership
- 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:
Phone: (214) 468-4700
Email:BBTalent@balfourbeattyus.com
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:
“Know Your Rights” PosterPay Transparency Notice
Freqently Asked Questions
In Rockwall, TX, certifications like Microsoft Azure Data Engineer Associate and Microsoft Fabric Data Engineer are highly regarded for Data Architects. These credentials validate expertise in cloud migrations and data platform management, aligning well with local employers' preference for skilled professionals who can navigate Azure and Microsoft Fabric ecosystems.
While Dallas boasts a larger tech industry footprint, Rockwall's proximity to Dallas increases demand for Data Architects, especially those adept in hybrid cloud environments. The competition is moderate, with opportunities growing as businesses expand their AWS and Azure-based BI platforms, making specialized skills in cloud migration particularly valuable.
Migrating SQL Server BI solutions to Azure within a hybrid environment involves balancing remote collaboration with on-site infrastructure needs. Challenges include ensuring data security across cloud and local systems, maintaining performance during the transition, and coordinating effectively with cross-functional teams, especially when managing parallel BI environments like AWS and Microsoft Fabric.
Daily tasks often center around designing and optimizing data pipelines, refining semantic models, and overseeing cloud migration projects. The role demands close communication with stakeholders to align technical solutions with business needs, plus mentoring BI developers and ensuring data governance standards are met across AWS, SQL Server, and Azure environments.
Specializing as a Data Architect in data warehouse architecture opens pathways to senior leadership roles such as Data Engineering Manager or Chief Data Officer. Mastery in cloud migration, semantic modeling, and cross-platform BI environments often leads to strategic positions influencing enterprise data strategy and innovation across industries.
Balfour Beatty emphasizes integrating cutting-edge BI technologies like Microsoft Fabric alongside established AWS and SQL Server platforms, reflecting a hybrid cloud strategy. Their focus on safety, innovation, and lean practices permeates data operations, setting them apart by fostering a culture where data architects drive both technical excellence and business impact.
This role uniquely combines deep data engineering skills with understanding construction workflows, enabling tailored BI solutions that support project management and operational efficiency. Leveraging cloud migration and semantic modeling, the architect helps translate complex construction data into actionable intelligence for stakeholders.
Data Architects in Rockwall generally earn between $110,000 and $140,000 annually, closely mirroring Dallas market rates due to geographic proximity. Salaries reflect expertise in AWS, Azure, and Microsoft Fabric platforms, with premium pay for candidates who lead successful cloud migration projects and demonstrate strong leadership capabilities.
Transitioning requires advanced understanding of data modeling, architecture frameworks, and cloud services like Azure Synapse and AWS Redshift. Experience leading migrations and designing semantic layers, combined with certifications such as Azure Data Engineer Associate, equips professionals to architect scalable, secure BI solutions effectively.
Hybrid arrangements are increasingly prevalent, as seen with Balfour Beatty's model requiring three office days and two remote days weekly. This balance supports collaboration on complex BI projects while accommodating flexibility, essential for roles involving cross-team communication and hands-on data platform management.
Find The Related Jobs
Parkland Careers
IT Solution Architect
Dallas, TX
Parkland Careers
Data Architect Enterprise
Dallas, TX
Great Lakes Truck Driving School
Software Architect
Houston, TX
V-soft Consulting Inc
Software Architect
Dallas, TX
Deloitte
AWS Infrastructure Enterprise Architect Manager
Dallas, TX