Data Engineer I
2 views3-7 years
Posted 5 days ago
- Airflow
- AWS
- Git
- Python
About Kaseya
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 enables businesses to simplify IT operations, enhance security, and maximize efficiency.
About the Role:
We are looking for a Data Engineer I to join our Data Engineering & Analytics team. In this role, you will be responsible for building, optimizing, and maintaining data pipelines and architectures that ingest, process, and transform raw data into analytics-ready models. You will work closely with data analysts, business intelligence engineers, and product stakeholders to support reporting, advanced analytics, and data-driven decision-making across the organization.
Key Responsibilities:
- Design, build, and operationalize robust, scalable data ingestion and transformation pipelines (ETL/ELT) using SQL, Python, Apache Airflow, and Snowflake.
- Implement and manage data transformations aligned with Medallion Architecture (Bronze -> Silver -> Gold).
- Develop and maintain Airflow DAGs for orchestrating end-to-end data workflows, ensuring timely execution, monitoring, and error handling.
- Work with AWS services (S3, Lambda, SQS, CloudWatch) to support data transfer, storage, and pipeline execution.
- Maintain and enhance dimensional data models (star schema, snowflake schema) in Snowflake to support business reporting and analytical requirements.
- Implement incremental data loading strategies, Change Data Capture (CDC), and optimize query performance in Snowflake.
- Perform data quality validations, monitoring, and debugging across pipeline layers to ensure data consistency and integrity.
- Collaborate with cross-functional teams including Data Analytics, Business Operations, and Engineering to deliver reliable data assets.
- Use Git and follow best practices in version control, code reviews, and CI/CD for data deployments.
- Continuously evaluate and improve data pipelines for efficiency, scalability, and maintainability.
Required Skills & Experience:
- Bachelor's degree in Computer Science, Engineering, IT, or a related quantitative field.
- 3-7 years of hands-on experience in Data Engineering, Data Development, or a related technical role.
- Strong proficiency in SQL, with experience writing complex queries, window functions, and data transformations.
- Strong hands-on experience with Python for data processing, scripting, and pipeline automation.
- Deep working experience with Snowflake, including table design, data loading/unloading, transformations, and query optimization.
- Proven experience developing and maintaining DAGs in Apache Airflow.
- Hands-on experience with AWS services (S3, Lambda, SQS, CloudWatch, IAM).
- Understanding of data warehousing principles, dimensional modeling (Fact/Dimension tables), and Medallion Architecture.
- Experience with Git for version control and collaborative development.
- Strong problem-solving, analytical, and troubleshooting skills.
- Good communication and collaboration skills with the ability to work in an agile, distributed team environment.
Preferred Qualifications:
- Familiarity with Snowflake advanced features (Streams, Tasks, Dynamic Tables, Stored Procedures).
- Exposure to CI/CD workflows and automated testing for data pipelines.
- Familiarity with data governance, security, and quality frameworks.
- Exposure to data observability tools and pipeline monitoring frameworks.
- Experience with AWS Glue.