About the role
Role
Data Engineer (SQL & AWS)
Start Date
Urgent /ASAP
Experience Level
8-12 yrs
Job Summary
We are seeking a highly skilled Data Engineer with deep expertise in SQL (including stored procedures) and AWS-based data engineering solutions. You will be responsible for designing, building, and optimizing scalable data pipelines and systems that enable analytics, reporting, and data-driven decision-making across the organization.
Key Responsibilities
-
Develop, and optimize complex SQL queries and stored procedures for high-performance data processing and transformation.
-
Build and maintain scalable ETL/ELT pipelines on AWS using services such as Glue, Lambda, S3, Athena, Redshift, and Step Functions.
-
Implement and maintain data integration solutions from various data sources into a centralized data lake or data warehouse.
-
Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and deliver reliable solutions.
-
Monitor and troubleshoot data pipelines to ensure data accuracy, timeliness, and reliability.
-
Apply data governance and security best practices in all development work.
Skills Required
- Expert-level proficiency in SQL, including performance tuning, writing complex joins, and stored procedures in databases.
- Experience with AWS Data Engineering tools
AWS Glue
Amazon Redshift
AWS Lambda
Amazon S3
Athena
Step Functions
Experience with data modeling, ETL orchestration, and data pipeline development in AWS.
Familiarity with version control systems (e.g., Git) and CI/CD for data workflows.
Airflow
- Experience with Python and PySpark
About Atlantis IT Group
"Atlantis IT Group" is an IT venture that offers end-to-end services and products. The focus of "the Company" is to cater one-stop solutions to small and medium-sized businesses.
"Atlantis" had its first branch in Toronto, Canada, and was established in 1990. The Company has emerged from a small farm to a medium company providing all sorts of solutions, headquartered in Toronto, Canada The Company has had its branches and offices in different countries such as the USA, Canada, and India for the last 32 years.
Atlantis is enlarging its global footprint by offering complementary product and service lines by partnering and strategically working with businesses. The primary specialized area of the Company includes ERP solutions, with cloud-based and on-premise solutions available to meet the requirements of all Industries.
OUR PRODUCTS:
"WORKSWARE ERP" The emergence of WORKSWARE ERP is noticed from a ground level to an upgraded form because of the integrated ERP system, dedicated towards forward-thinking discrete manufacturing enterprises.
"BM-Cloud" BM-Cloud is One of the key offerings of Atlantis consulting as a Cloud-based business management ERP software since 2013. The significant feature of BM-Cloud includes easy usage with the enhancement of simplicity and usability as a complete integrated ERP system. The fundamental modules covered by BM-Cloud are accounting, inventory management, purchasing, sales, and HR/payroll systems. In other words, it is designed primarily to support businesses in the trading and retail sectors and includes all the essential components required for a firm to assist in decision-making.
"BM-POS"
We provide a cloud-based retail solution with all the tools required to manage a retail business, including a sales screen, inventory management, real-time dashboard, employee administration, and other functions that keep retailers in charge of their operations.
About the role
Role
Data Engineer (SQL & AWS)
Start Date
Urgent /ASAP
Experience Level
8-12 yrs
Job Summary
We are seeking a highly skilled Data Engineer with deep expertise in SQL (including stored procedures) and AWS-based data engineering solutions. You will be responsible for designing, building, and optimizing scalable data pipelines and systems that enable analytics, reporting, and data-driven decision-making across the organization.
Key Responsibilities
-
Develop, and optimize complex SQL queries and stored procedures for high-performance data processing and transformation.
-
Build and maintain scalable ETL/ELT pipelines on AWS using services such as Glue, Lambda, S3, Athena, Redshift, and Step Functions.
-
Implement and maintain data integration solutions from various data sources into a centralized data lake or data warehouse.
-
Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and deliver reliable solutions.
-
Monitor and troubleshoot data pipelines to ensure data accuracy, timeliness, and reliability.
-
Apply data governance and security best practices in all development work.
Skills Required
- Expert-level proficiency in SQL, including performance tuning, writing complex joins, and stored procedures in databases.
- Experience with AWS Data Engineering tools
AWS Glue
Amazon Redshift
AWS Lambda
Amazon S3
Athena
Step Functions
Experience with data modeling, ETL orchestration, and data pipeline development in AWS.
Familiarity with version control systems (e.g., Git) and CI/CD for data workflows.
Airflow
- Experience with Python and PySpark
About Atlantis IT Group
"Atlantis IT Group" is an IT venture that offers end-to-end services and products. The focus of "the Company" is to cater one-stop solutions to small and medium-sized businesses.
"Atlantis" had its first branch in Toronto, Canada, and was established in 1990. The Company has emerged from a small farm to a medium company providing all sorts of solutions, headquartered in Toronto, Canada The Company has had its branches and offices in different countries such as the USA, Canada, and India for the last 32 years.
Atlantis is enlarging its global footprint by offering complementary product and service lines by partnering and strategically working with businesses. The primary specialized area of the Company includes ERP solutions, with cloud-based and on-premise solutions available to meet the requirements of all Industries.
OUR PRODUCTS:
"WORKSWARE ERP" The emergence of WORKSWARE ERP is noticed from a ground level to an upgraded form because of the integrated ERP system, dedicated towards forward-thinking discrete manufacturing enterprises.
"BM-Cloud" BM-Cloud is One of the key offerings of Atlantis consulting as a Cloud-based business management ERP software since 2013. The significant feature of BM-Cloud includes easy usage with the enhancement of simplicity and usability as a complete integrated ERP system. The fundamental modules covered by BM-Cloud are accounting, inventory management, purchasing, sales, and HR/payroll systems. In other words, it is designed primarily to support businesses in the trading and retail sectors and includes all the essential components required for a firm to assist in decision-making.
"BM-POS"
We provide a cloud-based retail solution with all the tools required to manage a retail business, including a sales screen, inventory management, real-time dashboard, employee administration, and other functions that keep retailers in charge of their operations.