Data Engineer
Analytics
API Integrations
Big Data
Business Intelligence
Cloud Data Platform
Cloud Data Warehouse
Cloud Data Warehouse
Cloud Platform
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Integration
Data Integration Tools
Data Orchestration
Data Pipeline
Data Platform
Data Processing
Data Visualization
Data Warehouse
Data Warehousing
Database
Databases
Design
Digital Marketing
Dimensional Modeling
ETL
Informatica
Information Technology (IT)
Product Integration
Programming Language
Programming Languages
Reporting and Analytics
Snowflake
Software Development
SQL
Visual Design
Job Description
The Data Engineer will design and maintain data pipelines, models, and governed datasets that move information from SAP, plant systems, and enterprise applications into the Enterprise Data Warehouse. This hybrid role in Charlotte, NC focuses on reliable ingestion, semantic-layer development, AI-ready outputs, and performance optimization.
Key Responsibilities
- Design, build, and maintain ETL and ELT pipelines to ingest data from enterprise, operational, and third-party sources, automating workflows to run reliably without manual intervention.
- Develop and maintain integrations with SAP, Microsoft 365, plant systems, and other enterprise platforms using APIs, batch, and streaming patterns as needed.
- Create and maintain layered data models across raw, curated, and presentation zones, applying dimensional modeling, warehousing, and lakehouse design practices aligned to team naming and modeling standards.
- Support certified datasets, Power BI semantic models, and KPI definitions used for reporting by contributing to a single trusted definition for business users.
- Build feature pipelines, training datasets, and vector and search assets that models and agents consume in partnership with the AI, Data Science & Analytics team.
- Work with the AI team on data applications in Streamlit, React, and other approved frameworks, including setting up compute, deployment, and data access patterns.
- Tune SQL and platform components such as warehouse sizing, partitioning, caching, and compression to support performance and predictable spend as data volume grows.
- Implement validation, anomaly detection, and reconciliation in ingestion pipelines, and maintain lineage and documentation with the Data Governance and Application Security teams.
- Monitor pipeline health, troubleshoot failures, perform root-cause analysis, and apply CI/CD and environment promotion across dev, test, and production.
- Partner with application owners, plant systems teams, and business stakeholders to translate data requirements into durable models and pipelines rather than one-off extracts.
- Perform other duties as assigned.
Required Qualifications
- 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 experience with hands-on work in Snowflake or a comparable modern cloud data platform.
- Working proficiency in Python for data transformation, automation, and pipeline development.
- Experience with ETL and ELT tooling and orchestration frameworks such as Azure Data Factory, dbt, or Airflow.
- Solid understanding of data modeling concepts, 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.
- Ability to communicate effectively with both technical teammates and business stakeholders.
- 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.
Preferred Qualifications
- Experience integrating SAP source systems, especially order-to-cash, master data, or finance and logistics structures.
- Databricks experience, including Spark-based transformations or lakehouse patterns, plus Snowpark, Snowflake Cortex, or dynamic table experience.
- Power BI semantic modeling and DAX experience.
- Experience building or deploying data applications in Streamlit, React, or similar frameworks.
- Cloud or platform certification such as SnowPro or Azure Data Engineer Associate.
- Exposure to manufacturing, supply chain, or industrial operations data.
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
Location and Compensation
- Location: Charlotte, NC (hybrid)
- Salary: USD 96,336 to 120,420 per year
- Minimum Experience: 3 years
Benefits
- Competitive salary
- Medical, Dental, Vision
- 401(k) with employer match
- Retirement Account
- Parental Leave, Fertility Services, Adoption Assistance
- Paid Vacation, Paid Holidays
- Tuition Reimbursement
- Life Insurance, Short-Term and Long-Term Disability
- Flexible spending accounts
- Wellness Program with medical premium incentives
Hiring Entity
NATIONAL GYPSUM SERVICES COMPANY