Junior Analytics Engineer

Description

We are looking for a **Junior Analytics Engineer** to work on the layer that transforms raw data into clean, reliable, tested, and consumption-ready models. This role bridges Data Engineering (which brings data in) and Analytics & Business teams (which make decisions using that data). You will write well-structured SQL transformations, help build and maintain data models, ensure data quality and documentation, and deliver consistent data for dashboards and analytics. This is an excellent opportunity for someone with a solid technical foundation, strong organizational skills, and a desire to grow quickly within a team that values sound data modeling practices. **Responsibilities** --------------------- * Develop and maintain modular, versioned **SQL data transformations**, from raw data to analytical tables ready for use. * Support the development and evolution of **data models** (staging, intermediate, and marts layers), following team-defined standards. * Implement **data quality tests** and **model documentation**, ensuring consumers can trust the results. * Deliver consistent datasets for **dashboards and reports** (Power BI / Fabric). * Collaborate with Data Engineering to understand data sources and ingestion processes, and with analysts/business stakeholders to clarify business rules. * Use **version control** and participate in code reviews (pull requests). * Investigate and resolve data and model inconsistencies. **Requirements** -------------- * Strong **SQL proficiency** — this is the core competency for this role (joins, aggregations, CTEs, window functions). * Understanding of **data modeling concepts** (fact and dimension tables, normalization vs. denormalization, granularity). * Familiarity with **version control** (Git) and willingness to engage in code reviews. * Attention to detail and commitment to **data quality and consistency**. * Good communication skills and eagerness to learn — we expect technical growth over time, not full mastery from day one. * Analytical thinking and logical reasoning to understand the "why" behind the numbers. **Nice-to-Haves** ---------------- * Experience with **dbt** (or another SQL-based transformation tool). * Hands-on experience with **Snowflake** (or another cloud data warehouse — BigQuery, Redshift, Databricks). * Familiarity with **Power BI / Microsoft Fabric** or other BI tools. * Exposure to **data ingestion tools** (Airbyte, Fivetran, etc.). * Knowledge of **dimensional modeling** (Kimball / star schema). * Familiarity with **Azure DevOps** or CI/CD pipelines. * Basic **Python** knowledge for automation and data processing. * Interest in or experience within the **consumer goods (FMCG/CPG)** domain. **About our stack:** We use Snowflake, dbt, Azure, and Power BI/Fabric. However, we value candidates with a strong foundation in SQL and data modeling who are eager to learn our tools — experience with equivalent stacks is welcome.