Technology Consultant

TELUS Digital Philippines; Pasig; On-site; PHP 669,600 - 1,004,400; Full time

Job summary

A technology services provider in Metro Manila is looking for a talented Google BigQuery Data Engineer to join their data engineering team. The ideal candidate should have strong experience with Google BigQuery, including complex SQL and data modeling. Responsibilities include developing scalable data architectures, optimizing SQL queries, and collaborating closely with stakeholders to deliver insightful data solutions. Knowledge of Looker and workflow automation tools will be considered a strong advantage.

Qualifications

• Extensive experience with Google BigQuery and complex SQL.
• Strong understanding of data warehousing concepts and best practices.
• Proficient in developing and managing nested and partitioned tables.

Responsibilities

• Develop and manage tables in Google BigQuery for scalable data architecture.
• Collaborate with data engineers and analysts to maintain data pipelines.
• Optimize SQL queries and workflows for performance and cost efficiency.

Skills

Google BigQuery

SQL optimization

Data modeling

Looker

Workflow automation

Data governance

Tools

Looker

GCP

Job 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.