The Role
Lead AI/ML Engineer
Specialization
- SQL (Advanced)
- Data Modeling & Query Optimization
- BigQuery (DDL, Views, Authorized Views)
- ETL / ELT Pipeline Development Cloud & GCP Services
- Google Cloud Platform (GCP)
- BigQuery
- Google Cloud Storage (GCS)
- Dataflow
- Pub/Sub Programming & Tools
- Python (data processing, scripting)
- Java (basic understanding for data workflows)
- Apache Airflow (orchestration and scheduling)
- API Integration Visualization & Reporting
- Looker Studio (dashboard development)
- Automated reporting using SQL Roles & Responsibilities
- Design, develop, and optimize scalable data pipelines to ingest, process, and store data from Google Cloud Storage (GCS) to BigQuery.
- Build and maintain API-integrated workflows to extract data from external systems, process responses, and load results into downstream platforms.
- Implement Pub/Sub-based event-driven architectures supporting both real-time and batch data processing, including message handling and pipeline triggers.
- Create and manage BigQuery DDLs, views, and authorized views, ensuring secure access through appropriate roles and permissions.
- Optimize ETL pipelines and complex SQL queries to improve performance, reduce processing time, and enhance BigQuery warehouse efficiency.
- Perform DEV and UAT testing, validating business logic, data quality, and end-to-end pipeline stability.
- Apply business transformation logic to convert raw datasets into analytics- and reporting-ready data models.
- Develop weekly and monthly SQL-based reports and automate their distribution to business stakeholders via email.
- Design and publish interactive dashboards using Looker Studio to enable clear data visualization and actionable insights.
- Collaborate closely with clients, business analysts, and stakeholders to gather requirements and deliver accurate, efficient, and interpretable data solutions. Required Qualifications
- Bachelor’s degree in Computer Science, Engineering, or a related field.
- Strong experience in SQL and BigQuery within large-scale data environments.
- Hands-on experience with GCP services, especially BigQuery, GCS, Dataflow, and Pub/Sub.
- Proficiency in Python for data manipulation and pipeline development.
- Experience with Apache Airflow or similar orchestration tools.
- Solid understanding of data modeling, ETL best practices, and performance tuning. Good to Have
- Exposure to Java-based data processing frameworks
- Experience working in client-facing or consulting environments
- Knowledge of real-time data processing patterns and event-driven architectures
Key SkillsData Engineering & Analytics
Job requirements
- SQL (Advanced)
- Data Modeling & Query Optimization
- BigQuery (DDL, Views, Authorized Views)
- ETL / ELT Pipeline Development Cloud & GCP Services
- Google Cloud Platform (GCP)
- BigQuery
- Google Cloud Storage (GCS)
- Dataflow
- Pub/Sub Programming & Tools
- Python (data processing, scripting)
- Java (basic understanding for data workflows)
- Apache Airflow (orchestration and scheduling)
- API Integration Visualization & Reporting
- Looker Studio (dashboard development)
- Automated reporting using SQL Roles & Responsibilities
- Design, develop, and optimize scalable data pipelines to ingest, process, and store data from Google Cloud Storage (GCS) to BigQuery.
- Build and maintain API-integrated workflows to extract data from external systems, process responses, and load results into downstream platforms.
- Implement Pub/Sub-based event-driven architectures supporting both real-time and batch data processing, including message handling and pipeline triggers.
- Create and manage BigQuery DDLs, views, and authorized views, ensuring secure access through appropriate roles and permissions.
- Optimize ETL pipelines and complex SQL queries to improve performance, reduce processing time, and enhance BigQuery warehouse efficiency.
- Perform DEV and UAT testing, validating business logic, data quality, and end-to-end pipeline stability.
- Apply business transformation logic to convert raw datasets into analytics- and reporting-ready data models.
- Develop weekly and monthly SQL-based reports and automate their distribution to business stakeholders via email.
- Design and publish interactive dashboards using Looker Studio to enable clear data visualization and actionable insights.
- Collaborate closely with clients, business analysts, and stakeholders to gather requirements and deliver accurate, efficient, and interpretable data solutions. Required Qualifications
- Bachelor’s degree in Computer Science, Engineering, or a related field.
- Strong experience in SQL and BigQuery within large-scale data environments.
- Hands-on experience with GCP services, especially BigQuery, GCS, Dataflow, and Pub/Sub.
- Proficiency in Python for data manipulation and pipeline development.
- Experience with Apache Airflow or similar orchestration tools.
- Solid understanding of data modeling, ETL best practices, and performance tuning. Good to Have
- Exposure to Java-based data processing frameworks
- Experience working in client-facing or consulting environments
- Knowledge of real-time data processing patterns and event-driven architectures
Key SkillsData Engineering & Analytics
Brillio Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Brillio and has not been reviewed or approved by Brillio.
-
Healthcare Strength — Healthcare is considered comprehensive, including medical coverage for employees and dependents alongside life, disability, and accidental death protections. Feedback suggests these protections are a core strength of the package.
-
Leave & Time Off Breadth — Time-off options include paid leave and parental leave, with flexible or ‘flexible PTO’ approaches cited in some contexts. Feedback suggests this breadth helps support work-life balance when team norms permit usage.
-
Wellbeing & Lifestyle Benefits — Wellbeing offerings span counseling, financial-management sessions, fitness programs, and travel insurance, plus region-specific extras like discounted IT hardware and work-from-home essentials. Feedback suggests these add-ons enhance perceived value beyond core insurance.
Brillio Insights
Similar Jobs
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Brillio is the leader in global digital business transformation, applying technology with a human touch. We help businesses define internal and external transformation objectives, and translate those objectives into actionable market strategies using proprietary technologies. With 2600+ experts and 13 offices worldwide, Brillio is the ideal partner for enterprises that want to quickly increase their core business productivity, and achieve a competitive edge, with the latest digital solutions.
