Senior Data Engineer - Hybrid
- Salary
- $123.4K–$204.2K
- Hiring from
- United States
- Work type
- Hybrid
- Posted
625,755 remote jobs, straight from company career pages
100% free · New jobs every minute
Show job descriptionHide job description
Rex Moore - Sacramento - Sacramento, CA 95828
- Salary Range: $123,350.00 - $204,150.00 Salary
- Position Type: Full Time
- Job Shift: Day
- Travel Percentage: Up to 25%
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.
