Lead Data Engineer – Big Query

Experience

5+ Years

Job Purpose

• We are looking for an experienced Lead Data Engineer with strong expertise in Google BigQuery and working knowledge of Looker to support a data modernization engagement. The candidate will lead efforts in revamping data architecture, optimizing data pipelines, and supporting reporting needs, while mentoring an internal client developer to enable smooth transition post-engagement.

Job Description / Duties and Responsibilities

• Assess and enhance existing data models, pipelines, and architecture in BigQuery.
• Optimize data flows and storage for performance, scalability, and cost-efficiency.
• Implement best practices in data engineering and governance.
• Review and improve data collection and transformation processes.
• Ensure high-quality, consistent, and reliable data availability.
• Enhance and maintain existing reports and dashboards using Looker.
• Design and build new reports as per business requirements.
• Work with business and technical stakeholders to gather requirements.
• Translate business requirements into technical deliverables.
• Guide and mentor client’s internal developer.
• Ensure sufficient handover for long-term maintainability.

Job Specification / Skills and Competencies

• Strong experience with Google BigQuery (data modeling, query optimization)
• Proficient in building/managing data pipelines and ETL/ELT workflows
• Solid SQL skills and experience with large datasets
• Experience with Looker (creating/modifying dashboards, LookML understanding)
• Experience with version control (Git) and CI/CD for data solutions
• Ability to work in Agile environments with remote teams
• Excellent communication and interpersonal skills
• Ability to work independently in client-facing role
• 8 years total experience (5 years relevant)

Any Additional Information/Specifics

• Snowflake and ADF knowledge (good to have)
• Exposure to GCP services beyond BigQuery (Dataflow, Cloud Functions)
• Mentoring or coaching experience is a plus
• Adhere to Information Security Management policies and procedures