Remote AWS Integration engineer

Description

Our client is a fast-growing automation-led next-generation service provider delivering excellence in IT, BPO, and consulting services. They are driven by a combination of robust strategies, passionate teams, and a global culture rooted in innovation and automation.

Our client’s Digital offerings have helped clients achieve operational excellence and customer delight. Their focus lies on taking a leadership position in helping clients attain customer intimacy as their competitive advantage. They are now on a journey of metamorphosing the experiences of the customer’s customers by leveraging our industry-leading delivery and execution model, built around the strategy— Automate Everything™, Cloudify Everything™, Transform Customer Experiences™.

Powering our client’s complex technology solutions and services is the Bottom-Up Disruption, a disruptive crowdsourcing initiative that brings about innovation and improvement to everyday complexities and, ultimately, growing the client’s business. The digitally empowered workforce of our client represents various nationalities, comprising 19,833 employees, and lives the company’s philosophy of ‘customer success, first and always’. The company reported a 2020 global revenue of USD $845.04 Mn.

We are currently searching for a Remote AWS Integration Engineer:

Responsibilities

• Design, develop, and maintain data pipelines and workflows using AWS EventBridge, Step Functions, AWS Glue, DynamoDB, and Secrets Manager.
• Utilize Python for developing and maintaining data applications.
• Implement and manage REST API calls for integrating various data sources and services.
• Source and process data from Snowflake using AWS services.
• Write and optimize SQL queries, capture Change Data Capture (CDC) from Snowflake tables, and invoke downstream applications via API calls.
• Collaborate with stakeholders to define and implement data integration requirements.
• Optimize data workflows for performance, scalability, and reliability.
• Ensure data security and compliance, managing sensitive information with AWS Secrets Manager.
• Implement CI/CD pipelines and manage deployments using Azure DevOps.
• Monitor and troubleshoot data pipelines to ensure smooth operation and timely data delivery.

Requirements

• Strong expertise in AWS services, including EventBridge, Step Functions, AWS Glue, S3, AWS Lambda, DynamoDB, and Secrets Manager.
• Proficiency in Python and experience with REST API development.
• Experience sourcing data from Snowflake and processing it using AWS services.
• Expertise in SQL query optimization, CDC capture from Snowflake tables, and API integrations.
• Strong background in data modeling, ETL processes, and SQL.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.

Desired 

• AWS certification is a plus.
• Familiarity with Azure DevOps for CI/CD and deployment management, as well as GitHub Enterprise.
• Experience with metadata-driven load patterns in AWS.
• Knowledge of other AWS services like RDS.
• Understanding of data governance and data quality best practices.

Languages

• Advanced Oral English.
• Native Spanish.

Note:

• Fully remote.

If you meet these qualifications and are pursuing new challenges, start your application on our website to join an award-winning employer. Explore all our job openings | Sequoia Career’s Page: https://www.sequoia-connect.com/careers/

Requirements

• +5YoE
• Data Modeling & ETL: Design, develop, and optimize data models and ETL processes using Snowflake for efficient data storage and analytics.
• Design, develop, and deploy Power BI reports and dashboards integrated with Snowflake.
• Strong understanding of Snowflake, including SQL and data warehousing concepts.
• Implement data transformation logic using SQL, Snowflake Stored Procedures (SQL and Python), and ETL tool to ensure the integrity, accuracy, and consistency of data.
• Collaborate with data architects and business stakeholders to understand data requirements.
• Design, develop, and deploy Power BI reports and dashboards.
• Collaborate with business stakeholders to understand their data visualization needs.
• Proficiency in Power BI, including DAX and Power Query.
• Ensure data quality, governance, and security within the Snowflake environment.
• Troubleshoot and resolve issues related to the Snowflake data warehouse.