GCP Data Engineer - feelance

Lingaro; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

Lingaro in the United States is seeking a Data Engineer to design, model and develop a complete GCP data ecosystem for a client, including Cloud Storage, Cloud Functions and BigQuery.

You will gather and document requirements, interact with clients, build scalable data pipelines, and optimize storage architectures such as data lakes and warehouses. The role emphasizes collaboration in a multinational environment and mentoring teammates.

Qualifications

• At least 4 years of experience as a Data Engineer with GCP cloud-based infrastructure.
• Deep knowledge of Google Cloud Platform services.
• Experience building data pipelines in the cloud ingesting data from databases, APIs, or streaming platforms.
• Proficiency in SQL and Python; able to design and manage databases for performance.
• Experience with DBT, Dataform and modern data transformation tools.
• Knowledge of Airflow as orchestration tool.
• Experience with ETL/ELT and data integration from multiple sources.
• Open to learn new technologies; experience in multinational distributed teams.

Responsibilities

• Design, model and develop the GCP data ecosystem for a client (Cloud Storage, Cloud Functions, BigQuery).
• Gather, analyze, model, and document business and technical requirements; direct client contact.
• Model data from various sources; troubleshoot complex issues to deliver new features.
• Design and optimize data storage architectures (data lakes/warehouses); implement partitioning, compression, indexing; optimize retrieval.
• Identify and resolve data processing, storage, or infrastructure issues; monitor performance and perform root-cause analysis.
• Train and mentor junior data engineers.

Skills

GCP

BigQuery

SQL

Python

Airflow

DBT

Data Modeling

ETL/ELT

Data Warehouses

Data Visualization

Git

Jira

Confluence

Distributed teams

Tools

Talend

Alteryx

Databricks

Looker

Power BI

Tableau

Azure

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

Tasks

• Design, model and development of whole GCP data ecosystem for one of our Client’s (Cloud Storage, Cloud Functions, BigQuery).
• Gathering, analyzing, modelling, and documenting business/technical requirements. 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.

Requirements

Must have:

• At least 4 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.
• Tools knowledge: Git, Jira, Confluence, etc.
• Open to learn new technologies and solutions.
• Experience in multinational environment and distributed teams.

Good to have:

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