Senior Data Engineer - Hybrid

Posted Yesterday
95828, Sacramento, CA, USA
Hybrid
123K-204K Annually
Senior level
Professional Services
The Role
Own and operate Rex Moore’s Microsoft Fabric enterprise data lakehouse, including OneLake storage, ingestion pipelines, medallion architecture, dimensional models, semantic models, governance, security, and reporting enablement. Integrate ERP, project, financial, HR, and construction systems; ensure data quality, reconciliation, reliability, and cost efficiency; manage deployment and disaster recovery; document platform standards; transition ownership from an implementation partner; and mentor future data team members.
Summary Generated by Built In

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.

Skills Required

  • 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
  • Experience with layered or medallion data architecture
  • Advanced SQL and hands-on experience with cloud data platforms and distributed processing
  • Dimensional modeling experience using Kimball or similar methods, with 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
  • Direct Microsoft Fabric and OneLake production experience, including Direct Lake semantic models
  • Experience with Microsoft Purview or comparable enterprise data governance tooling
  • Experience as the first or primary data engineer establishing a data function
  • Relevant Microsoft certifications such as DP-600, DP-700, AZ-305, or AI-102
  • Exposure to Microsoft Foundry, Azure AI Search, or retrieval-augmented generation data patterns
  • 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, WBS, cost codes, committed cost, change orders, WIP reporting, and retention
  • Understanding of estimating, project management, field operations, procurement, and accounting data relationships in construction organizations
  • Exposure to construction and AEC platforms such as Autodesk Construction Cloud, Trimble Accubid, Bluebeam, or Revizto
  • Experience integrating business platforms such as Paycom, Expensify, or Hilti ON!Track
  • Strong analytical, problem-solving, documentation, communication, collaboration, and data reconciliation skills
  • Ability to operate independently and own a production platform end to end
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Sacramento, CA
550 Employees
Year Founded: 1922

What We Do

Rex Moore Group, Inc. is an electrical contractor providing design-build and bid services for electrical and low-voltage projects. It serves projects of all sizes and maintains a large service department offering 24-hour emergency response and routine maintenance for facilities. The company also applies lean manufacturing methods, standardized designs, and prefabricated assemblies to improve quality, reduce rework and material lead times, shorten schedules, and improve safety.

Similar Jobs

DAWAR CONSULTING INC Logo DAWAR CONSULTING INC

Senior Data Engineer

HR Tech • Information Technology • Professional Services • Consulting
Hybrid
San Mateo, CA, USA
90-98 Hourly
Remote or Hybrid
3 Locations
20990 Employees
55K-109K Hourly

Comcast Logo Comcast

Senior Account Executive

Digital Media • Information Technology • News + Entertainment
Hybrid
Fairfield, CA, USA
115000 Employees
73K-123K Annually

Comcast Logo Comcast

Head of Customer Success

Digital Media • Information Technology • News + Entertainment
Remote or Hybrid
California, USA
115000 Employees
110K-313K Annually

Similar Companies Hiring

Energy CX Thumbnail
Greentech • Professional Services • Business Intelligence • Consulting • Energy • Financial Services • Utilities
Chicago, IL
150 Employees
Cravath, Swaine & Moore LLP Thumbnail
Legal Tech • Other • Professional Services
New York, NY
1200 Employees
VCA Animal Hospitals Thumbnail
Pet • Professional Services
Los Angeles, CA
35000 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account