Careers

Enterprise Data Warehouse (EDW) Engineer

Job Description

We are seeking a Mid-Level Enterprise Data Warehouse (EDW) Engineer with a passion for building scalable, cloud-native data solutions. This position is ideal for individuals who excel in collaborative environments, communicate effectively, and approach challenges with a problem-solving mindsetnot just those who follow instructions.

Primary Skills (Must Have)

Strong SQL (complex queries, performance tuning)
Python for data processing
dbt (models, tests, transformations)
Data warehousing experience (Snowflake / BigQuery/ Redshift preferred)

Key Responsibilities

Design, develop, and maintain high-performance data pipelines and ETL/ELT workflows for the enterprise data warehouse.
Work with cloud-based data warehouse platforms like Snowflake, BigQuery, or Redshift to optimize data storage and retrieval.
Write clean, efficient, and maintainable SQL and Python code for data transformation and automation tasks and Implement and manage CI/CD pipelines for data workflows using tools like Git, Jenkins, or GitHub Actions.
Experience using AI tools to assist with SQL query optimization, code generation, and documentation for data engineering workflows.
Leverage orchestration tools (e.g., Apache Airflow, dbt Cloud, Prefect) to schedule and monitor data workflows.
Conduct detailed data analysis between current and target systems, and prepare mapping documentation.
Collaborate with data analysts, scientists, and business teams to generate actionable insights.
Proactively identify and address data quality issues and performance bottlenecks.
Contribute to data architecture decisions and establish best practices.
Demonstrated ability to adopt an AI-first mindset and leverage AI-driven tools to enhance productivity, innovation, and decision-making within the role

Role: Data Engineer

Industry Type: IT Services & Consulting

Department: Engineering – Software & QA

Employment Type: Full Time, Permanent

Role Category: Software Development

Education

UG: Any Graduate

PG: Any Postgraduate