FreshRealm - CONNECTING THROUGH MEALS
At FreshRealm we aspire to be THE fresh meal company. Fresh meals are our focus, and we are passionate about revolutionizing this rapidly growing category.
FreshRealm develops, sources, commercializes and assembles fresh meals. Fresh meals, including meal kits, ready-to-heat and ready-to-cook offerings are 100% our focus. We partner with leading Grocery, Convenience and Omni channel retailers to deliver the very best meals to their customers. Our success is measured by the success of our retail partners. Service, quality and consistency are our obsession, and we take pride in every meal that our customers place on their shelves.
At FreshRealm meals are more than a source of nutrition, they are our passion. Meals are the heart of a timeless ritual of sitting down to connect with family, friends, and ourselves. We are proud to play a small part in the ritual of “connecting us through meals.”
If you are a leader looking to build the future of fresh meals, you are growth minded and thrive in an entrepreneurial environment, or you are excited to work with the country’s largest retailers, go to market with the best in product quality and work with industry leaders that care for each other and their communities, FreshRealm is the perfect fit for you.
Overview
As a Data Engineer at Fresh Realm, you will play a crucial role in developing and maintaining our data architecture, pipelines, and databases. Your work will directly impact our ability to analyze trends, optimize operations, and enhance customer experiences. You'll collaborate with cross-functional teams to support data-driven decision-making, ensuring the integrity, accessibility and scalability of our data systems.
Key Responsibilities:
- Data Integration and ETL: Design, implement, and optimize data pipelines preferably using Microsoft ETL tools (e.g., Azure Data Factory, SQL Server Integration Services) to ensure efficient data extraction, transformation, and loading processes
- Extract and integrate data from diverse sources, including ERP systems, CRM databases, and other enterprise applications, to ensure comprehensive data availability for analytics and reporting purposes
- Data Modeling: Create and maintain data models, ensuring data is organized, structured, and easily accessible for reporting and analytics
- Data Warehousing: Manage and enhance our data warehouse using Microsoft Synapse (formerly Azure SQL Data Warehouse) to provide scalable and high-performance data storage solutions
- Dashboard Development: Develop interactive and insightful dashboards and reports using Power BI to enable data visualization and self-service analytics
- Performance Tuning: Monitor and optimize database and ETL processes for maximum efficiency and performance
- Data Quality Assurance: Implement data quality checks, validation rules, and data profiling to maintain data accuracy and integrity
- Documentation: Create detailed documentation for data engineering processes, data models, and ETL workflows
- Collaboration: Collaborate with cross-functional teams, including data scientists, analysts, and business stakeholders, to understand their data requirements and deliver solutions accordingly
Qualifications:
- Bachelor's or Master's degree in Computer Science, Data Engineering, or a related field
- Proven experience as a Data Engineer with a focus on Microsoft BI Stack, Synapse, and Power BI (minimum 3 years of full-time experience using the tools)
- Strong proficiency in Microsoft ETL tools such as Azure Data Factory and SQL Server Integration Services
- In-depth knowledge of Microsoft Synapse or Data Fabric and data warehousing concepts
- Proficiency in creating interactive dashboards and reports using Power BI
- Strong SQL and T-SQL skills for data manipulation and querying
- Experience with data modeling and database design
- Familiarity with data quality assurance practices
- Excellent problem-solving skills and attention to detail
- Strong communication and collaboration skills
- Ability to work in a fast-paced, dynamic environment
Preferred Qualifications:
- Microsoft Certified: Azure Data Engineer Associate certification
- Knowledge of accounting, supply chain or manufacturing
Key Competencies
- Learning Agility - Has a willingness and ability to learn from experience, and subsequently apply that learning to perform successfully under new or first-time conditions.
- Drive for Results - Can be counted on to deliver on what is required to advance the company; takes ownership of work from start to 100% finished work, brings others along with focused intensity
- Functional Skills - Possesses top level relevant, usable, experience and knowledge with the ability to establish themself as the best performer in the industry, at their role and level
- Courage - Prioritizes actions and decisions that move the company forward without hesitation around moments of uncomfortableness; laser focused on the tasks at hand that makes any conflict that could get in the way of that an afterthought
- Thoughtful - In-charge of the room, establishes clear directions in all forms of communication, inclusive, motivates, and in service to others
- Business Athlete - Understands and can execute on and expand FreshRealm's competitive edge strategies, knowledgeable about current and future industry dynamics, knows the competition, winner
PHYSICAL REQUIREMENTS/WORK ENVIRONMENT/WORK CONDITIONS
Working Conditions: Fully remote
Covid-19 protocols are consistent with State Regulations