Senior Data Engineer 4RC-08

Technologies: Python, SQL, OLAP

Locations available: Costa Rica

Oceans Code Experts is looking for talented individuals that are ready for the next step in their career, we offer a collaborative professional environment as full of rewarding experiences as it is of challenges.

A Senior Data Engineer at Oceans can expect to work on multiple projects, work with a cross-functional team, and are transparent about time and tasks to help clients understand the progress of their projects.

Candidates must LOVE helping people, solving business problems, and pushing themselves to slay the next beast of a project.

Job Summary
Are you a seasoned Data Engineer ready to make an impact in the rapidly evolving climatetech space? Join a mission-driven team where your Python expertise and data engineering skills will help shape how buildings are modeled for a sustainable future.

Job Responsibilities

• Manage and optimize data pipelines ingesting third-party data into versioned PostgreSQL databases.
• Develop robust, scalable data solutions using Python and dbt.
• Collaborate with cross-functional teams to ensure accurate data modeling and representation of buildings.
• Contribute to schema design and performance tuning of large-scale OLAP databases.
• Own the end-to-end data engineering lifecycle, from ingestion to transformation and delivery.
• Take initiative in improving data workflows and engineering practices within the team.

Job Requirements

• Great English proficiency (B2+ Written and spoken)

• 10+ years of software engineering experience with an emphasis on data engineering 
• Impeccable punctuality (schedules are flexible but being in time for meetings is crucial)
• Deep expertise in Python and SQL.
• Proven experience building and operating scalable data pipelines.
• Hands-on experience with dbt and PostgreSQL, including internal optimization techniques.
• Strong understanding of OLAP-oriented schema design and database performance tuning.
• Demonstrated ability to optimize and version database schemas effectively.

Nice to have

• Background or experience in Building Science or related fields.

Position Type and Expected Hours of Work
This is a full-time consultancy, with up to 40 weekly hours during regular business times. We operate under a flexible core hours policy to accommodate various schedules, allowing consultants to perform during their peak productivity times. Additionally, we offer the flexibility to work remotely.