Senior Data Engineer

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., * 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.

Do you have experience in Version control?, * 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., * 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)., 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).

$135,000 - $160,000 a year - Full-time, Pulled from the full job description

• Health insurance
• 401(k) matching
• Paid time off
• Vision insurance
• Dental insurance
• Disability insurance
• Paid holidays, 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.

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.