Senior Data Platform Engineer for Analytics & ERP

AWC; United States; Remote; USD 120,000 - 180,000; Full time

Benefits offered by this job

ESOP

Competitive pay

Medical, dental and vision insurance

Employer paid life insurance

Paid time off and holidays

Job summary

AWC is seeking a Senior Data Engineer to build and govern an enterprise analytics foundation that serves reporting, internal apps, and AI tools. You will define models, contracts, and data quality gates, ensuring consistent reconciliation to source systems.

You will lead ingestion pipelines across multiple operational and ERP data sources, with an emphasis on scalable, auditable processes and semantic layers for BI and AI consumers.

Qualifications

• Experience building analytical data platforms end to end, with ownership of architecture and modeling decisions.
• Strong analytical data modeling including grain, dimensional design, slowly changing dimensions and history.
• Experience designing models that stay stable through source changes and ERP migrations.
• Proficiency in SQL, modern transformation frameworks, and cloud data platforms.

Responsibilities

• Shape and govern the analytical data platform that powers reporting, apps, and AI tools.
• Ingest data from operational systems with reliable, auditable pipelines.
• Build canonical and dimensional models reconciled to source of record.
• Support ERP transition readiness and stable data contracts.
• Define semantics and business rules for governance and BI consumption.

Skills

Data modeling

SQL

ETL pipelines

ERP integrations

Governance and quality

BI tooling

Stakeholder collaboration

Cloud data platform

Education

Bachelor's degree in Computer Science

Master's degree in Data Science (nice to have)

Tools

Snowflake

Power BI

SQL-based transformation

Job description

AWC is seeking a Senior Data Engineer to build and govern an enterprise analytics foundation that serves reporting, internal apps, and AI tools. You will define models, contracts, and data quality gates, ensuring consistent reconciliation to source systems.

You will lead ingestion pipelines across multiple operational and ERP data sources, with an emphasis on scalable, auditable processes and semantic layers for BI and AI consumers.