Senior Data Engineer

About NCS

National Carwash Solutions (NCS) is one of the largest providers of car wash equipment parts chemicals and service in North America founded in 1973 and headquartered in Grimes Iowa. The IT organization at NCS owns the core data and operational platforms Databricks NetSuite Salesforce Boomi Tableau Freshservice UKG and our enterprise Claude deployment that power finance operations sales manufacturing and field service across the business.

Applicants must have authorization to work in the United States without current or future visa sponsorship by NCS. Applicants who require sponsorship cannot be considered for this position.

About the Role

The Senior Data Engineer is responsible for designing building and operating the data platform that powers analytics reporting and AI capabilities across NCS. This role sits within the Data & AI Enablement team and works end-to-end across the data stack from source-system integration through transformation modeling and delivery to downstream consumers including analysts business stakeholders and AI applications.

This is a full-stack data engineering role. The Senior Data Engineer is expected to be equally comfortable architecting lakehouse pipelines in Databricks building and operating ingestion from enterprise SaaS sources (NetSuite Salesforce UKG and others) via Fivetran and Boomi and partnering with analysts to deliver well-modeled trustworthy data products in Tableau and other downstream tools. Success in this role means a reliable performant well-governed data platform that the business trusts and uses.

Key Responsibilities

• Design build and maintain data pipelines and lakehouse architecture on Databricks (AWS) including Bronze/Silver/Gold layers Delta Lake tables and Unity Catalog governance.
• Develop and maintain SQL-based and PySpark transformations that produce reliable well-modeled data products for analytics reporting and AI use cases.
• Own data ingestion across NCSs enterprise sources including NetSuite Salesforce UKG and other SaaS systems using Fivetran Boomi and custom integrations where required.
• Partner with analysts and business stakeholders to translate reporting and analytics requirements into durable data models and semantic layers.
• Develop and maintain Tableau data sources published data models and supporting infrastructure that enable self-service analytics across the business.
• Implement and enforce data quality observability and lineage practices including testing monitoring and alerting on critical pipelines.
• Establish and document standards for data modeling naming conventions pipeline architecture and source control to ensure long-term maintainability.
• Support AI and agentic workflows by providing curated governed data access to LLM-powered applications and ensuring downstream AI consumers have reliable data.
• Manage platform configuration cost and performance across Databricks Fivetran and related tooling.
• Troubleshoot data issues and partner with source-system owners (NetSuite Salesforce UKG admins) to resolve root causes.
• Contribute to roadmap planning technical design reviews and continuous improvement of the NCS data platform.

Required Qualifications

• 5 or more years of professional data engineering experience including production ownership of pipelines transformations and data models in an enterprise environment.
• Strong hands-on experience with Databricks including Delta Lake Unity Catalog and PySpark or Spark SQL development.
• Expert-level SQL skills including complex transformations performance tuning and dimensional modeling.
• Demonstrated experience building and operating data ingestion from SaaS sources using tools such as Fivetran Boomi Airbyte or equivalent.
• Working knowledge of at least one major ERP CRM or HRIS data model (NetSuite Salesforce Workday UKG or similar).
• Strong proficiency in Python for data engineering automation and integration work.
• Experience with cloud platforms (AWS preferred) and source control (Git/GitHub) including CI/CD practices for data pipelines.
• Experience building and supporting data sources for BI tools such as Tableau Power BI or Looker.
• Strong analytical and problem-solving skills with the ability to investigate data issues across source systems transformations and downstream consumers.
• Excellent written and verbal communication skills with the ability to partner with both technical engineers and non-technical business stakeholders.
• Bachelors degree in Computer Science Engineering Information Systems Mathematics or a related field or equivalent combination of education and professional experience.

Preferred Qualifications

• Experience with the Databricks ecosystem at scale including Workflows DLT Lakehouse Federation and Unity Catalog governance.
• Direct hands-on experience with NetSuite Salesforce or UKG data structures and reporting models.
• Experience with dbt or similar transformation frameworks.
• Familiarity with data contracts data product thinking and semantic-layer tooling.
• Experience supporting AI/ML or LLM-based applications with curated governed data.
• Experience with Boomi or other iPaaS platforms for enterprise integration.
• Background in a manufacturing distribution services or other non-pure-tech enterprise environment.
• Relevant certifications (Databricks Certified Data Engineer Professional AWS Data Analytics or similar).

Physical Requirements & Work Environment

This is a full-time exempt remote role performed primarily from a home office. The position requires the ability to work at a computer for extended periods communicate effectively by phone and video conference and occasionally travel to NCS offices or team meetings (estimated <10% travel).

Benefits & Compensation

Grow your career supported by an energized and passionate team professional development training flexibility and opportunities for advancement. NCS offers medical dental and vision insurance; a 401(k) plan with company match; paid time off and company holidays; life and disability insurance; remote work flexibility; and professional development support.

Compensation: $135000 $160000 annually plus full benefits. This range represents NCSs good-faith estimate of the salary range for this position at the time of posting. Final offer depends on experience skills qualifications and work location.

Application deadline: open until filled. Selected candidates will be notified within 30 days of the hire decision.

Equal Opportunity Employer

National Carwash Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race color religion sex (including pregnancy childbirth and related conditions) sexual orientation gender identity or expression national origin age disability genetic information marital status veteran status citizenship status or any other characteristic protected by federal state or local law. NCS is a drug-free workplace.

NCS provides reasonable accommodations for applicants and employees with disabilities. If you need an accommodation during the application or interview process please contact

Consistent with applicable law NCS does not request or rely on salary history when making hiring or compensation decisions.

Required Experience:

Senior IC