Data Architect

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