Develop/Modify the architecture for the EDW, including data models, data quality standards, data integration strategies, data migration and data warehousing technologies
Collaborate with business stakeholders to understand their data needs, identify key performance indicators (KPIs), and translate them into data warehouse requirements
Design and implementation of ETL processes to extract data from various source systems, transform it into a consistent format, and load it into the EDW through Databricks
Monitor and optimize the performance of the EDW to ensure efficient data access and query response times
Provide technical guidance on data warehouse technologies, tools, and best practices to the relevant stakeholders
Work closely with business users, data analysts, and application developers to understand their data needs and deliver data-driven insights

Requirements

10+ years of experience as Datawarehouse Data Engineer
Deep understanding of data warehousing concepts, architectures, and technologies like dimensional modeling, star schema, Databricks schema, and ETL processes
Proficient in SQL's and Databricks
Familiarity with data integration tools for ETL development and data cleansing
Excellent communication skills to effectively collaborate with stakeholders from various departments

Benefits

Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade
Company paid holidays
Personal Days
Sick Leave
Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
Life and disability insurance
Employee assistance programs
Other benefits as provided by local policy and eligibility

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data warehousingETL processesdimensional modelingstar schemaSQLdata integrationdata cleansingdata migrationdata quality standardsdata models

Soft Skills

communicationcollaboration