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 NCS’s 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.
• Bachelor’s 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: $135,000 – $160,000 annually, plus full benefits. This range represents NCS's 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 recruiting@ncswash.com.

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

Salary : $135,000 - $160,000