Senior Data Integration Lead (12-Month Contract)

Key Responsibilities

• 1. Solution Design & Technical Leadership
• Lead the design of data pipelines to extract data from the Syspro Replica SQL Server environment and load it into our legacy SQL reporting environment.
• Define the technical approach for extracting data from the Syspro Replica environment and loading it into the legacy SQL reporting environment.
• 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.
• Ensure that the interim solution supports reporting continuity while avoiding unnecessary rework or misalignment with the future Snowflake architecture.
• 2. Data Pipeline Development & Oversight
• Design and oversee development of pipelines that extract data from the Syspro Replica environment and load it into the legacy SQL reporting environment..
• Lead development of ETL/ELT processes for incremental and near real-time data synchronization, which is specifically identified as a key responsibility in the deck.
• Guide the development of data transformation logic, cross-reference tables, and mapping frameworks.
• Oversee extension of existing legacy SQL stored procedures, views, and reporting structures to support new Syspro data.
• Ensure pipeline performance and refresh frequencies meet business reporting requirements, as identified under infrastructure and connectivity responsibilities.
• 3. Reporting Continuity & Data Quality
• Ensure compatibility with existing operational, financial, SSRS, Vivid, and Power BI reporting environments, as outlined in the deck.
• Lead the design of validation and reconciliation processes to ensure data completeness and accuracy.
• 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.
• Support historical data consolidation requirements and maintain data integrity and auditing capabilities across environments.
• 4. Infrastructure, Connectivity & Production Readiness
• Collaborate with IT Infrastructure to establish secure connectivity between Azure-hosted Replica environments and on-premises legacy SQL reporting environment.
• Define monitoring, logging, alerting, and error-handling requirements.
• Ensure the solution is production-ready, supportable, and capable of sustaining business reporting during ERP rollout.
• Identify technical risks, dependencies, design gaps, and support requirements.
• Coordinate issue resolution across Business Systems, Infrastructure, Data Foundations, ERP stakeholders, and implementation partners.
• 5. Partner, Team & Resource Oversight
• Provide day-to-day technical direction to Data Integration Developers and Data Analysts.
• Oversee work performed by internal Sunrise Farms resources and external implementation partners.
• Review partner deliverables and ensure they align with Sunrise Farms’ interim and future-state data architecture.
• Support knowledge transfer from external partners to internal resources.
• Contribute to onboarding, coaching, and future internal data team capability-building.
• 6. 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.
• Ensure business logic currently implemented in the legacy SQL reporting environment is documented to support future Snowflake Bronze, Silver, and Gold layer design.
• Support future Medallion Architecture planning by ensuring that interim work captures the business rules and mapping logic needed for Snowflake migration.
• Help define support readiness criteria for the eventual transition to Sunrise Farms’ internal Data Management team.

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.
• Strong ETL/ELT design and development experience.
• Experience designing enterprise data integration solutions.
• Experience with reporting environments and business-critical reporting continuity.
• Strong understanding of data modeling and master data management concepts.
• Experience troubleshooting data quality, reconciliation, and reporting issues.
• Ability to work effectively with cross-functional business and technical stakeholders.
• Strong communication, documentation, and problem-solving skills.
• Preferred Qualifications
• Syspro ERP experience.
• Experience with ERP migration or ERP rollout projects.
• Experience in manufacturing, distribution, food processing, or related operational environments.
• Experience with Azure data services, Snowflake, Fivetran, and Power BI exposure.
• Understanding of Medallion Architecture, including Bronze, Silver, and Gold layers.
• Experience designing data quality, reconciliation, and operational monitoring frameworks.
• Experience supporting future-state data platform or analytics modernization initiatives.

Key Deliverables