Data Integration Developer (12-Month Hourly Contract)
About The Position
Sunrise Farms is seeking a Data Integration Developer for a 12-month hourly contract position as part of the Reset & Restart (R&R) Program. This program is a large-scale digital transformation initiative involving the implementation of a new Syspro ERP and other enterprise solutions. The role will support the Data Foundations Project Team by developing, testing, documenting, and supporting an interim data integration solution. This solution will load data from the new Syspro Replica environment into the legacy SQL reporting environment. The position will report to the Senior Data Integration Lead and the Data Foundations Project Manager. Responsibilities include building ELT/ETL pipelines, SQL logic, mapping tables, validation reports, and documentation to ensure reporting continuity during the Syspro ERP rollout. The role will also involve working with an implementation partner on a future state Snowflake-based Medallion Architecture, supporting Power BI report development, and other business systems analysis activities related to R&R. High-performing candidates may be considered for a permanent position on the future data management team.
Requirements
- 3–5+ years of SQL Server development, data integration, BI development, or business systems analysis experience.
- Strong SQL Server and T-SQL skills.
- Experience developing or supporting ETL/ELT processes.
- Experience with stored procedures, views, indexing, and query performance tuning.
- Experience with data integration and enterprise reporting platforms.
- Understanding of data modeling and master data management principles.
- Experience troubleshooting data quality and reconciliation issues.
- Ability to work with cross-functional business and technical stakeholders.
- Strong documentation, analytical, and problem-solving skills.
Nice To Haves
- Syspro ERP experience.
- Experience with ERP migration projects.
- Experience in manufacturing, distribution, or food processing operations.
- Exposure to Azure data services, Snowflake, Fivetran, and Power BI.
- Understanding of Medallion Architecture, including Bronze, Silver, and Gold layers.
- Experience supporting operational, financial, or manufacturing reporting.
- Experience with data validation, reconciliation reporting, and business stakeholder support.
Responsibilities
- Develop data pipelines to extract data from the Syspro Replica SQL Server environment and load it into the legacy SQL Server Data Warehouse.
- Build and maintain ETL/ELT processes for incremental and near real-time data synchronization.
- Develop SQL transformation logic, cross-reference tables, and mapping frameworks.
- Support updates to legacy stored procedures, views, and reporting structures to support new Syspro data.
- Assist with pipeline testing, troubleshooting, performance tuning, and refresh validation.
- Support Product, Customer, Supplier, and Company mapping logic between legacy and new Syspro environments.
- Build and maintain data validation and reconciliation processes.
- Investigate data discrepancies and support issue resolution.
- Maintain data integrity and auditing capabilities across environments.
- Support historical data consolidation requirements.
- Help ensure compatibility with existing operational, financial, SSRS, Vivid, and Power BI reporting environments.
- Update or build Power BI reports and dashboards as required.
- Support reporting validation during ERP rollout activities.
- Work with stakeholders to understand reporting issues, data gaps, and enhancement requests.
- Assist with future-state report/KPI analysis and documentation.
- Work with Infrastructure and senior technical resources to support secure connectivity between Azure-hosted Replica environments and on-premises legacy environments.
- Help design and maintain monitoring and error-handling mechanisms.
- Support optimization of pipeline performance and refresh frequencies to meet business reporting requirements.
- Assist with issue tracking, defect resolution, and operational support during plant go-lives.
- Document data flows, business rules, transformation logic, and mapping structures.
- Create or maintain technical documentation, support guides, runbooks, and operational procedures.
- Capture business logic currently implemented in the legacy SQL reporting environment to support future Snowflake Bronze, Silver, and Gold layer design.
- Assist with requirements gathering, process documentation, testing support, and stakeholder follow-up.
- Support UAT, data validation, and reporting cutover activities as required.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
