Data Architect

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

Benefits offered by this job

Competitive salary range

Career development and progression

401(k) plan with company match

PTO and paid holidays

Medical, dental, life, vision and AD&D

Employee Assistance Program

Employee referral incentives

Job summary

ColonialWebb is seeking a hands-on Data Architect to build the data foundation that informs strategic decisions. Based in Richmond, VA, you will shape the enterprise data roadmap and deliver production Fabric solutions, including ingestion, modeling, and governance, working with business and IT partners.

You will define standards for data integration, lineage, and security, track platform reliability and business value, and collaborate to ensure self-service analytics across OneLake, lakehouses,

Qualifications

• Five+ years of experience in data architecture and related fields.
• Experience designing target architectures for data lakes, lakehouses, or data warehouses.
• Hands-on data solution development, testing, source control, and production support.
• Strong knowledge of governance, metadata, lineage, security, and data quality.
• Experience with Microsoft Fabric, OneLake, and Power BI is preferred.

Responsibilities

• Assess data systems, integrations, and data quality to define priorities.
• Define an enterprise data architecture and phased analytics roadmap.
• Build production Fabric solutions for ingestion, transformation, and models.
• Ensure data governance, security, and cost management across platforms.
• Document architectures and explain tradeoffs to stakeholders.

Skills

Data architecture

Data engineering

Enterprise data management

Business intelligence

Cloud data platforms

Education

Bachelor's degree or equivalent

Tools

Microsoft Fabric

Power BI

OneLake

Azure data services

Lakehouses/warehouses

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 ColonialWebb stands as a prominent leader in the commercial and industrial mechanical and electrical contracting industry, boasting an unparalleled reputation in the region. Our dynamic business groups encompass Construction, Building Service, Industrial Refrigeration, and Manufacturing. Catering to a diverse clientele, ranging from small enterprises to esteemed Fortune 500 companies, we have consistently delivered exceptional service. Our commitment to excellence is evident through our unmatched expertise and the comprehensive scope of services we offer. With a steadfast dedication to continuous improvement and innovation, we continue to set new industry standards.

ColonialWebb se destaca como un líder prominente en la industria de la contratación mecánica y eléctrica comercial e industrial, con una reputación inigualable en la región. Nuestros dinámicos grupos de negocio abarcan Construcción, Servicios para Edificios, Refrigeración Industrial y Manufactura. Atendiendo a una clientela diversa, que va desde pequeñas empresas hasta prestigiosas compañías Fortune 500, hemos ofrecido consistentemente un servicio excepcional. Nuestro compromiso con la excelencia se refleja en nuestra experiencia incomparable y en el amplio alcance de los servicios que ofrecemos. Con una firme dedicación a la mejora continua y la innovación, seguimos estableciendo nuevos estándares en la industria.