Back to jobs

Senior Data Engineer - Hybrid

Rex Moore - Sacramento - Sacramento, CA 95828

Actively hiring, first seen by us 2 days ago
Pay
$123,350–204,150/yearAnnual period assumed — pay source
Salary $123,350.00 - $204,150.00 Salary
Read the full posting
Work setting
Hybrid — work setting source
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:
Read the full posting
Employment
Full-time — employment source
Employment type in the employer’s posting: Full Time
From the employer’s posting

What you’ll work on

Full posting
  • Build and maintain bronze, silver and gold medallion layers in the Fabric lakehouse

  • Design and operate ingestion and transformation pipelines using Fabric Data Factory and Spark

  • Build and tune Direct Lake semantic models for financial and project cost reporting

  • Implement data quality validation and reconciliation to source systems

  • Monitor platform health, pipeline reliability and data freshness against service levels

From the employer’s posting
Build and maintain the medallion architecture (bronze, silver, gold)
Design, build, and operate ingestion and transformation pipelines using Fabric Data Factory, Dataflows, notebooks, and Spark.
Build and tune Direct Lake semantic models supporting financial reporting and project/job cost reporting.
Implement data quality validation and reconciliation to source across finance, job cost, and project data.
Monitor platform health, pipeline reliability, data freshness, and refresh performance against defined service levels.

What you’ll bring

All qualifications

Core experience

  • Knowledge, Skills and Abilities
  • 7+ years of experience in data engineering, business intelligence engineering, or enterprise data platform roles.
  • Experience as the first or primary data engineer in an organization establishing the function.
  • Ability to translate business questions into data requirements and explain technical constraints in business terms.
  • Ability to operate independently and own a production platform end to end.
  • Ability to verbally communicate: convey detailed and accurate instructions and information.
Qualification wording
Knowledge, Skills and Abilities
7+ years of experience in data engineering, business intelligence engineering, or enterprise data platform roles.
Experience as the first or primary data engineer in an organization establishing the function.
Ability to translate business questions into data requirements and explain technical constraints in business terms.
Ability to operate independently and own a production platform end to end.
Ability to verbally communicate: convey detailed and accurate instructions and information.

About RSS

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.

In the employer’s words · Read in context

Apply at RSS

Posting record

Report an error

Actively hiringFirst seen by us 2 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 19, 20262 days ago
Recorded sightings
2
Last seen by us
Nov 20, 2026
Employer says posted
Nov 17, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

In line with similar jobs

$123K–$204K against $127K–$189K, the middle half of what similar US postings state.

From 2,448 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 2

Early. Similar jobs usually come down between day 6 and day 56.

From 14,770 similar postings that came down. Coming down is not always a hire.

RSS is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • Azure
  • Databricks
  • Power BI
  • PySpark
Where the posting names them
- Power BI development including DAX, semantic model design, and report performance tuning. - Proficiency with Python and/or PySpark for data transformation. - Experience integrating ERP data and building API-based ingestion against authenticated REST endpoints.
- Production experience with Microsoft Fabric, Azure Synapse, Databricks, or a comparable cloud lakehouse platform, including layered or medallion architecture. - Advanced SQL and hands-on experience with cloud data platforms and distributed processing. - Dimensional modeling experience (Kimball or similar) with demonstrated ownership of a production data model.
- 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.
- 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.
- 7+ years of experience in data engineering, business intelligence engineering, or enterprise data platform roles. - Production experience with Microsoft Fabric, Azure Synapse, Databricks, or a comparable cloud lakehouse platform, including layered or medallion architecture. - Advanced SQL and hands-on experience with cloud data platforms and distributed processing.
- Relevant Microsoft certifications (DP-600, DP-700, AZ-305, AI-102). - Exposure to Microsoft Foundry, Azure AI Search, or retrieval-augmented generation (RAG) data patterns. Preferred Knowledge – Construction / AEC Industry (Architecture, Engineering & Construction)
- 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.
- Dimensional modeling experience (Kimball or similar) with demonstrated ownership of a production data model. - Power BI development including DAX, semantic model design, and report performance tuning. - Proficiency with Python and/or PySpark for data transformation.

Your next step

Complete your application on www.paycomonline.net. The employer’s form will show what is required.

Applying through Paycom

  • The application asks you to sign in or create a Paycom account with the employer.

Already applied? Track this application

Job description

View original posting ↗

Description

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

Qualifications

Knowledge, Skills and Abilities

