BigQuery Engineer

Openkyber; Alaska; Hybrid; USD 120,000 - 150,000; Full time

Job summary

AgreeYa is seeking a Data Analytics Engineer with strong data engineering skills to design and implement scalable data pipelines and semantic data layers. The role focuses on BigQuery, Looker LookML, and Airflow to deliver trusted datasets and dashboards for analytics across the organization.

You will collaborate with stakeholders, build automated data processing scripts in Python, and ensure data quality for reporting and chatbot analytics initiatives.

Qualifications

• Bachelor's degree in CS/IS/Engineering or related field with 6+ years in data engineering/BI.
• Hands-on experience with BigQuery, Looker, Airflow, Python and SQL; semantic layers preferred.
• Ability to design scalable data models and enterprise reporting solutions.
• Strong analytical, debugging, and problem-solving skills.

Responsibilities

• Design, build, and maintain scalable data pipelines using Airflow to ingest/transform/load into BigQuery.
• Develop and optimize data models to support enterprise reporting and analytics.
• Design semantic layers in Looker (LookML) for consistent metrics and governed data access.
• Build interactive dashboards/reports in Looker to support analytics and BI.
• Collaborate with stakeholders to translate requirements into scalable data solutions.
• Integrate data from multiple sources to create clean, reliable datasets for analytics.
• Write optimized SQL for large BigQuery datasets.
• Develop automation scripts with Python for data processing and ETL.
• Monitor and optimize ETL/ELT workflows for data quality and reliability.

Skills

SQL

Python

Data modeling

Semantic layers

ETL/ELT

Data warehousing concepts

Analytical thinking

Cross-functional collaboration

Education

Bachelor's degree in Computer Science, Information Systems, Engineering, or related field

Tools

Google BigQuery

Looker (LookML)

Airflow Composer

Job description

Job Title: Data Analytics Engineer (Looker / BigQuery / Airflow)

Job Location: Basking Ridge, NJ / Alpharetta, GA / Irving, TX (Hybrid | Tuesdays onsite, 4 days remote)

AgreeYa is a global Systems Integrator and is seeking an experienced Data Analytics Engineer with a strong Data Engineering background to build scalable data solutions that power analytics and reporting across the organization. This role will focus on designing and developing data pipelines, semantic layers, and data visualization solutions that support chatbot analytics and other business intelligence initiatives. The ideal candidate will have hands‑on experience with Google BigQuery, Looker (LookML), Airflow Composer, Python, and SQL , with the ability to transform raw data into trusted, business‑ready datasets. Candidates who have designed and implemented semantic layers from scratch are highly preferred.

Key Responsibilities

• Design, build, and maintain scalable data pipelines using Airflow Composer to ingest, transform, and load data into Google BigQuery .
• Develop and optimize data models that support enterprise reporting and analytics.
• Design and implement semantic layers in Looker (LookML) to provide consistent business definitions, reusable metrics, and governed data access.
• Build and maintain interactive dashboards and reports using Looker to support chatbot analytics and business performance reporting.
• Collaborate with business stakeholders, data engineers, analysts, and product teams to gather reporting requirements and translate them into scalable data solutions.
• Integrate data from multiple sources to create clean, reliable datasets for analytics and visualization.
• Write efficient and optimized SQL queries for large‑scale datasets in BigQuery.
• Develop automation and data processing scripts using Python.
• Monitor, troubleshoot, and optimize ETL/ELT workflows to ensure data quality and reliability.
• Support analytics initiatives by delivering trusted datasets, KPIs, and reporting solutions that enable data‑driven decision making.

Required Skills & Experience

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field (or equivalent experience). 6+ years of experience in Data Engineering, Analytics Engineering, or Business Intelligence.
• Strong hands‑on experience with Google BigQuery ( Required ).
• Strong hands‑on experience with Looker , including LookML and dashboard development ( Required ).
• Experience building and managing data pipelines using Airflow Composer (Apache Airflow) .
• Strong SQL skills with experience developing complex queries and optimizing large datasets.
• Strong Python programming experience for data processing, automation, and ETL development.
• Experience designing and implementing scalable data models and semantic layers.
• Experience building reporting and visualization solutions for business stakeholders.
• Strong understanding of data warehousing concepts, ETL/ELT processes, and data architecture.
• Excellent analytical, troubleshooting, and problem‑solving skills.

Preferred Skills & Experience

• Experience building a semantic layer from scratch using Looker (highly preferred).
• Experience supporting chatbot, conversational AI, customer experience, or digital analytics reporting.
• Experience integrating data from multiple enterprise data sources.
• Experience with Teradata .
• Experience working within Google Cloud Platform (Google Cloud Platform).
• Knowledge of data governance, data quality, and metadata management.
• Experience working in Agile environments and collaborating with cross‑functional teams.

Nice to Have Experience

• Experience migrating data from Teradata or other enterprise data warehouses to BigQuery.
• Familiarity with chatbot analytics, conversational data, or customer interaction reporting.
• Experience optimizing BigQuery performance and cost.
• Exposure to CI/CD practices for analytics engineering.