We are seeking a GCP Data Engineer with hands-on experience with Google Cloud Platform (GCP) services, particularly BigQuery, and be proficient in DBT (Data Build Tool) for data transformation and modeling. This role requires strong SQL skills, a solid understanding of data warehousing concepts, and light proficiency in Python for scripting and automation. Have understanding of CES and call transcript data.
Key Responsibilities:
Design, build, and maintain scalable data pipelines on GCP, primarily using BigQuery.
Develop and manage DBT models to transform raw data into clean, tested, and documented datasets.
Write complex and optimized SQL queries for data extraction, transformation, and analysis.
Implement and maintain data warehousing solutions, ensuring performance, scalability, and reliability.
Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and deliver high-quality solutions.
Monitor and troubleshoot data pipeline performance and data quality issues.
Automate data workflows and tasks using Python scripts where necessary.
Ensure data governance, security, and compliance standards are met.
Skills:
Designing and building data pipelines: Creating automated processes, often using ETL (Extract, Transform, Load) or ELT (Extract, Load, Transform) methodologies, to move and transform data from various sources.
Data collection and storage: Implementing systems to collect data from different sources and store it in central repositories like data warehouses or data lakes, often in the cloud.
Data processing and transformation: Converting raw data into a clean, structured, and useful format that is ready for analysis.
Ensuring data quality: Establishing processes for data validation and quality assurance to make sure the data is accurate and reliable.
Maintenance and optimization: Monitoring and maintaining the data infrastructure to ensure it runs efficiently and can handle growing data volumes.
Collaboration: Working with data scientists and business analysts to understand their requirements and ensure the data infrastructure supports their needs
The pay range that the employer in good faith reasonably expects to pay for this position is $32.36/hour - $50.56/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis.
Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.