Knowledge

  • 7+ years of experience in data engineering, business intelligence engineering, or enterprise data platform roles.
  • Production experience with Microsoft Fabric, Azure Synapse, Databricks, or a comparable cloud lakehouse platform, including layered or medallion architecture.
  • Advanced SQL and hands-on experience with cloud data platforms and distributed processing.
  • Dimensional modeling experience (Kimball or similar) with demonstrated ownership of a production data model.
  • Power BI development including DAX, semantic model design, and report performance tuning.
  • Proficiency with Python and/or PySpark for data transformation.
  • Experience integrating ERP data and building API-based ingestion against authenticated REST endpoints.
  • Working knowledge of source control, CI/CD practices, and deployment automation for data workloads.
  • Understanding of enterprise identity and access management, data classification, and secure handling of sensitive data.
  • Bachelor’s degree in Information Technology, Computer Science, Data Engineering, or a related field, or equivalent work experience.

Preferred Knowledge – Platform

  • Direct Microsoft Fabric and OneLake production experience, including Direct Lake semantic models.
  • Microsoft Purview or comparable enterprise data governance tooling.
  • Experience as the first or primary data engineer in an organization establishing the function.
  • Relevant Microsoft certifications (DP-600, DP-700, AZ-305, AI-102).
  • Exposure to Microsoft Foundry, Azure AI Search, or retrieval-augmented generation (RAG) data patterns.

Preferred Knowledge – Construction / AEC Industry (Architecture, Engineering & Construction)

  • Experience supporting data, reporting, or systems within construction, engineering, architecture, specialty trade contracting, or another AEC or project-based industry.
  • Familiarity with construction financial and operational concepts including job cost, work breakdown structure (WBS), cost codes and cost types, committed cost, change orders, percent-complete revenue recognition, work-in-progress (WIP) reporting, and retention.
  • Understanding of how estimating, project management, field operations, procurement, and accounting data relate to one another across systems in a construction organization.
  • Exposure to construction and AEC platforms such as Autodesk Construction Cloud (Build or Forma) for project management and documents, Trimble Accubid for electrical estimating, Bluebeam for drawing review and markups, and Revizto for 3D model coordination, or comparable project delivery and estimating systems.
  • Experience integrating supporting business platforms such as Paycom (HRIS and payroll), Expensify (expense reporting and corporate cards), or Hilti ON!Track (tool and equipment tracking).
  • Familiarity with construction workforce and field data including labor hours, crew and unit productivity, timekeeping, payroll integration, equipment and tool tracking, and prefabrication.
  • Awareness of the data considerations in document-heavy environments such as drawings, submittals, RFIs, and contract documents, including metadata, retention, and governance implications.
  • Understanding of the reporting needs of project managers, field leadership, finance, and executives in a project-driven business.

Skills

  • Strong analytical and problem-solving skills, including the ability to trace a data issue from report back to source.
  • Strong documentation discipline, including the ability to produce diagrams, runbooks, and technical specifications others can follow.
  • Excellent verbal and written communication skills.
  • Ability to translate business questions into data requirements and explain technical constraints in business terms.
  • Ability to collaborate effectively with IT staff, business SMEs, executives, and external vendors.

Abilities

  • Ability to operate independently and own a production platform end to end.
  • Strong attention to detail and commitment to data accuracy and reconciliation to source.
  • Ability to prioritize competing demands and work in a fast-paced environment.
  • Ability to establish standards and repeatable patterns rather than solving each problem uniquely.
  • Interest in growing the Rex Moore data engineering capability over time.

 

Physical Requirements:

  • Ability to verbally communicate: convey detailed and accurate instructions and information.
  • Ability to hear with or without correction in order to receive and interpret detailed information.
  • Required to sit at a desk work station for long periods of time.
  • Push, pull, lift, carry at least 10 pounds and occasionally lift/move up to 35 pounds.
  • Occasionally required to walk and stand for short and long periods of time.
  • Required to have visual acuity with or without correction in order to read contract documents, analyze data, view a computer monitor, and proof-read documents to identify errors.
  • Required to use fingers and hands: type using a computer keyboard, handle, feel, and reach.
  • May occasionally be required to stoop, kneel, and crouch.

Salary

$123,350.00 - $204,150.00 Salary

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Salary $123,350.00 - $204,150.00 Salary
Location & working pattern

Rex Moore - Sacramento - Sacramento, CA 95828

- 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.
More source context
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:
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.