Senior Data Engineer

About the Position

Senior Data Engineer

• Location: Hickory, Kentucky
• Salary: $145,000 - $155,000 per year

Yellowstone Local is proud to represent MRCOOL, an industry leader in HVAC. If you know how to turn fragmented systems into one trusted source of truth, this is your chance to build the data foundation of a fast-growing HVAC brand from the ground up.

Responsibilities

• Serve as the Senior Data Engineer responsible for architecting, building, and governing MRCOOL’s enterprise data warehouse on Google BigQuery and Google Cloud.
• Design a modern ELT architecture using raw, staging, conformed core, and department-level data marts.
• Build scalable, production-grade ETL and ELT pipelines that ingest and transform data from various business systems.
• Integrate EDI, 3PL, and trading-partner data flows from multiple platforms.
• Optimize BigQuery performance and cost.
• Establish enterprise data governance practices.
• Create and maintain a shared business data dictionary and semantic or metrics layer.
• Reconcile multiple systems of record into unified financial structures.
• Assess, clean, deduplicate, validate, and consolidate years of historical data from legacy systems.
• Define automated data quality rules, reconciliation processes, and validation controls.
• Partner with finance and operations leaders to define KPIs and deliver governed dashboards and executive scorecards.
• Build reporting solutions using modern business intelligence platforms.
• Create the governed data and semantic foundation required for natural-language querying and AI-powered analytics.
• Use modern data engineering and AI-assisted development tools to improve testing, documentation, pipeline reliability, metadata management, and developer productivity.

Requirements

• 7+ years of hands-on data engineering experience within a major public cloud environment.
• Google Cloud Platform experience required.
• 7+ years of hands-on experience designing, deploying, integrating, and operating Google BigQuery as an enterprise data warehouse.
• Advanced SQL skills and strong experience with dimensional modeling, conformed data models, and enterprise warehouse design.
• Strong experience with Google Cloud Storage for data lake storage, staging, retention, and lifecycle management.
• Experience building pipelines with Google Cloud data services such as Dataflow, Dataproc, Cloud Data Fusion, Datastream, or BigQuery Data Transfer Service.
• Experience with metadata management and data cataloging using Dataplex, Knowledge Catalog, or comparable technologies.
• Experience using Cloud Functions, Cloud Run, and Pub/Sub for event-driven data processing and pipeline automation.
• Strong EDI experience, including trading-partner and 3PL data integration.
• Proven ability to build reliable, scalable, production-grade ETL and ELT pipelines.
• Strong experience with data governance, data quality, data lineage, access controls, and business or metric definitions.
• Demonstrated success cleaning, deduplicating, reconciling, and consolidating historical data from disparate legacy systems.
• Experience developing KPIs, dashboards, executive scorecards, and business intelligence solutions using Power BI, Looker, Tableau, Looker Studio, or similar platforms.
• Experience with modern data and AI tooling, including AI-assisted development, natural-language-to-SQL, generative AI, or LLM-based analytics.
• Strong communication skills with the ability to work directly with finance, operations, and other business stakeholders.

Nice to Have

• Experience integrating NetSuite, Sage Intacct, or QuickBooks data.
• Experience with dbt or comparable SQL transformation frameworks.
• Experience with Airbyte, Fivetran, or similar EL tools.
• Experience with Cloud Composer, Apache Airflow, Dataform, or similar orchestration tools.
• Google Cloud Professional Data Engineer certification.
• Experience in distribution, wholesale, manufacturing, or supply-chain environments.
• Familiarity with Magento, HubSpot, Zendesk, and Aircall data.
• Bachelor’s degree in Computer Science, Information Systems, or a related field.

We Offer

• Competitive salary range of $145,000 - $155,000 per year.
• High-visibility, high-ownership role with direct impact on company-wide decision-making.
• Opportunity to architect and build a greenfield enterprise data warehouse on Google BigQuery and Google Cloud.
• Work with modern data engineering, AI-assisted development, and natural-language analytics tools.
• Shape MRCOOL’s data governance, semantic layer, business dictionary, and enterprise reporting standards.
• Build the foundation for AI-driven access to trusted business data.
• Compensation, schedule, and additional benefits.

About the Company

MRCOOL is a fast-growing HVAC technology company focused on innovative, energy-efficient ductless mini-splits and ducted central air solutions. We are committed to providing high-quality products and services to our customers while maintaining a strong commitment to sustainability and innovation.

Hiring Expectations: Apply today and complete a quick phone screening. Qualified candidates will then move through a two-round interview process, starting with a virtual interview followed by an on-site interview to discuss your experience and career goals.

MRCOOL is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment regardless of race, color, religion, gender, gender identity, sexual orientation, national origin, genetics, disability, age, or veteran status.