Job Description
Job Description About
- The Senior Data Engineer is responsible for the design, construction, and operation of the company’s enterprise data warehouse, consolidating data from multiple ERP platforms and supporting business systems across a nationwide, multi-site organization. This position establishes the data architecture, ingestion pipelines, and governed data models that support executive reporting, financial reconciliation, self-service business intelligence, and emerging AI-assisted analytics. As the organization’s first dedicated data engineering hire, the Senior Data Engineer partners closely with finance, sales, and operations leadership to standardize business definitions across acquired companies and to replace manual consolidation processes with reliable, auditable, automated datasets.
Reporting
- Reports to Senior Director of Technology.
Essential Responsibilities
- Design and implement a layered enterprise data warehouse consolidating multiple ERP systems and supporting business applications, including payroll, field service, expense management, and CRM.
- Build and operate reliable nightly ingestion pipelines across heterogeneous sources, including relational databases, vendor data exports, REST APIs, and file-based feeds.
- Analyze and document legacy ERP database schemas and map them to a canonical, company-wide dimensional model.
- Develop and maintain conformed dimensions and fact tables governed by an enterprise data dictionary; participate in structured workshops with business stakeholders to capture and formalize definitions.
- Implement automated reconciliation between the data warehouse and existing financial reporting systems, validating accuracy through successive monthly closes to an audit-ready standard.
- Design and administer role-based access to warehouse data, including row- and column-level security for sensitive datasets such as payroll and financial records; conduct periodic user access reviews.
- Implement and maintain internal controls over the data platform consistent with SOX-aligned IT general controls, including change management, segregation of duties, activity logging, and documented data lineage.
- Support internal and external audit activities, responding to inquiries regarding data controls, lineage, access, and reporting accuracy.
- Establish and enforce engineering standards, including version-controlled transformations, separate development and production environments, automated data-quality checks, and monitoring and alerting.
- Support the business intelligence visualization layer built on the data warehouse, partnering with report developers and business users on semantic models, curated datasets, and dashboard data requirements.