Senior Data Engineer

We’re seeking driven, curious people who bring energy to what they do and see challenges as opportunities to learn and improve. Our team of co-owners values enthusiasm, creativity, and a growth mindset, and we’re committed to putting those qualities to work on solutions that matter. If you’re ready to grow and make an impact, we’d love to be on your team.

As a Senior Data Engineer  you will build the enterprise data foundation that our reporting, our applications, and our AI tools all answer from.  One trusted set of numbers, reconciled to the source and governed with the business. You recognize that good answers are available to us, but they take too long to assemble. Information sits across several operational systems, much of the work of pulling it together is manual, and reports built independently can answer the same question differently.

That slows decisions and costs confidence in the numbers.

We are solving it at the foundation rather than by adding more reports: a governed analytical platform where core business measures are calculated consistently, reconciled to the systems of record, and then made available to every consumer, including Power BI, internal applications, and AI. That work is underway. It needs a permanent technical owner, and this role will help establish the engineering practices behind the BI capability that grows around it.

AWC is also preparing for a future ERP transition. The analytical foundation we build now must survive changes in our operational systems. You will help define stable business models, map legacy and future ERP data into them, and preserve trusted reporting and analytics through that transition.

The ideal candidate will live within reasonable commuting distance of one of our offices in either Houston, Austin, or Dallas Texas, Baton Rouge or New Orleans Louisiana, Atlanta, Georgia, or Jacksonville Florida.

This position is not eligible for visa sponsorship.

How you’ll make an impact:

The analytical platform. Snowflake is our enterprise data platform. Working with the Software Architect, you will shape its data engineering architecture, environments, standards, and the patterns that everything after you is built on Ingestion and pipelines. Bring data from our operational systems into the platform reliably and repeatably using appropriate full, incremental, or change-data patterns, with lineage and auditability built in rather than added later

Governed business models. Build canonical and dimensional models for our core business subject areas and prove they reconcile to the systems of record. Reconciliation is the gate before anything reaches a consumer, not a check we run afterwardERP transition readiness. Help define source-to-target mappings and stable analytical contracts so legacy and future ERP data can feed the same trusted business concepts without forcing a reporting reset

Metric definitions. Work with Finance and our business owners to agree what each measure means, then encode those definitions once so every consumer gets the same answer. Business meaning is governed jointly; engineering makes it repeatable and testable

Semantic and consumption layer. Provide governed models and semantic structures that Power BI, internal applications, and AI tools can all consume. Keep reusable business logic upstream so individual reports and applications do not independently reinterpret raw system data

The standards that follow. Establish and document practical standards for modeling, pipelines, testing, deployment, lineage, access, and documentation so the next engineer builds on the foundation rather than around itWhat you should know going in:

You are at the beginning. This is a foundation stage. The models, standards, and patterns are still being…