Principal Data Engineer — Fabric & Real-Time Platform

Vomela Company; Northern (KY); Hybrid; USD 180,000 - 200,000; Full time

Benefits offered by this job

Health care plan

401k retirement plan

Life insurance

Paid time off

Disability insurance

Training & development

Wellness resources

Job summary

Vomela Company is seeking a Principal Data Engineer to own the data platform end to end and set the technical bar across the organization. You will design architectures, write production code, mentor teammates, and shape the data strategy for the business.

You will work with Microsoft Fabric as the primary platform, build semantic models for trustable reporting, and drive real-time and batch data pipelines. A strong emphasis is placed on governance, data contracts, and sensitive-data controls.

Qualifications

• 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.

Responsibilities

• Design and implement dimensional models, star and snowflake schemas with rigor.
• Build and maintain semantic models that serve as the single source of truth for reporting.
• Implement SCD strategies appropriate to each domain.
• Own master data engineering with golden records and cross-system identity resolution.
• Establish and enforce data modeling standards across the team.
• Design and operate real-time pipelines using streaming technologies and determine when streaming is appropriate.
• Drive down data staleness through scheduling, incremental loads, and orchestration design.
• Tune performance across the stack including partitioning, indexing, and Direct Lake readiness.
• Apply operational discipline: observability, alerting, SLAs, failure recovery, capacity planning.
• Design controls for sensitive data (financials, PII, HIPAA).
• ETL/ELT: robust, scalable pipelines with CDC, batch and streaming architectures.
• Ensure idempotent, recoverable pipelines and be the senior technical voice in code review.
• Translate requirements into semantic models and provide trusted data surfaces for BI and AI/ML.
• Define data contracts and own platform developer experience: documentation and onboarding.

Tools

Microsoft Fabric

Power BI

SQL Server / Azure SQL / Postgres

Azure DevOps

Confluent Cloud / Kafka

Job description

Vomela Company is seeking a Principal Data Engineer to own the data platform end to end and set the technical bar across the organization. You will design architectures, write production code, mentor teammates, and shape the data strategy for the business.

You will work with Microsoft Fabric as the primary platform, build semantic models for trustable reporting, and drive real-time and batch data pipelines. A strong emphasis is placed on governance, data contracts, and sensitive-data controls.