Data Architect - Wish Farms

Data Architect

Position: Full time

Location: Plant City, FL

Wish Farms, founded in 1922, is a third-generation family owned business based in Plant City, Florida. We are one of the largest growers, shippers and marketers of berries in the United States. With farms and growers spanning from the Americas and throughout Canada, we supply strawberries, blueberries, raspberries and blackberries to our retail partners, primarily based in the Southeastern U.S. As we continue a path of growth, we strive to keep a strong focus on our core values: Quality, Integrity and Responsiveness. We have a career opportunity available for a talented and motivated individual to join our team as full-time data-focused team member that will be responsible for design, development, & implementation of the enterprise data stack.

Our goal is to provide a unified platform and vision to the business allowing for both operational and analytic reporting.  This position will work closely with the business analysts to determine what data to provide their presentation methods to best support the business inquiries.  The first phase of our data warehouse was completed and consists of financially related datasets and their corresponding Power BI visuals.  In the next phase, continuing to combine data for sales, quality control, & inventory to the financial data will be the main focal points.  Subsequent phases will focus on new analytics/insights and less on replacement of current reporting in the environment.  We are looking for an individual that enjoys the opportunity to investigate data structures provided by 3rd party vendors, while laying the groundwork for how it fits into the future state of the data warehouse.

Our environment contains a set of Oracle databases for our ERP system, several cloud-based sources, and the Microsoft stack for reporting and analytics.  Experience in having administered SQL server databases and permissions, in addition to having created and maintained ETL via the Microsoft stack is required.  Having previous experience in data modeling is also required, as this role will be primarily responsible for the design and future phases of the data warehouse.

This individual will report directly to the Director of Information Systems and will be interacting as a core contributor in the data and analytics team.  Due to the anticipated amount of collaboration, we are hoping to fill this position via a candidate local to our corporate office in Plant City, Florida but are open for remote candidates that are a great fit.  Our team is small, but has a wide range of experience throughout the different aspects that comprise the data sphere.  We’re willing to share and learn with each other and that is an integral component of working together as a team.

Anticipated Day to Day Duties

  • Function as a pivotal role of supporting the business analysts on our data and analytics team to ensure that they have scalable and sustainable data models to provide visuals and insights to the business.
  • Determine new data sets and transformations required to supplement existing data to provide analytic value and provide business insight.
  • Examine and expand existing data sets for additional useful data to meet business needs.
  • Participate in the transition and unification of the reporting platform by designing and implementing new enterprise data structures.
  • Generate documentation for any data processes and models designed.
  • Provide post-deployment troubleshooting for ETL.
  • Perform light MS SQL Server administration duties (logins/permissions, roles, object deployment, etc.)

Required Qualifications

  • 4+ years of previous data modelling or equivalent analyst experience.
  • 6+ years of previous experience in the Microsoft BI stack.

Preferred Qualifications

  • Bachelor’s degree or higher
  • 5+ years of analyst experience in agriculture, transportation, warehousing, or retail.

Required Skills

  • SQL Server (Standard, 2014+)
    • T-SQL
  • SQL Server Integration Services and/or ETL tools
  • SQL Server Analysis Services
  • Data Warehousing (Kimball) / Data Modeling
  • Usage of Source Control (TFS, Git, Subversion, etc.)
  • Ability to communicate effectively with both technical and business-oriented users.
  • Effective problem solving
  • Analytical thinking

Preferred Additional Skills

  • Oracle (12c+ Enterprise)
    • PL/SQL
  • Reporting design tools (Visual Studio & Power BI Desktop)
  • M
  • R / Python
  • DAX
  • Azure SQL Database
  • Office Suite

Apply Now

  • Hidden
  • Upload resume max 5mb (if applicable)
    Max. file size: 5 MB.
  • This field is for validation purposes and should be left unchanged.