Moon Valley Nurseries · 1 day ago
Retail Data Engineer
Scottsdale, AZ
Full-time
Onsite
Mid Level
$60K/yr - $110K/yr
3+ years expMoon Valley Nurseries is the largest grower of box trees and palms in North America, and is seeking a Retail Data Engineer to support their data integration and ETL initiatives. The role involves designing and developing SSIS packages, implementing data warehouse structures, and collaborating with stakeholders to ensure robust data solutions.
Retail
Responsibilities
Design and develop SSIS packages for both orchestration and complete ETL workflows
Implement SCD2 logic for maintaining historical data accuracy
Build and optimize star schema data warehouse structures
Requirements Analysis: Review and analyze technical requirements documents, identifying gaps and potential implementation challenges
Technical Consultation: Ask thoughtful, probing questions about data sources, business rules, and technical constraints to ensure robust implementation
Project Management: Use Jira for task tracking, sprint planning, and progress reporting
Version Control: Manage code using GitHub, including branching strategies, pull requests, and collaborative development
Optimize SQL queries and SSIS packages for performance
Document technical specifications and data lineage
Troubleshoot and resolve data integration issues
Collaborate with business stakeholders to understand data requirements
Qualification
Required
Minimum 3 years of hands-on SSIS development experience
Proven track record with large-scale data warehouse implementations
Point of Sale (POS) data experience: Familiarity with retail transaction data, sales reporting, and POS system integrations
Experience with SQL Server 2016 and later
Deep technical knowledge of SCD2 and star schema design: Ability to discuss implementation strategies, trade-offs, and best practices in detail
GitHub proficiency: Experience with Git workflows, branching, merging, and collaborative development
Jira experience: Comfortable with agile project management, sprint planning, and issue tracking
Requirements analysis skills: Demonstrated ability to review technical documentation and ask clarifying questions
Independent problem-solving: Ability to work autonomously while knowing when to escalate or seek guidance
Advanced SSIS Development: Proficient in designing, developing, and maintaining complex SSIS packages
Experience using SSIS as an orchestration tool to coordinate data workflows and manage dependencies between processes
Capable of implementing end-to-end ETL processes entirely within SSIS, including error handling, logging, and performance optimization
Experience with SSIS catalog deployment, environment configurations, and parameter management
Advanced SQL Development: Complex query writing incl stored procedures
Expertise in transforming and preparing data at the database level using T-SQL
Understanding of normalized and denormalized database structures
Hands-on experience implementing and maintaining SCD2 patterns for historical data tracking
Proven experience designing and implementing star schema data warehouses, including fact and dimension table relationships
Design and develop SSIS packages for both orchestration and complete ETL workflows
Implement SCD2 logic for maintaining historical data accuracy
Build and optimize star schema data warehouse structures
Review and analyze technical requirements documents, identifying gaps and potential implementation challenges
Ask thoughtful, probing questions about data sources, business rules, and technical constraints to ensure robust implementation
Use Jira for task tracking, sprint planning, and progress reporting
Manage code using GitHub, including branching strategies, pull requests, and collaborative development
Optimize SQL queries and SSIS packages for performance
Document technical specifications and data lineage
Troubleshoot and resolve data integration issues
Collaborate with business stakeholders to understand data requirements
Preferred
HubSpot integration experience: Knowledge of HubSpot APIs, data models, and ETL patterns for CRM data integration
Python experience: Familiarity with Python for data processing, automation, or integration tasks
Experience with SQL Server Reporting Services (SSRS)
Familiarity with data governance and metadata management
Understanding of Agile development methodologies
Experience with retail or transaction-heavy industries
Knowledge of data quality frameworks and validation techniques
Benefits
Medical insurance
401(k)
Holidays
PTO
Company
Moon Valley Nurseries
Moon Valley Nurseries is a retail company that provides trees, palms and shrubs.
1001-5000 employees
Funding
Current Stage
Late StageTotal Funding
$775MKey Investors
Stonecourt Capital
2021-10-14Private Equity· $775M
2021-10-14Debt Financing
Leadership Team
Brian Flood
Chief Executive Officer
Joseph Dougherty
EVP, Special Counsel to the CEO
Recent News
2025-10-01
2025-04-15
The Business Journals
2024-04-09
Company data provided by crunchbase