Senior Data Engineer, Latam

Rainforest Alliance; Lima Metropolitana; Hybrid; PEN 311,000 - 467,000; Full time

Benefits offered by this job

Remote/Hybrid work environment

Career development opportunities

Remote working flexibility

Job summary

Rainforest Alliance seeks a Senior Data Engineer to design and maintain production data pipelines on Databricks and ADLS Gen2, translating requirements into dimensional models for BI consumption. Lead a small team, ensure governance and scalability across Power BI datasets and dashboards.

You will collaborate with Enterprise Data Platform and field teams, shaping the UDP architecture and data quality practices while supporting follow-the-sun project delivery.

Qualifications

• Experience building and operating production data pipelines on Spark-based platforms.
• Strong SQL and dimensional modelling skills (star schema, Bronze-Silver-Gold).
• Experience designing performant, governed semantic models for BI tools (Power BI).
• Clear technical documentation that non-specialists can follow.

Responsibilities

• Design, build and maintain robust data pipelines on Databricks/ADLS Gen2.
• Develop dimensional models and queries translating requirements into the model.
• Create reusable platform functions and extend SQL-based environments.
• Develop and optimize Power BI datasets, reports and dashboards.

Skills

Databricks

ADLS Gen2

Power BI

SQL

Dimensional modelling

Python/PySpark

Power BI datasets

Tools

Unity Catalog

Job description

POSITION

Senior Data Engineer

LOCATION

We will only consider candidates legally authorized to work in the Mexico, Guatemala, Peru, Colombia or Brazil.

WORKPLACE TYPE

Flexible hybrid working environment

CLOSING DATE

06 November 2026

JOB LEVEL

15

POSITION SUMMARY

At the Rainforest Alliance, we believe in the value of data collected at field and company level. With the increasing update of technologies, the amount of data produced will lead to an exponential amount and growth of available information. Unlocking the value of the information and linking it to informed decision-making will enable our organization in reaching the goal of a world where human and nature thrive in harmony.

Rainforest Alliance is building a Unified Data & AI-ready Platform on Databricks, Azure Data Lake Storage Gen2 and Power BI Premium, using a Bronze/Silver/Gold medallion architecture.

In order to progress to a singular platform, we are looking to onboard additional data engineering capability to support both the existing Azure SQL based services and the new platform, which is in pilot phase, as part of wider improvements to the hours of service that we provide to our global users - A working knowledge of both technologies is therefore required. In addition, to provide escalation cover and time zone management, this role will be responsible for the supervision of a team of (currently 3) data and data platform engineers.

You will report to the Senior Manager, Enterprise Data Platform.

WHAT YOU WILL DO

• Pipeline engineering: Design, build and maintain robust, production-grade data pipelines and core platform components on Databricks / ADLS Gen2, following the Bronze/Silver/Gold medallion architecture.
• Dimensional modelling: Translate signed-off requirements into dimensional models and the queries that take consolidated raw data to the dimensional model.
• Platform engineering: Build the generic, reusable functions and production code that reproduce, at scale and across the organisation, the same output as the validated queries; Maintain and continue development of the existing SQL-based environment.
• Reporting: Support the design, development and enhancement of Power BI datasets, reports and dashboards; Provide support to report builders/owners in reviewing and optimising reports and datasets, to ensure accuracy, mantainability and performance.
• Power BI Tenant Admin: Support Power BI Premium lifeycle management processes, including user onboarding/offboarding, governance activities (including obsolete workspace and dataset/report cleanup), and performance monitoring/optimisation.
• Data visualisation enablement: Develop and support the data visualisation methodologies, views and extractions (e.g. Databricks views feeding Power BI).
• Data quality: Work with the Survey Design Specialists, BI Analysts and M&E Analysts to embed data quality checks and troubleshoot issues found.
• Documentation & reproducibility: Maintain clear, field-knowledge-free documentation of ingestion, transformation and modelling logic.
• Collaboration: Work closely with the Data Platform Lead, Tech, and Field Implementation to ensure engineering work stays aligned with the wider UDP architecture and governance model (Unity Catalog).
• Leadership: Matrix manage a small team (3-5) of data and data platform engineers, be accountable for escalations and ensure smooth transition between regional teams to support a follow-the-sun approach to project delivery and “business as usual” support.

WHAT YOU BRING

• Experience building and operating production data pipelines, ideally on Databricks (or a comparable Spark-based platform) and cloud data lake storage (ADLS Gen2, S3 or equivalent).
• SQL and hands‑on experience with dimensional modelling (star schema / Bronze-Silver-Gold or similar medallion patterns).
• Experience building the data layer behind BI tools, ideally Power BI, including designing performant, well-governed semantic models and views.
• Write clear technical documentation that a non-specialist reader can follow.
• Comfortable working to formal sign-off gates (requirements, staging, production) and coordinating with analysts, survey and field teams rather than working in isolation.

Desirable

• Experience with survey/ODK-style data collection tools (e.g. Survey123, XLSForms).
• Familiarity with data governance concepts (data catalogues, access control, e.g. Unity Catalog) in a multi-tenant or multi-partner data platform.
• Python and PySpark for pipeline development and testing.

BENEFITS OF WORKING AT THE RAINFOREST ALLIANCE

• Be a part of a global organization with an impactful mission and a collaborative, respectful, and accountable culture.
• Enjoy opportunities for professional growth and career development.
• Benefit from remote working flexibility and flexible hybrid working environment.
• A favourable time‑off policy.
• Prioritize your wellbeing. We have numerous ways to promote work-life balance.

If you have any questions about the job vacancy, please contact the HR department: [e-mail] The Rainforest Alliance encourages diversity and inclusion across the global organization. With this commitment to diversity, we are proud to be an equal opportunity employer and do not discriminate on the basis of gender, race, color, ethnicity, religion, sexual orientation, gender identity, ages, disability and any other protected group.