GCP Data Engineer - feelance

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

Job summary

Lingaro is seeking a senior Data Engineer in the United States to design, build, and optimize data ecosystems on Google Cloud Platform. You will own data pipelines, collaborate with clients, and help scale data solutions across teams.

You will work on architecture for data lakes and warehouses, implement performance tuning, and mentor junior engineers while engaging with cross-functional stakeholders.

Qualifications

• 4+ years as a Data Engineer with GCP infrastructure.
• Deep knowledge of Google Cloud Platform and services.
• Experience building data pipelines ingesting from databases, APIs, and streams.
• Proficient in SQL and NoSQL; optimize DB performance.
• Python and scripting proficiency.
• Data modeling and DB optimization expertise.
• Knowledge of Airflow or similar orchestration tools.
• Experience with ETL/ELT and data integration.
• Knowledge of DBT and Dataform.
• Excellent communication for cross-functional collaboration.
• Ability to lead discussions with clients and stakeholders.
• Proficiency with Git, Jira, Confluence; open to learning.
• Experience in multinational, distributed teams.

Responsibilities

• Design, model and develop GCP data ecosystem for client.
• Gather, analyze, document requirements with client contact.
• Model data from various sources; troubleshoot high-impact issues.
• Design and optimize data storage architectures (lakes/warehouses).
• Identify and resolve data processing/storage issues; monitor performance.
• Train and mentor less experienced data engineers.

Skills

GCP expertise

BigQuery

Data pipelines

SQL

Python

Airflow

DBT

Data modeling

ETL/ELT

Git/Jira/Confluence

Education

Bachelor's degree in CS/Engineering

Tools

Looker

Power BI

Tableau

Talend

Alteryx

Databricks

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.