Data Analytics Engineer (Looker / BigQuery / Airflow)

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

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

Description:

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

Key Must-Have Skills

• Data Engineering
• Google BigQuery (Mandatory)
• Looker / LookML (Mandatory)
• Airflow Composer / Apache Airflow
• Python
• SQL
• Semantic Layer Development
• Data Pipelines
• Dashboard & Reporting Development

Preferred

• Built a semantic layer from scratch
• Teradata experience
• Chatbot or conversational analytics experience

Education

• Bachelor s degree in computer science or related degree

AgreeYa is a global systems integrator delivering competitive advantage for its customers through software, solutions, and services. Established in 1999, AgreeYa is headquartered in Folsom, California, with a global footprint and a team of more than 2,200 staff across offices. AgreeYa works with 500 organizations ranging from Fortune 100 firms to small and large businesses across industries such as Telecom, Banking, Financial Services & Insurance, Healthcare, Utility & Energy, Technology, Public sector, Pharma & Biotech, and others. Please visit us at for more information.

AgreeYa is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, gender identity, sexual orientation, national origin, disability, veteran status or other protected characteristics. Visit our website to learn about our Career & Culture.