Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

RSS, LLC.

NewBe an early applicant

Senior Data Engineer - Hybrid

Posted Updated

Summary

Owns and operates Rex Moore's enterprise Data Lakehouse on Microsoft Fabric and OneLake: builds ingestion/transformation pipelines (Data Factory, Spark), medallion-layer data models, and Direct Lake semantic models powering Power BI reporting, while managing governance in Purview, Entra-based access, backup/DR, and platform cost.

About Us:

Rex Moore continues to be powered by amazing employees just like you for over 100 years. Together we are building a world that is safe, comfortable, and sustainable. Our diverse team of experts spreading to National territories create innovative, integrated solutions to make cities more connected, buildings more intelligent and environments more comfortable and secure.

Watch Our Story: About Rex Moore Group, Inc. - YouTube

Job Overview:

The Senior Data Engineer is the internal owner of Rex Moore’s enterprise Data Lakehouse platform, built on Microsoft Fabric with OneLake as the storage foundation. This role designs, builds, and operates the pipelines, data models, and semantic layer that consolidate information from ERP, project management, estimating, design coordination, document management, field operations, HR, and financial systems into a single governed enterprise data foundation supporting reporting, applications, workflow automation, and AI capabilities.

This position inherits Rex Moore’s newly established enterprise Data Lakehouse and builds on that foundation. The Senior Data Engineer assumes full operational ownership of the platform, completes the transition from Rex Moore’s implementation partner, and continues to extend it with new data sources, models, and capabilities as the business grows. Over time, this role establishes the technical patterns, standards, and documentation on which Rex Moore’s data engineering practice is built.

Key Responsibilities and Essential Tasks

Data Lakehouse Architecture & Platform Operations

  • Own the ongoing design and operation of the Microsoft Fabric Data Lakehouse, including OneLake storage, Lakehouse items, and Fabric workspaces across development, test, and production environments.
  • Build and maintain the medallion architecture (bronze, silver, gold) governing how raw source data is landed, refined, and published for enterprise consumption.
  • Manage deployment automation and environment promotion through Fabric deployment pipelines and Azure DevOps source control.
  • Monitor platform health, pipeline reliability, data freshness, and refresh performance against defined service levels.
  • Maintain Fabric capacity performance and evaluate capacity sizing based on actual workload rather than default scale-up.
  • Administer the on-premises data gateway and hybrid connectivity to on-premises source systems.
  • Design and periodically test backup, recovery, and disaster recovery for platform data and configurations.

Data Engineering & Integration

  • Design, build, and operate ingestion and transformation pipelines using Fabric Data Factory, Dataflows, notebooks, and Spark.
  • Integrate enterprise source systems using supported APIs, vendor connectors, database replication, or secure file transfer, favoring repeatable patterns over one-off integrations.
  • Build and maintain integrations with OAuth-secured vendor APIs, handling authentication, rate limits, pagination, and incremental extraction where source systems lack reliable change tracking.
  • Ingest and model semi-structured and document-derived data, including document metadata, OCR-extracted fields, drawing markups, and model coordination issues.
  • Develop incremental load, change data capture, and historical retention strategies appropriate to each source system.
  • Implement data quality validation and reconciliation to source across finance, job cost, and project data.
  • Onboard new source systems as the Rex Moore application portfolio evolves.

Data Modeling, Semantic Layer & Reporting Enablement

  • Develop and maintain dimensional models and conformed enterprise dimensions in the gold layer, including Company, Project, Period, Cost Code, Vendor, and Employee.
  • Build and tune Direct Lake semantic models supporting financial reporting and project/job cost reporting.
  • Implement and test row-level and object-level security in semantic models, including project-scoped access for project and field roles.
  • Manage release and change control for shared models and conformed dimensions so changes are tested, communicated, and applied consistently across dependent reports.
  • Establish standardized enterprise business logic, KPIs, and measures in the semantic layer so calculations are defined once rather than recreated independently in each Power BI report.
  • Partner with business SMEs to define reporting requirements, identify authoritative data sources, and resolve conflicts where multiple systems contain similar information.
  • Support month-end close data readiness and reconciliation, monitor report usage and adoption, and partner with business report champions to drive measurable value.
  • Support self-service analytics and Power BI Copilot and natural-language Q&A readiness through model metadata and synonym preparation.
  • Prepare governed, certified gold-layer data for Microsoft Foundry AI use cases, including AI Search indexing and retrieval patterns, in partnership with AI and application teams.

Data Governance, Security & Access

  • Implement and maintain data cataloging, lineage, business glossary, ownership, sensitivity labeling, data quality rules, and data loss prevention in Microsoft Purview.
  • Design and enforce role-based access aligned with Microsoft Entra identity and least-privilege principles, ensuring downstream permissions appropriately reflect source-system restrictions.
  • Manage service identities, managed identities, and secure credential and secrets handling for all integrations.
  • Support data classification and controlled access to sensitive financial, project, and workforce information.
  • Partner with business data owners and stewards to certify data products and maintain stewardship over time.

Documentation, Knowledge Transfer & Platform Ownership

  • Maintain current platform documentation, architecture diagrams, source-to-target mappings, data dictionary, and operational runbooks.
  • Complete knowledge transfer from the implementation partner, validate delivered work against contracted acceptance criteria, and take ownership of platform documentation, runbooks, and open items.
  • Establish repeatable engineering standards, naming conventions, and development practices for future data work.
  • Serve as the internal technical authority for the Data Lakehouse platform following consultant transition.
  • Mentor future data team members and direct contractor and vendor work on the platform.

Continuous Improvement & Cost Awareness

  • Track and forecast recurring platform cost across Fabric capacity, storage, compute, and data movement.
  • Identify opportunities to simplify, consolidate, or improve existing pipelines and models.
  • Stay current on Microsoft Fabric and Azure data platform capabilities and evaluate their applicability to the Rex Moore environment.
  • Participate in training and self-development initiatives to improve technical and business acumen.

What’s in it for You?

We’re growing and need people excited about honing their craft and developing their career. If you’re ready to push your skill level, learn something new every day, and be part of tomorrow’s energy source, join the Rex Moore Family.

Some of the benefits you may be eligible for as an employee are:

  • Health Benefits
  • 401(k) with Company Match
  • Life and Disability Benefits
  • Paid Holidays & Paid time off
  • Access to multiple types of training
  • Opportunities for Self-development and Career Progression
  • Wellness Benefits & Employee Assistance Program
  • Family Leave (Maternity, Paternity)
  • Tuition Reimbursement Program

Career Advancement:

At Rex Moore, we provide amazing job opportunities for growth with competitive salaries and benefits in an exciting, dynamic, fast-paced, and fun workplace environment. Are you looking to build a strong career? Then we have an opportunity for you!

Compensation:

Rex Moore pays hourly/salary rates commensurate with each employee’s knowledge, experience and skill level.

Work environment:

This is a hybrid position, with a combination of in-office and remote work. Fully remote arrangements may be considered for candidates with demonstrated success working remotely and a proven record of driving initiatives independently. This position may be required to travel to other office locations.

Reporting Structure:

Reports to – Information Technology Director

Department – Information Technology Department

Skills

What Senior Data Engineering jobs ask for — and how much of it you have →
Apply

See also

Data Engineering jobs by country — openings, pay and top skills →