GCP Data Engineer- Lead Consultant

Lingaro Group; India; Hybrid; INR 2,000,000 - 4,200,000; Full time

Benefits offered by this job

Office as an option

Udemy learning platform

Certificate training programs

Upskilling support

Multinational environment

Flexible hours

Job summary

You will work in a multinational, distributed team with flexible remote/office options, contributing to scalable data solutions, and adopting modern transformation tools like DBT/Dataform.

Qualifications

• 7+ years as a Data Engineer on GCP.
• Deep knowledge of Google Cloud Platform services.
• Extensive experience designing and deploying cloud data pipelines.
• Proficient in SQL and Python.
• Experience with Airflow and ETL/ELT workflows.
• Data modeling, indexing, and performance tuning.
• Familiarity with DBT/Dataform and modern transformation tools.
• Strong communication for client interactions.
• Experience in distributed multinational teams.

Responsibilities

• Design, model and develop the GCP data ecosystem (Cloud Storage, Cloud Functions, BigQuery).
• Gather, analyze, model and document requirements; liaise with clients.
• Model data from multiple sources; troubleshoot high-impact issues.
• Design and optimize data storage (data lakes/warehouses) and caching.
• Identify bottlenecks; tune queries; ensure reliable data ops.
• Monitor performance and perform root-cause analysis.
• Train and mentor junior data engineers.

Skills

GCP cloud

BigQuery

SQL

Python

NoSQL

Airflow

ETL/ELT

Data modeling

Data pipelines

DBT

Tools

Looker

Power BI

Tableau

Talend

Alteryx

Databricks

Azure

BigQuery

Apache Spark

Job description

Growth through diversity, equity, and inclusion. As an ethical business, we do what is right — including ensuring equal opportunities and fostering a safe, respectful workplace for each of us. We believe diversity fuels both personal and business growth. We're committed to building an inclusive community where all our people thrive regardless of their backgrounds, identities, or other personal characteristics.

Data engineering involves the development of solutions for the collection, transformation, storage and management of data to support data-driven decision making and enable efficient data analysis by end users. It focuses on the technical aspects of data processing, integration, and delivery to ensure that data is accurate, reliable, and accessible in a timely manner. It also focuses on the scalability, cost-effectiveness, security, and supportability of the solution. Data engineering encompasses multiple toolsets and architectural concepts across on-premises and cloud stacks, including but not limited to data warehousing, data lakes, lake house, data mesh, and includes extraction, ingestion, and synchronization of structured and unstructured data across the data ecosystem. It also includes processing organization and orchestration, as well as performance optimization of data processing.

Tasks:

• You will be a part of the team accountable for design, model and development of whole GCP data ecosystem for one of our Client’s (Cloud Storage, Cloud Functions, BigQuery).
• Involvement throughout the whole process starting with the gathering, analyzing, modelling, and documenting business/technical requirements will be needed. The role will include direct contact with clients.
• Modelling the data from various sources and technologies. Troubleshooting and supporting the most complex and high impact problems, to deliver new features and functionalities.
• Designing and optimizing data storage architectures, including data lakes, data warehouses, or distributed file systems. Implementing techniques like partitioning, compression, or indexing to optimize data storage and retrieval. Identifying and resolving bottlenecks, tuning queries, and implementing caching strategies to enhance data retrieval speed and overall system efficiency.
• Identifying and resolving issues related to data processing, storage, or infrastructure. Monitoring system performance, identifying anomalies, and conducting root cause analysis to ensure smooth and uninterrupted data operations.
• Train and mentor less experienced data engineers, providing guidance and knowledge transfer.

What We're Looking For:

• At least 7+ years of experience as a Data Engineer working with GCP cloud-based infrastructure & systems.
• Deep knowledge of Google Cloud Platform and cloud computing services.
• Extensive experience in design, build, and deploy data pipelines in the cloud, to ingest data from various sources like databases, APIs or streaming platforms.
• Proficient in database management systems such as SQL (Big Query is a must), NoSQL. Candidate should be able to design, configure, and manage databases to ensure optimal performance and reliability.
• Programming skills (SQL, Python, other scripting).
• Proficient in data modeling techniques and database optimization. Knowledge of query optimization, indexing, and performance tuning is necessary for efficient data retrieval and processing.
• Knowledge of at least one orchestration and scheduling tool (Airflow is a must).
• Experience with data integration tools and techniques, such as ETL and ELT Candidate should be able to integrate data from multiple sources and transform it into a format that is suitable for analysis.
• Knowledge of modern data transformation tools (such as DBT, Dataform).
• Excellent communication skills to effectively collaborate with cross-functional teams, including data scientists, analysts, and business stakeholders. Ability to convey technical concepts to non-technical stakeholders in a clear and concise manner.
• Ability to actively participate/lead discussions with clients to identify and assess concrete and ambitious avenues for improvement.
• Open to learn new technologies and solutions.
• Experience in multinational environment and distributed teams.

What Will Set You Apart:

• Certifications in big data technologies or/and cloud platforms.
• Experience with BI solutions (e.g. Looker, Power BI, Tableau).
• Experience with ETL tools: e.g. Talend, Alteryx
• Experience with Apache Spark, especially in GCP environment.
• Experience with Databricks.
• Experience with Azure cloud-based infrastructure & systems.

Missing one or two of these qualifications? We still want to hear from you! If you bring a positive mindset, we'll provide an environment where you feel valued and empowered to learn and grow.

We offer:

• Stable employment. On the market since 2008, 1800+ talents currently on board in 7 global sites.
• “Office as an option” model. You can choose to work remotely or in the office, depending on your location.
• Flexibility regarding working hours and your preferred form of contract.
• Comprehensive online onboarding program with a “Buddy” from day 1.
• Cooperation with top-tier engineers and experts.
• Possibility of access to the Udemy learning platform.
• Certificate training programs. Lingarians earn 500+ technology certificates yearly.
• Upskilling support. Capability development programs, Competency Centers, knowledge sharing sessions, community webinars, 110+ training opportunities yearly.
• Internal Gallup Certified Strengths Coach to support your growth.
• Grow as we grow as a company. 76% of our managers are internal promotions.
• A diverse, inclusive, and values-driven community.
• Autonomy to choose the way you work. We trust your ideas.
• Create our community together. Refer your friends to receive bonuses.
• Activities to support your well-being and health.
• Plenty of opportunities to donate to charities and support the environment.
• Modern office equipment. Purchased for you or available to borrow, depending on your location.