Senior Data Engineer

Yellowstone Local; Hickory Hill (KY); On-site; USD 90,000 - 150,000; Full time

Job summary

MRCOOL is seeking a Senior Data Engineer via Yellowstone Local to design and govern an enterprise data warehouse on Google BigQuery. You will build scalable ELT pipelines, enable AI-ready analytics, and establish a unified data dictionary.

You will partner with finance and operations leaders to define KPIs and deliver governance-focused dashboards using BI tools. This is a hands-on, high-impact role shaping data foundations across the company.

Qualifications

• 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 and production-grade ETL/ELT pipelines across multiple source systems.
• Establish data governance, metadata, and a shared data dictionary for consistent metrics.

Responsibilities

• Architect and govern MRCOOL's enterprise data warehouse on Google Cloud and BigQuery.
• Build scalable ELT/ETL pipelines ingesting data from NetSuite, Sage Intacct, QuickBooks, HubSpot, Magento, Zendesk, Aircall, and more.
• Partner with finance/ops to define KPIs and deliver governed dashboards and executive scorecards.
• Create a semantic layer and data dictionary with consistent definitions for revenue, margin, and DSO.
• Champion data quality, lineage, access controls, and GA4/Looker-based analytics governance.

Skills

BigQuery

ETL/ELT pipelines

Data governance

BI dashboards

KPI development

Tools

Power BI

Looker

Looker Studio

Tableau

BigQuery

Job description

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.

What's in it for You?

• 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
• Lead the consolidation of data across ERP, accounting, CRM, e-commerce, EDI, support, telephony, and analytics platforms
• Partner directly with finance and operations leadership on business-critical KPIs, dashboards, and executive scorecards
• 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 were not specified in the intake

Why You'll Love It Here

• You will not inherit a finished system and simply maintain it. You will design the architecture, standards, and workflows that define how MRCOOL uses data going forward.
• Your work will solve a meaningful business challenge by bringing more than a dozen disconnected platforms into a governed, decision-ready data environment.
• You will have ownership over warehouse architecture, ELT pipelines, historical data cleanup, governance, data quality, reporting, and AI enablement.
• You will work closely with business leaders instead of operating in a silo, giving you direct visibility into how your engineering decisions affect finance, operations, supply chain, and growth.
• MRCOOL is a fast-growing HVAC technology company focused on innovative, energy-efficient ductless mini splits and ducted central air solutions.
• You will have the opportunity to apply modern Google Cloud, BigQuery, BI, data engineering, and generative AI technologies at enterprise scale.

Your New Role

• 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 NetSuite, Sage Intacct, QuickBooks, HubSpot, Magento, Zendesk, Aircall, Google Analytics, Google Drive, and additional business systems
• Integrate EDI, 3PL, and trading-partner data flows from platforms including Celigo, SPS Commerce, CommerceHub, Logicbroker, and qStock
• Optimize BigQuery performance and cost through partitioning, clustering, storage strategies, materialized views, workload management, slot reservations, editions, and consumption monitoring
• Establish enterprise data governance practices covering ownership, role-based access, lineage, PII handling, metadata, and data quality
• Create and maintain a shared business data dictionary and semantic or metrics layer so core terms such as revenue, margin, fill rate, and DSO have consistent definitions
• Reconcile multiple systems of record into unified financial structures, conformed dimensions, and a consistent chart of accounts
• Assess, clean, deduplicate, validate, and consolidate years of historical data from legacy systems, databases, and spreadsheets
• Define automated data quality rules, reconciliation processes, and validation controls that improve trust in reporting
• Partner with finance and operations leaders to define KPIs and deliver governed dashboards and executive scorecards, beginning with Finance
• Build reporting solutions using modern business intelligence platforms such as Power BI, Looker, Looker Studio, Tableau, or similar tools
• Create the governed data and semantic foundation required for natural-language querying and AI-powered analytics using tools such as Gemini in BigQuery, Conversational Analytics Agent/API, or comparable technologies
• Use modern data engineering and AI-assisted development tools to improve testing, documentation, pipeline reliability, metadata management, and developer productivity
• Work with Google Cloud technologies including BigQuery, Google Cloud Storage, Dataflow, Dataproc, Cloud Data Fusion, Datastream, BigQuery Data Transfer Service, Dataplex, Cloud Functions, Cloud Run, Pub/Sub, and related services
• Job location: City and state were not provided in the intake