Data Warehouse Engineer

Overview

Our story began in 1903, and since then, we’ve been a food company powered by deep values, a family atmosphere, and our very own kind of entrepreneurial spirit. Today we’re a company filled with fresh energy. We are going places in the grocery business at full speed, and we’re looking for amazing people to join us on this exciting journey.

Who You Are:

We are seeking a highly motivated and experienced Data Warehouse Engineer with over 6 years of proven expertise in designing and implementing cutting-edge data solutions. This role requires a deep understanding of data engineering principles and a proficiency in leveraging advanced technologies such as Azure Databricks, Azure Synapse, Microsoft Fabric, and Data Factory. The ideal candidate will excel in optimizing data pipelines, ensuring data quality and governance, and driving innovation in data architecture.

You are someone who has researched our Company and knows that we are a retail food company, Fresh St Market & IGA. Your attraction to our brand and helping us build Georgia Main Food Group is the talent we want to join our growing Information Technology Department.

Duties and Responsibilities

• Lead the design and development of robust data pipelines using Azure Databricks, Azure Synapse, and Data Factory to ingest, store, and process data from diverse sources.
• Implement and maintain advanced data quality and governance processes, leveraging technologies like Databricks Delta Lake and Synapse SQL to ensure data integrity and compliance.
• Drive the migration of existing data marts from on-premises SQL Server to Data Lake, optimizing data warehouse performance and scalability through Synapse SQL and Synapse Spark.
• Collaborate with cross-functional teams to integrate data from various sources, including SQL Server, CSV files, Dynamics 365 FO data, utilizing Databricks connectors and Data Factory.
• Perform comprehensive data cleansing, transformation, and enrichment using Databricks Spark and Databricks SQL, ensuring high data quality and reliability.
• Develop and maintain executive dashboards and reports using Power BI and SSRS to monitor and communicate business performance across various departments including finance, operations, merchandise, and marketing.
• Additional duties as requested

Required Skills, Experience, and Education:

• Bachelor’s degree in Computer Science, or a related field.
• Extensive experience with Azure Data Lake, SQL Server, and Databricks.
• Strong analytical and problem-solving skills, with a track record of solving complex data engineering challenges.
• Microsoft Azure certifications related to data analytics or business intelligence are highly desirable.
• Proven ability to work in a fast-paced, dynamic environment and adapt to evolving business needs.
• Excellent communication and collaboration skills, with the ability to effectively convey technical concepts to non-technical stakeholders.

Why Georgia Main Food Group:

• Competitive compensation, benefits, and perks
• Fantastic career growth opportunity
• Amazing office, location, and work environment
• All the fresh coffee (and tea) you desire!

We would like to thank you in advance for sharing your interest in Georgia Main Food Group and would like to note that only those selected for an interview will be contacted.

Upon hire, new employees will be placed in a starting salary between the minimum and P50 (midpoint) of the salary range. The P50 of the range represents an employee that possesses full job knowledge, qualifications, and experience for the position. In some circumstances, the new employee may be eligible for compensation beyond the P50 of the salary range. Factors that influence this decision include full job knowledge, qualifications, internal equity, and experience in a similar role.

We look forward to discussing the specific compensation details relevant to this role with candidates who are selected to move forward in the recruitment process.

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, colour, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment.

#INDGM

Job Type:

Full-time

Pay:

$100,000.00-$120,000.00 per year

Benefits:

• Dental care
• Employee assistance program
• Extended health care
• On-site parking
• Store discount
• Vision care

Ability to commute/relocate:

• Burnaby, BC V5C 6G9: reliably commute or plan to relocate before starting work (required)

Education:

• Bachelor's Degree (required)

Experience:

• Data warehouse: 4 years (required)

Work Location:

In person