Manager, Data Engineering

at  Alberta Motor Association

WE ARE LOOKING FOR A forward-thinking,
forward-doing LEADER
Posted: 2025-01-28
Closing: When Filled
Location: Edmonton Kingsway (Hybrid)
You are a tech-savvy wizard who’s passionate about finding the right solutions and ensuring a smooth-running system environment. You are not afraid to pave the way for bigger and better things. We’re looking for someone to lead and coach a team of talented data engineering specialists who are responsible for collecting, sorting, processing, and analyzing huge sets of data. We are looking for someone whose primary focus will be on finding creative optimal solutions to use for these purposes, then maintaining, implementing, and monitoring them.

WHAT YOU’LL DO

• Reporting to the Director, Insurance Information Services, you will provide guidance to a team of data engineering specialists who are responsible for collecting, sorting, processing, and analyzing huge sets of data.
• Lead a team of engineers that design & implement data warehouse solutions to enhance our customer’s experience.
• Provide recommendations on big data and data warehouse strategies and tools along with detailed analysis; develop standards and processes related to data cleaning, data quality, data consolidation, data modeling, data masking, data transformations, data enrichment.
• Investigate new products, tools, and data technologies (Data Warehouse, ETL/ELT, Big Data, Data Mining) to add value to the business; ensure applications are on the right platform and that we’re in a sustainable position moving forward.
• Provide operational support for existing data warehouse environment.
• Use best practices to write well designed, testable, and efficient code.
• Develop, test, manage, schedule and document data storage operations and tasks; provide coaching and mentoring to staff with regards to data management process and practices.
• Identify technical debt/operational improvements & implement solutions.
• Meet with business partners to understand & gather requirements for strategic initiatives.
• Work in a collaborative space with a team of people.

WHAT YOU’VE DONE

• You have a university degree in computer science or computer engineering.
• You have a minimum of 8+ years’ progressive experience in data engineering or a related discipline.
• Strong proficiency with Data Warehouse technologies and concepts.
• You have experience leading, and mentoring, a team.
• You have experience with operational data stores, data warehouses/mart, data distribution, data modeling, data movement/ELT, data lineage, data cleansing, data enrichment, and data governance.
• Proficiency with Data Warehouse and ELT technologies such as: Snowflake and Qlick Replicate is preferred.
• Proficiency with data management languages and tools such as: SQL, Python, DBT, WhereScape Red, Snowpark, R, Scala is an asset.
• Experience with customer master data management is an asset.
• Proficiency in data analysis tools (Power BI, Excel Pivot Tables, Tableau) as asset.
• Experience with Agile/Scrum an asset.
• Proven track record with the Kimball Methodology, Data Vault, and Agile Methodologies.
• Practical experience with software development and data engineering practices.
• Skilled with test driven development (TDD), continuous integration and deployment.