Cloud Data Engineer - GCP

Lemongrass Consulting; Snowflake (AZ); Remote; USD 90,000 - 150,000; Full time

Job summary

An innovative firm is seeking a skilled Cloud Data Engineer to design and maintain robust data pipelines and scalable data lakes. This role involves utilizing cloud-native ETL tools and collaborating with cross-functional teams to deliver data solutions that meet business needs. You will have the opportunity to work with cutting-edge technologies and contribute to significant projects in a fully remote environment. If you are passionate about data engineering and eager to enhance your skills while making a real impact, this position is perfect for you.

Benefits

100% remote work

Flexibility in work hours

Training budget for certifications

Access to A Cloud Guru subscription

State of the art tech

Qualifications

• 7+ years of experience as a Data Engineer or in a similar role.
• Proven experience with cloud platforms: AWS, Azure, and GCP.
• Strong programming skills in Python, Java, or Scala.

Responsibilities

• Design and develop scalable ETL pipelines using cloud-native tools.
• Architect and implement data lakes and data warehouses on cloud platforms.
• Monitor and optimize the performance of data pipelines and ETL processes.

Skills

Python

Java

Scala

SQL

Data Modeling

ETL/ELT Processes

Data Warehousing

Problem-Solving

Communication

Collaboration

Education

Bachelor’s degree in Computer Science

Advanced degrees

Tools

AWS DMS

AWS Glue

Kafka

Azure Data Factory

GCP Dataflow

Informatica

SAP Data Intelligence

Databricks

Redshift

Snowflake

BigQuery

Azure Synapse

Job description

We are seeking an experienced Cloud Data Engineer with a strong background in AWS, Azure, and GCP. The ideal candidate will have extensive experience with cloud-native ETL tools such as AWS DMS, AWS Glue, Kafka, Azure Data Factory, GCP Dataflow, and other ETL tools like Informatica, SAP Data Intelligence, etc. You will be responsible for designing, implementing, and maintaining robust data pipelines and building scalable data lakes. Experience with various data platforms like Redshift, Snowflake, Databricks, Synapse, Snowflake and others is essential. Familiarity with data extraction from SAP or ERP systems is a plus.

Key Responsibilities:

Design and Development:

• Design, develop, and maintain scalable ETL pipelines using cloud-native tools (AWS DMS, AWS Glue, Kafka, Azure Data Factory, GCP Dataflow, etc.).
• Architect and implement data lakes and data warehouses on cloud platforms (AWS, Azure, GCP).
• Develop and optimize data ingestion, transformation, and loading processes using Databricks, Snowflake, Redshift, BigQuery and Azure Synapse.
• Implement ETL processes using tools like Informatica, SAP Data Intelligence, and others.
• Develop and optimize data processing jobs using Spark Scala.

Data Integration and Management:

• Integrate various data sources, including relational databases, APIs, unstructured data, and ERP systems into the data lake.
• Ensure data quality and integrity through rigorous testing and validation.
• Perform data extraction from SAP or ERP systems when necessary.

Performance Optimization:

• Monitor and optimize the performance of data pipelines and ETL processes.
• Implement best practices for data management, including data governance, security, and compliance.

Collaboration and Communication:

• Work closely with data scientists, analysts, and other stakeholders to understand data requirements and deliver solutions.
• Collaborate with cross-functional teams to design and implement data solutions that meet business needs.

Documentation and Maintenance:

• Document technical solutions, processes, and workflows.
• Maintain and troubleshoot existing ETL pipelines and data integrations.

Qualifications

Education:

• Bachelor’s degree in Computer Science, Information Technology, or a related field. Advanced degrees are a plus.

Experience:

• 7+ years of experience as a Data Engineer or in a similar role.
• Proven experience with cloud platforms: AWS, Azure, and GCP.
• Hands-on experience with cloud-native ETL tools such as AWS DMS, AWS Glue, Kafka, Azure Data Factory, GCP Dataflow, etc.
• Experience with other ETL tools like Informatica, SAP Data Intelligence, etc.
• Experience in building and managing data lakes and data warehouses.
• Proficiency with data platforms like Redshift, Snowflake, BigQuery, Databricks, and Azure Synapse.
• Experience with data extraction from SAP or ERP systems is a plus.
• Strong experience with Spark and Scala for data processing.

Skills:

• Strong programming skills in Python, Java, or Scala.
• Proficient in SQL and query optimization techniques.
• Familiarity with data modeling, ETL/ELT processes, and data warehousing concepts.
• Knowledge of data governance, security, and compliance best practices.
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration skills.

Preferred Qualifications:

• Experience with other data tools and technologies such as Apache Spark, or Hadoop.
• Certifications in cloud platforms (AWS Certified Data Analytics – Specialty, Google Professional Data Engineer, Microsoft Certified: Azure Data Engineer Associate).
• Experience with CI/CD pipelines and DevOps practices for data engineering.

What we offer in return:

• Remote Working: Lemongrass always has been and always will offer 100% remote work.
• Flexibility: Work where and when you like most of the time.
• Training: A subscription to A Cloud Guru and generous budget for taking certifications and other resources you’ll find helpful.
• State of the art tech: An opportunity to learn and run the latest industry standard tools.
• Team: Colleagues who will challenge you giving the chance to learn from them and them from you.

Lemongrass Consulting is proud to be an Equal Opportunity and Affirmative Action employer. We do not discriminate on the basis of race, religion, color, national origin, religious creed, gender, sexual orientation, gender identity, gender expression, age, genetic information, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.

About Lemongrass

Lemongrass is a software-enabled services provider, synonymous with SAP on Cloud, focused on delivering superior, highly automated Managed Services to Enterprise customers. Our customers span multiple verticals and geographies across the Americas, EMEA and APAC. We partner with AWS, SAP, Microsoft and other global technology leaders.