We're looking for a Data Warehouse Engineer (Junior / Mid-Level) to help design, develop, and maintain a modern data warehouse environment. You'll work on ingesting data from multiple sources, transforming it into analytics-ready models, and ensuring high performance, reliability, and data quality. This role sits at the intersection of data engineering and analytics, with a strong focus on warehouse best practices.
Key Responsibilities
Data Warehouse Development
- Build and maintain ETL / ELT processes to load data into the warehouse from various internal / external sources
- Develop and manage warehouse schemas, tables, and views to support analytics and reporting
- Implement data quality checks, validation, and lineage tracking
Data Modeling & Performance Tuning
Design efficient star / snowflake schemas for reporting and BI toolsWrite optimized SQL for data transformations and queriesMonitor and tune warehouse performance (partitioning, indexing, clustering)Automation & Orchestration
Use workflow / orchestration tools (Airflow, Prefect, dbt, Dagster or similar) to automate warehouse pipelinesDevelop reusable Python scripts / libraries for data transformationsWork closely with analysts, BI developers and data scientists to understand data needsProvide analytics-ready datasets and documentationSupport troubleshooting and resolve data issues in the warehouseRequired Qualifications
Technical Skills
2–4 years of experience in data engineering or data warehouse developmentStrong SQL skills; experience with relational databases and data warehousing conceptsProficiency in Python for ETL / ELT and data processing (pandas, PySpark or similar)Familiarity with data modeling (star / snowflake, dimensional modeling)Exposure to at least one modern cloud data warehouse (Snowflake, BigQuery, Redshift, Synapse, etc.)Basic understanding of cloud services (AWS / GCP / Azure)Soft Skills
Good problem-solving and analytical thinkingAbility to write clear documentation for data models and pipelinesEffective communication with both technical and non-technical stakeholdersEagerness to learn and improve warehouse best practicesSkills Required
Python, SQL, Cloud Platforms, Data modeling, Data Warehouse Engineering, ETL / ELT, Dimensional Modeling, Cloud Data Warehouses, Snowflake, BigQuery, Redshift, Synapse, Workflow Orchestration, Airflow, Analytics, Agile Software Development
J-18808-Ljbffr