Data Engineer (AWS, SQL) (Bengaluru)

Data Engineer (AWS, SQL) (Bengaluru)

20 Nov
|
Kaseya
|
Bengaluru

20 Nov

Kaseya

Bengaluru

Kaseya is the leading provider of AI-powered IT management and cybersecurity software, serving Managed Service Providers (MSPs) and internal IT organizations worldwide. Our comprehensive platform helps organizations efficiently manage, secure, and automate their IT environments, driving operational efficiency and long-term business success.

Backed by Insight Partners, a leading global software investor, Kaseya has experienced sustained double-digit growth and continues to expand its global footprint. Today, Kaseya supports customers in more than 20 countries and manages over 15 million endpoints worldwide.

Founded in 2000, Kaseya was built by builders - and we're still building. At Kaseya, everyone plays a role in shaping the future of IT: whether you're in engineering, product, sales, marketing, customer support, or operations, your work helps protect, defend, and optimize IT environments across the globe.

We're building teams that grow, perform, and make an impact. We are seeking a motivated and technically skilled Data Engineer I to join our Data Services team at Kaseya. The ideal candidate should have hands-on experience in SQL, Python, Snowflake, Apache Airflow, and AWS cloud services, with a strong understanding of data engineering concepts and ETL/ELT processes.

The role involves developing, maintaining, and optimizing data pipelines, integrating data from multiple source systems, and building reliable and scalable datasets using Medallion Architecture.

The candidate will work extensively on developing Silver and Gold-layer datasets, implementing data transformations, data cleansing, standardization, validation, and business logic to deliver high-quality, business-ready datasets for reporting, analytics, and downstream applications.

The candidate should have solid problem-solving skills, attention to data quality, and the ability to work collaboratively with team members to deliver reliable data engineering solutions

Data Pipeline Development

Develop, maintain, and enhance data pipelines using Python, SQL, Snowflake, and Apache Airflow.

Build and maintain ETL/ELT workflows to ingest data from multiple source systems.

Develop data extraction, transformation,



and loading processes to support enterprise data requirements.

Implement incremental data loading and data processing mechanisms.

Write reusable and efficient Python scripts and SQL transformations.

Ensure data pipelines are reliable, scalable, and maintainable.

Medallion Architecture - Silver & Gold Layer Development

Work with Medallion Architecture (Bronze, Silver, and Gold layers) to build and maintain structured data pipelines.

Develop Silver-layer datasets by implementing data cleansing, standardization, deduplication, validation, and transformation logic.

Build Gold-layer datasets by applying business rules, joins, aggregations, and transformations to create curated, business-ready datasets.

Implement data quality checks and validation rules across Silver and Gold datasets.

Ensure data consistency, accuracy, completeness, and reliability across different data layers.

Support the development of reusable data models and transformation frameworks.

Optimize SQL queries and data transformations for efficient dataset processing.

Snowflake Development

Develop and maintain Snowflake tables, views, and SQL-based transformation workflows.

Write complex SQL queries, stored procedures, and data transformation logic.

Work with Snowflake features such as Streams, Tasks, and Dynamic Tables.

Perform basic query optimization and troubleshoot performance-related issues.

Support data loading, transformation, and data validation activities.

Follow Snowflake security and access management best practices.

Python & Apache Airflow

Develop Python scripts and modules for data processing, integration, and automation.

Create and maintain Apache Airflow DAGs for data pipeline orchestration.

AWS Cloud Services

Utilize AWS cloud services for data storage, integration, and processing.

Work with AWS services such as:

AWS Lambda

AWS IAM

AWS Glue (preferred)





Support integration between AWS services and Snowflake data pipelines.

Follow cloud security and data access best practices.

Bachelor's degree in Computer Science, Engineering, Information Technology, or a related field.

- 3-7 years of experience in Data Engineering, Data Development, or a related technical role.
- Good hands-on experience with SQL, including complex queries, joins, analytical functions, and data transformations.
- Hands-on experience with Python for data processing, automation, and pipeline development.

~ Working experience with Snowflake, including:

- Tables, views, and SQL transformations.
- Data loading and unloading.
- Data modelling and schema design.
- Query optimization and performance tuning fundamentals.
- Hands-on experience with Apache Airflow, including DAG development, scheduling, task dependencies, and workflow monitoring.
- Hands-on experience with AWS cloud services (Mandatory), preferably S3, Lambda, SQS, SNS, IAM, and CloudWatch.
- Understanding of Medallion Architecture (Bronze, Silver, and Gold layers).
- Practical experience developing Silver and Gold-layer datasets, including data cleansing, standardization, business transformations, joins, and aggregations.
- Good understanding of ETL/ELT processes, data warehousing concepts, and data integration.
- Understanding of dimensional modelling concepts, including Fact and Dimension tables, Star Schema, and Snowflake Schema.
- Basic understanding of incremental data loading, CDC, and historical data handling.
- Familiarity with Snowflake Streams, Tasks, Dynamic Tables, and Stored Procedures.

Familiarity with data governance, data security, and data quality practices.

Exposure to data observability and pipeline monitoring frameworks.

Experience working with large datasets and optimizing data transformation workflows.

Kaseya provides equal employment opportunity to all employees and applicants without regard to race, religion, age, ancestry, gender, sex, sexual orientation, national origin, citizenship status, physical or mental disability, veteran status, marital status, or any other characteristic protected by applicable law.

📌 Data Engineer (AWS, SQL) (Bengaluru)
🏢 Kaseya
📍 Bengaluru

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: data engineer (aws, sql) (bengaluru) / bengaluru

Subscribe to this job alert:

Get the latest job offers by email for: data engineer (aws, sql) (bengaluru) / bengaluru