Position Summary:
Sunrise Farms is seeking a Senior Data Integration Lead (12-mont contract) to join the Reset & Restart (R&R) Program on a 12-month hourly contract. R&R is a large-scale digital transformation initiative that implements our new Syspro ERP among other enterprise solutions. This role will be part of the Data Foundations Project Team and will lead the design, development, and delivery of the interim data integration solution required to support the phased rollout of the new Syspro ERP.
The primary focus of this role is to design and oversee the development of data pipelines that move data from the new Syspro Replica environment into the existing legacy reporting environment. This interim solution is required so that existing operational, financial, SSRS, Vivid, Excel, and Power BI reports continue to function during the plant-by-plant ERP transition.
This role will provide technical leadership and oversee the work of other data specialists, coordinate with internal resources and external implementation partners, and ensure the solution is reliable, scalable, well-documented, and aligned with Sunrise Farms’ needs.
Over time, this role will work with our implementation partner on our future state Snowflake-based Medallion Architecture.
High-performing contractors will be considered for future full-time opportunities as Sunrise Farms establishes its internal Data Management team.
Key Responsibilities:
- Solution Design & Technical Leadership
-
Establish development standards for ELT/ETL pipelines, SQL logic, reconciliation, monitoring, error handling, and documentation.
-
Review and approve design decisions, technical specifications, and development outputs from junior resources, internal team members, and external implementation partners.
- Data Pipeline Development & Oversight
- Reporting Continuity & Data Quality
-
Ensure compatibility with existing operational, financial, SSRS, Vivid, and Power BI reporting environments, as outlined in the deck.
-
Oversee Product, Customer, Supplier, and Company mapping logic between legacy and new Syspro environments, which is called out directly in the deck’s data management responsibilities.
-
Ensure master data cross-reference and mapping frameworks are properly designed, documented, tested, and supportable.
- Infrastructure, Connectivity & Production Readiness
-
Coordinate issue resolution across Business Systems, Infrastructure, Data Foundations, ERP stakeholders, and implementation partners.
- Partner, Team & Resource Oversight
- Documentation, Governance & Future-State Readiness
-
Ensure complete documentation of data flows, business rules, transformation logic, mapping structures, and technical design.
-
Oversee creation of technical design documents, support guides, runbooks, and operational documentation, all of which are specifically referenced in the deck.
Required Qualifications
-
7+ years of experience in SQL Server development, data integration, data engineering, business intelligence, or related technical roles.
-
Experience leading or overseeing technical resources, developers, consultants, or implementation partners.
-
Strong hands-on experience with SQL Server, T-SQL, stored procedures, views, indexing, and performance tuning.
Preferred Qualifications
Key Deliverables
The Senior Data Integration Lead will be accountable for ensuring delivery of:
\n\n
$75 - $90 an hour
#INDHP
\n
