Data Architect

ColonialWebb; Richmond (VA); On-site; USD 140,000 - 165,000; Full time

Benefits offered by this job

Competitive salary range

Career development

401(k) plan with company match

PTO and paid holidays

Medical, dental, life, vision and more

Employee Assistance Program

Employee referral incentives

Job summary

ColonialWebb is seeking a hands-on Data Architect to shape the enterprise data roadmap and deliver production solutions using Microsoft Fabric and related tools. Located in Richmond, VA, you will partner with business and technology teams to prioritize analytics needs and drive data-driven decisions.

You will define practical data architectures, establish standards for data governance, lineage, and security, and deliver scalable data ingestions, models, and dashboards across the organization.

Qualifications

• Five+ years in data architecture, data engineering, or analytics roles.
• Experience designing target architectures for data lakes, lakehouses, warehouses, or cloud analytics.
• Hands-on experience with data integration, modeling, governance, and monitoring.

Responsibilities

• Assess ColonialWebb's data systems, integrations, and data flows to identify priorities.
• Define an enterprise data architecture and phased roadmap using Microsoft Fabric capabilities.
• Build, test, and deploy production Fabric solutions including ingestion, transformation, and data models.
• Document systems, data flows, models, and architecture decisions for stakeholders.

Skills

Data architecture

Data engineering

Enterprise data management

Business intelligence

Analytics engineering

Education

Bachelor’s degree or equivalent

Tools

Microsoft Fabric

OneLake

Power BI

Azure data services

Job description

Build the data foundation that will help ColonialWebb make faster, better-informed business decisions. As our hands-on Data Architect, you will shape the enterprise data roadmap and deliver the first production solutions using Microsoft Fabric and related tools.

Location: Richmond, VA

Reports to: Director of Technology Transformation

Who we are:

At ColonialWebb, we are deeply committed to our people, our culture, and the continued growth of our business. As a full-service MEP (Mechanical, Electrical, and Plumbing) contractor, we pride ourselves on the quality and expertise of our teams, who work across a diverse range of specialties, including New Construction, Mechanical Service, Industrial Refrigeration, and Manufacturing. For over 50 years, we’ve been dedicated to delivering comprehensive solutions and unmatched service to our commercial customers, earning a reputation as a trusted contractor in the industry.

Perks of joining ColonialWebb:

• Competitive salary range of $140,000-$165,000, based on experience
• Career development and progression
• 401(k) plan with company match
• PTO and paid holidays
• Excellent medical, dental, life, vision and disability benefits
• Employee Assistance Program
• Employee referral incentives

A day in the life:

Assess ColonialWebb's data systems, integrations, reporting, data flows, ownership, quality, security, and current constraints. Partner with business and technology teams to identify priorities and future analytics needs.

Define and maintain a practical enterprise data architecture and phased roadmap, choosing the right Microsoft Fabric capabilities for each use case, including OneLake, lakehouses, warehouses, pipelines, notebooks, and semantic models.

Build, test, and deploy the first production Fabric solutions, including data ingestion and transformation, reusable data models, source control, release practices, and production monitoring.

Create workable standards for data integration, modeling, governance, metadata, lineage, quality, retention, access, security, recovery, monitoring, and cost management. Work with business and IT leaders to clarify data ownership and stewardship.

Integrate Penta Software and other enterprise systems to support reliable reporting, self-service analytics, and future business needs. Track platform reliability, data quality, adoption, and business value, then improve the capability over time.

Maintain clear documentation of systems, data flows, models, standards, roadmaps, and architecture decisions. Explain technical tradeoffs in terms stakeholders can use and protect confidential company and employee information.

You should have:

• Five or more years of relevant experience in data architecture, data engineering, enterprise data management, business intelligence, analytics engineering, or a comparable role.
• Experience assessing complex data environments and designing practical target architectures and phased roadmaps for data lakes, lakehouses, warehouses, or cloud analytics platforms.
• Hands‑on experience building and deploying data solutions, including integration and transformation, testing, source control, release practices, and production support or monitoring.
• Strong knowledge of data architecture and modeling, governance, data quality, metadata, lineage, security, access controls, and enterprise integration, with the ability to translate business needs into technical priorities.
• Microsoft Fabric, OneLake, Power BI, Azure data services, or similar cloud platform experience preferred. A related bachelor’s degree or equivalent education and experience, relevant certifications, and experience integrating enterprise systems are valued.

EOE M/W/Disability/Vets

Veterans and those with previous military experience are encouraged to apply