You're using an older version of Internet Explorer that is no longer supported. Please update your browser.

Data Warehouse / ETL Engineer

Calgary, AB
Full Time
4 days ago

Join our team

The Data Operations team within the Reliability Center of Excellence delivers analytics, technical expertise, reporting, process improvements and project support to improve quality and reliability for TELUS's network and services. We are a multi-skilled team that supports internal customers from front-line to executive levels of the organization. We are the go-to team for several business areas across the company that seek expertise, informed opinions and thought leadership that directly affect the strategy of the company.

Here's the impact you'll make and what we'll accomplish together

Solve problems by working with and making use of your passion for data, take on difficult challenges and solve them with creative solutions. If you can deal with the pressure of a fast-paced environment by keeping your cool and leveraging your network to find the answers you need that will benefit your stakeholders this might be the perfect team and role for you. At the end of the day, we are a collaborative, flexible team that enjoys helping people by providing them with the solutions they need, all while remaining level-headed, taking feedback and applying it and being effective team players who are comfortable and effective in communicating with peers and senior leadership.

Here's how
    • As a Data Warehouse Engineer, you will leverage your skills to help engineer data that provides insights on improving our service performance and enhancing our business insights for our customers; • Apply your data engineering and analytics skills to help gain insights from data • Work with stakeholders throughout the organization to identify opportunities for leveraging company data that drives business solutions • Collaborate with other teams to understand our services, technologies and processes • Operationalize insights with our stakeholders and partners • Present findings to stakeholders and partners


You're the missing piece of the puzzle:
    • You bring 5+ years of hands-on experience working with and analyzing data sets • You bring 3+ years of hands-on experience working with Business Intelligence, database • programming and delivering solutions that enable users with actionable data and analytics • You are recognized for your extensive database knowledge and experience with establishing ETL procedures and data marts across different database platforms (Microsoft SQL Server, Oracle, • GCP, AWS) • You are sought out for your understanding of dimensional modeling concepts such as: facts vs dimensions, surrogate keys and data granularity • You are respected for your proficiency with writing SQL queries for Oracle, SQL server and Hadoop • You are a SQL wizard when it comes to writing, debugging and tuning T-SQL queries, creating SQL tables, views, indexes, stored procedures and understanding relational databases and data partitioning • You are knowledgeable about data modeling and data aggregation • You are able to create data extracts that enable publishers to build dashboards or your own dashboards and understand and know how to work with Tableau calculations, LOD and Action filters • You are experienced with big data technologies (HDFS, HIVE) including querying, creating and populating data lake tables • You are comfortable developing reports and dashboards that vary in design and layout depending on the audience (executives and operational team members alike)

Great to Haves:
    • Experience with visualization reporting products such as Tableau, Python, and/or Spark • Experience with GCP analytics • Knowledge of visual analytics • Coaching and developing of junior talent • Experience in various methodologies such Scrum, Agile and Waterfall

A bit about us

Our business is connecting Canadians. Our social impact is using our world-leading technology to create meaningful change, give back to help communities thrive, and help those who need it most. When you join our team, you're helping us make the future friendly. We're committed to diversity and equitable access to employment opportunities based on ability -your unique contributions and talents will be valued and respected here.
Information Technology