Job Summary: We are looking for a motivated Data Engineer to design, implement, and optimize data integration solutions in a heterogeneous environment. Key Highlights: 1. Be part of a Great Place To Work organization. 2. Work on technological and agile transformation projects. 3. We champion learning, transparency, and trust. DESCRIPTION **JOIN THE TEAM AS A DATA ENGINEER!** Do you want to be part of an organization committed to caring for people and supporting their personal and professional growth? Are you passionate about development and eager to take on new challenges? Join Kairós! **Who Are We?** We have been certified as a **Great Place To Work** company since 2019 — for the fifth consecutive year — and ranked **5th in 2024**, thanks to our values, culture, and internal benefits and initiatives focused on people. We support our clients in technological and agile transformation projects. **We work in discipline-based teams and multidisciplinary squads across highly diverse projects** (retail, healthcare research, banking, security, mobility, etc.). Although we have grown significantly over the past year, we remain true to our essence: **people-first**. We provide continuous personalized follow-up for our technical and Talent teams. Moreover, we consistently prioritize transparency and clarity. We operate in **Spain, Mexico, and Peru**. At Kairós, you’ll find projects that allow you to work remotely — without losing closeness with the rest of the team! **What Are We Looking For?** **At Kairós**, we seek a highly motivated **Data Engineer**, with proven experience in SQL, data modeling, and data pipeline development. The candidate will be responsible for designing, implementing, and optimizing data integration solutions in a heterogeneous environment, working with **Oracle** as the transactional system, **PostgreSQL** as the data warehouse, and a lakehouse on **Databricks**. This position requires proficiency in daily data loading using **SQL and Python**, and experience integrating systems via microservices and messaging tools such as **Kafka**. Our Data & AI capability is our most recently established unit. With credentials in healthcare, science and research, environmental projects, and initiatives in banking and security, it is led by **Inés Huertas**, and continues to grow by incorporating diverse profiles with substantial contributions to make. Within our discipline, we cover the full data lifecycle — from data design and convergence to data exploitation experts using BI or IT Engineers. We work on generative AI projects, predictive algorithms, Big Data platform development, and dashboard generation, surrounded by Kairoseros and Kairoseras in roles such as Machine Learning Engineer, Data Engineer, Data Scientist, Data Analyst, and Data Visualization Specialist. **Main Responsibilities** * Design and Development: Build and maintain efficient, scalable data pipelines for data integration and processing. * Database Management: Optimize usage of Oracle, PostgreSQL, and Databricks (delta tables), ensuring data integrity and quality. * Process Automation: Implement daily data loads using Python and SQL scripts in batch processes and lakehouse workflows. * System Integration: Contribute to integrating data into the Databricks lakehouse through: Data federation from PostgreSQL. * Microservices deployed on OpenShift that extract data from Oracle, publish JSON messages to Kafka, and are subsequently consumed in Databricks via workflows. * Collaboration and Continuous Improvement: Collaborate closely with other teams (development, analytics, operations) to optimize processes and continuously improve the data infrastructure. **Mandatory Requirements** * Minimum 4 years of experience in Data Engineering or similar roles. * Advanced proficiency in SQL and experience designing and optimizing data models. * Data Pipelines: Demonstrable experience designing, building, and maintaining data pipelines. * Practical knowledge of Oracle and PostgreSQL. * Proficiency in Python for developing data loading scripts and processes. * Experience using process orchestration tools. **Desired Skills** * Lakehouse and Databricks: Experience working in lakehouse environments, especially with Databricks. * Data Federation: Knowledge of data federation techniques for integrating data from disparate sources. * Microservices and OpenShift: Experience developing and deploying microservices on OpenShift. * Kafka and Messaging: Familiarity with Kafka, JSON message processing, and integration into data pipelines. * Workflows: Experience orchestrating complex processes via workflows. * Agile Methodologies: Knowledge and experience in agile environments and continuous improvement of data processes. * Apache Avro: Experience implementing Apache Avro for serialization and deserialization of JSON in high-volume environments, optimizing performance and data integration. At Kairós, you’ll find: * Free English classes in small groups. * 23 vacation days, December 24 and 31 off, 1 day for personal events, and 3 flexible-work days! * Enjoy summer with our reduced working hours in August and shortened workdays every Friday throughout the year. * Flexible compensation via Cobee, usable for dining, public transportation, training, and childcare vouchers. * Health insurance with Cigna or Sanitas — we care about your physical and mental well-being. * Ongoing personal support through our Wellness 3.0 program and consistent technical mentoring. * Opportunities to strengthen your personal brand at internal and external events. * Membership in a strong community and support from outstanding professionals and industry leaders. * But above all… being part of a company where you’re heard, cared for, and where we strive to meet your needs and expectations. **You’ll Fit Right In If** you enjoy **learning, sharing your knowledge, and treating others with respect and kindness**. If you’re interested in contributing to an **open, transparent, and trusting culture**, and if you also possess **organizational ability, responsibility, and commitment**. **#TRY #THINK #FEEL #ENJOY** **** At Kairós, we firmly believe in the importance of equality and diversity in the workplace. We are committed to creating an inclusive and respectful environment where all employees feel valued and have the opportunity to reach their full potential — regardless of race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or any other characteristic protected by law.