Description
We are seeking a talented Google BigQuery Data Engineer to join our data engineering team. The ideal candidate will have extensive experience working with Google BigQuery, developing complex data models, optimizing SQL queries, creating efficient workflows as well as visualizations. Experience with Looker development will be considered a strong advantage.
- Required Skills:
- Develop and manage nested and partitioned tables in Google BigQuery to support scalable data architecture.
- Design and implement efficient data models that optimize storage, query performance, and data retrieval.
- Write, optimize, and maintain complex SQL queries and procedures in BigQuery.
- Ensure that all queries and data transformations are optimized for performance and cost efficiency.
- Develop and maintain views to support analytics and reporting needs.
- Working experience with any data visualization tool like Looker
- Work with stakeholders to develop and optimize reports and dashboards, ensuring data accuracy and timeliness.
- Design and implement data workflows using BigQuery and other GCP tools to automate data processing and ETL tasks.
- Collaborate with data engineers and analysts to create and maintain robust data pipelines.
- Ensure the reliability and scalability of workflows, making adjustments as needed to improve performance.
- Collaborate with BI teams to integrate BigQuery data into reporting platforms like Looker.
- Implement and maintain data quality checks and validation processes within BigQuery workflows.
- Ensure that data is secure, compliant, and follows best practices for data governance.
- Work closely with data analysts, data scientists, and other stakeholders to understand their data needs and deliver solutions.
- Communicate technical details to non-technical stakeholders, ensuring they understand the impact of data developments.
- Participate in code reviews, documentation, and knowledge-sharing sessions to improve team practices.
- Qualifications:
- Strong experience with Google BigQuery, including complex SQL, table partitioning, and query optimization.
- Experience in creating and managing nested and partitioned tables in BigQuery.
- Proficient in developing and maintaining views, stored procedures, and data models.
- Hands-on experience with workflow automation tools and techniques in the Google Cloud Platform (GCP) ecosystem.
- Strong understanding of data warehousing concepts and best practices.
- Excellent problem-solving skills with a focus on performance optimization and scalability.
- Strong communication skills with the ability to work effectively with both technical and non-technical stakeholders.
- Experience with Looker and LookML development will be a strong added advantage.
- Willing to work EST day Shift.
About Company
TELUS Digital is the customer experience transformation partner to the world's most admired brands. Our diverse team weaves data, technology, and human ingenuity to deliver differentiated customer journeys, drive operational effectiveness, and scale AI solutions with meaningful value and positive impact.
We craft real-world solutions in the moments that matter, from customer acquisition to lifelong loyalty. Enabled by our global reach - spanning 78,000 experts in 33 countries - and deep industry expertise, we help over 600 organizations make the customer experience feel effortless.
Our solutions span Data & AI, Digital Experience & IT, CX Management and Trust & Safety. At the core of our innovation is Fuel iX, an enterprise-grade generative AI platform that helps clients safely access and optimize leading LLMs to scale their own AI from pilot to production.
Equal Opportunity Employer Statement
At TELUS Digital, we are proud to be an equal opportunity employer and are committed to creating a diverse and inclusive workplace. All aspects of employment, including the decision to hire and promote, are based on applicant's qualifications, merits, competence and performance without regard to any characteristic related to diversity.
