Summary: As a Jr. Analytics Engineer, you will design, build, and maintain data infrastructure, ensuring the Redshift Data Warehouse is the Single Source of Truth by developing scalable pipelines and robust data models. Highlights: 1. Develop scalable data models using SQL (dbt) and Python 2. Optimize Python scripts for ingesting data from third-party APIs 3. Work with data orchestration tools to schedule and monitor workflows **About KLAR** Klar is on a mission to democratize financial services in Mexico—because half of the population still doesn’t have access to a bank account. We’re building the future of fintech with a rich set of debit and credit products, and we’ve already served over 2 million users since our launch in 2019! We are now entering the business segment, and our goal is to provide the best financial operating system for small and medium\-sized enterprises (SMEs). We are also proud to have been certified in 2023 as a “Great Place to Work” in Mexico \- we’ve worked hard to make that happen and will continue to make bigger strides in the future! Sound like a place you’d like to be? **Our people** If you join us at Klar, you’ll be welcomed into a team which is rich in many talents and we are very proud! With our head office in Mexico City, and remote tech hubs in Berlin and Argentina, we are always learning something new about another culture or language. With so many people from different backgrounds and walks of life (parents, LGBTQ\+, neurodivergence), you’ll definitely find your people here! **Our values** * Ownership \- We own our successes \& our failures as a team. * Excellence \- We do everything to the best of our ability \& always seek to achieve a new level of excellence in our work. * Inclusion \- We believe we are stronger together and actively work to promote a safe, diverse, inclusive, and respectful culture. * Customer Obsession \- We understand the value Klar can bring to its customers \& it’s always at the forefront of our decisions. * Klarity \- We communicate clearly \& with authenticity. It’s in our name \& it’s what we do. **The position and your daily adventures** As a Jr. Analytics Engineer, you will design, build, and maintain the data infrastructure that supports business decision\-making. Your mission is to ensure that our Redshift Data Warehouse remains the Single Source of Truth by developing scalable pipelines, robust data models, and efficient data ingestion and transformation processes. In simple terms: you will help turn raw data into reliable, actionable insights that drive the business forward. This is a full\-time position based in our Mexico City office under a hybrid model. You will be expected to attend the office 2–3 times per week. **What you can expect:** * **Data pipelines and modeling:** Create and maintain scalable data models using SQL (dbt) and Python, ensuring that our Redshift data warehouse (DWH) remains the Single Source of Truth. * **API integrations:** Develop and optimize Python scripts for ingesting data from third\-party APIs, ensuring an efficient flow into our DWH. * **Big Data processing:** Use PySpark to transform large\-scale datasets, with a strong focus on performance and efficiency. * **Orchestration:** Work with data orchestration tools (Mage) to schedule, monitor, and troubleshoot production workflows. * **Code quality:** Participate in code reviews, maintain technical documentation, and follow Git best practices to ensure high engineering standards. **You and your assets:** * Bachelor’s degree in Mechatronics Engineering, Computer Science, Mathematics, or a related field. * 2\+ years of experience with advanced SQL, including complex queries, window functions, and performance optimization (academic experience will be considered relevant experience). * 1\+ year of experience with Python, including solid understanding of data structures and programming logic, as well as experience consuming APIs and handling JSON or structured data. * Familiarity with PySpark and big data processing, including working with Spark DataFrames and large\-scale datasets. * Understanding of data orchestration concepts and experience with tools such as Dagster, Mage, Airflow, or similar. * Basic knowledge of Git workflows, including branching, commits, and pull requests. * 1\+ year of experience as an Analytics Engineer (desirable). * Advanced English proficiency. **Our offer to you:** * Competitive salary based on performance and experience * Chance of earning Klar stock options * 15 days of paid vacation per year; plus extended maternity and paternity leaves * Vacation premium * 30 days of Christmas bonus * Food vouchers * Medical Insurance * Computer device * Wellhub subscription to offer mental and physical health * Sponsored coaching and therapy sessions via Modern Health * A modern centrally located office in Mexico City with free drinks, snacks, and regular social events * International work environment with amazing and highly skilled people * A world class team that helps you evolve your skills in areas you're interested in **Klar is a safe place for everyone!** *We trust our highly skilled and diverse team and we’re committed to creating a welcoming and inclusive environment for new talents to flourish. We value diversity and welcome all applications regardless of gender, nationality, ethnic and social origin, religion/belief, physical abilities, age, sexual orientation and identity.* *Should you require any accommodations through the recruitment process, please don’t hesitate to let us know how we can help!*