Join National Gypsum Services Company as a Data Engineer in Charlotte, NC (hybrid). This role focuses on building reliable data pipelines and models that move information from SAP, plant systems, and enterprise applications into the Enterprise Data Warehouse. You will help keep data fast, trustworthy, and governed, with work that supports analytics, reporting, and AI-ready datasets. The salary range is USD 96,336 - 120,420 per year, with a 3+ years experience expectation.
What you will do
- Design, build, and maintain ETL and ELT pipelines that ingest data from enterprise, operational, and third-party sources, automating workflows so they run without manual intervention.
- Build and maintain integrations with SAP, Microsoft 365, plant systems, and other platforms using APIs, batch, and streaming patterns as needed.
- Create and maintain layered data models across raw, curated, and presentation zones using dimensional modeling, warehousing, and lakehouse design practices aligned to team standards.
- Contribute to certified datasets, Power BI semantic models, and KPI definitions so reporting is grounded in a single trusted source of truth.
- Build feature pipelines, training datasets, and vector and search assets that models and agents consume, in partnership with the AI, Data Science & Analytics team.
- Support AI data application work in Streamlit, React, and approved frameworks, including compute, deployment, and data access patterns.
- Tune SQL, warehouse sizing, partitioning, caching, and compression to keep performance strong and costs predictable as data volumes increase.
- Embed validation, anomaly detection, and reconciliation into ingestion pipelines, while maintaining lineage and documentation with the Data Governance and Application Security teams.
- Monitor pipeline health, troubleshoot failures, conduct root-cause analysis, and apply CI/CD and environment promotion practices across dev, test, and production.
- Partner with application owners, plant systems teams, and business stakeholders to translate requirements into durable models and pipelines instead of one-off extracts.
- Other duties as assigned.
What you bring
- Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related field, or equivalent experience.
- 3 to 6 years of hands-on data engineering experience building and operating production pipelines on a cloud data platform.
- Strong SQL, including hands-on experience with Snowflake or a comparable modern cloud data platform.
- Working proficiency in Python for transformation, automation, and pipeline development.
- Experience with ETL/ELT tooling and orchestration frameworks such as Azure Data Factory, dbt, or Airflow.
- Strong understanding of data modeling, including dimensional modeling, star and snowflake schemas, and normalization.
- Experience with Git-based workflows and CI/CD practices for data pipelines.
- Working knowledge of data quality, lineage, and access governance practices.
- Clear communication skills across technical teammates and business stakeholders.
- Preferred: Experience integrating SAP source systems, especially order-to-cash, master data, or finance and logistics structures.
- Preferred: Databricks experience (Spark-based transformations or lakehouse patterns) plus Snowpark, Snowflake Cortex, or dynamic table experience.
- Preferred: Power BI semantic modeling and DAX experience.
- Preferred: Building or deploying data applications in Streamlit, React, or similar frameworks.
- Preferred: Cloud/platform certification such as SnowPro or Azure Data Engineer Associate.
- Preferred: Exposure to manufacturing, supply chain, or industrial operations data.
- Eligible for hybrid work (hybrid schedule is provisional and may change based on business needs).
- Willingness to travel domestically up to 10% of the time.
Benefits
- Competitive salary
- Medical, Dental, Vision
- 401(k) with employer match and a Retirement Account
- Parental Leave
- Fertility Services
- Adoption Assistance
- Paid Vacation and Paid Holidays
- Tuition Reimbursement
- Life Insurance
- Short-Term and Long-Term Disability
- Flexible spending accounts
- Wellness Program with medical premium incentives
Technologies: SAP, Microsoft 365, ETL, ELT, APIs, streaming, dimensional modeling, warehousing, lakehouse design, Power BI, KPI definitions, vector, search, Streamlit, React, SQL, Snowflake, Python, Azure Data Factory, dbt, Airflow, Git, CI/CD, Snowpark, Snowflake Cortex, dynamic table, Databricks, Spark, DAX, star and snowflake schemas, normalization