Jobs · Information Technology · Kentucky

Principal Data Engineer

Vomela Commercial Group · Headquarters, KY · Today
Information Technology$180/hrFull-time

About the role

As the Principal Data Engineer at Vomela, you will be the highest-performing contributor on our data engineering team. You will set the technical bar, own the data platform end-to-end, and deliver work that others study. You'll define and execute data strategy at the engineering level, operating as the technical point of the spear for how the organization builds, scales, and trusts its data. This role is for someone genuinely energized by the Microsoft Fabric ecosystem, who tracks its evolution closely and sees its breadth as an opportunity, not a constraint.

Responsibilities

  • Design and implement dimensional models, star schemas, and snowflake schemas with rigor.
  • Build and maintain semantic models that serve as the single source of truth for business reporting.
  • Implement Slowly Changing Dimension (SCD) strategies appropriate to each domain.
  • Own master data engineering: golden record patterns, source-of-record authority, cross-system identity resolution.
  • Establish and enforce data modeling standards across the team.
  • Design and operate real-time and near-real-time pipelines using streaming technologies (Kafka, Confluent Cloud, Fabric Eventstreams) — and know when streaming is the right answer and when it isn't.
  • Drive down data staleness in non-streaming scenarios through intelligent scheduling, incremental load optimization, and pipeline orchestration design.
  • Apply performance tuning across the full stack — query optimization, partition strategy, indexing, Delta table compaction, semantic model refresh efficiency, and Direct Lake readiness.
  • Apply operational engineering discipline: pipeline observability, alerting, SLA definition, failure recovery, and capacity planning.
  • Design and implement controls appropriate for sensitive data (financials, PII, HIPAA, etc.).
  • Build robust, scalable, observable ETL/ELT pipelines — watermark-based incremental loads, CDC patterns, batch and streaming architectures.
  • Ensure pipelines are idempotent, recoverable, and production-hardened.
  • Serve as the senior technical voice in code review — your approval carries weight.
  • Translate business requirements into semantic models and report-layer artifacts that non-technical users can trust and navigate.
  • Serve as the platform's primary technical interface across consumer groups: Power BI report builders needing trusted, well-modeled semantic layers; AI/ML developers needing governed, feature-ready data surfaces; application developers consuming data via SQL endpoints, REST APIs, or Direct Lake.
  • Define and enforce data contracts — schema stability, access patterns, SLAs — for each consumer class.
  • Own the developer experience of the platform: discoverability, documentation, and onboarding.

Requirements

  • Required Microsoft Fabric: Lakehouses, Notebooks, Dataflows Gen2, Event streams, Semantic Models, Direct Lake mode.
  • Power BI: report development, dataset/semantic model design, DAX proficiency.
  • SQL Server / Azure SQL/Postgres: query optimization, schema design, stored procedures.
  • Azure DevOps: Git-based development workflows, CI/CD for data pipelines.
  • Demonstrated use of AI coding assistants in a production engineering workflow.
  • Ability to critically evaluate, edit, and improve AI-generated code and artifacts.
  • Clear understanding of where AI accelerates work and where it introduces risk.

Preferred Qualifications

  • Familiarity with broader Azure Data Services (Azure Data Factory, Synapse Analytics, ADLS Gen2, Event Hubs) as complementary tooling.
  • Experience in a private equity-backed or multi-entity portfolio company environment.
  • Exposure to MDM platforms (Profisee, Semarchy, Ataccama, or equivalent).
  • Experience with Confluent Cloud / Apache Kafka for streaming ingestion into Fabric or Synapse.
  • Familiarity with cross-tenant Azure / Fabric architecture.
  • Background in business analysis, solutions architecture, or pre-sales engineering.
  • Microsoft Fabric or Azure Data Engineer certifications.

Benefits

  • Health Care Plan (Medical, Dental & Vision)
  • Retirement Plan (401k)
  • Life Insurance (Basic, Voluntary & AD&D)
  • Paid Time Off
  • Short Term & Long-Term Disability
  • Training & Development
  • Wellness Resources

Pay Range: $180 – 200k USD

Similar jobs

Principal Data Engineer

LaddersUnited States· 1 mo ago
RemoteInformation Technology$169k–$271k/yrapply on theladders.com

Principal Data Engineer

SovrnBoulder, CO· 2 mo ago
Information Technology$200k–$240k/yrapply on job-boards.greenhouse.io

Principal Data Engineer

Fitch RatingsChicago, IL· 2 mo ago
Information Technology$140k–$160k/yrapply on careers.fitch.group