Lead Data Engineer

Summary

Join Hakkoda, a modern data consultancy specializing in Snowflake Data Cloud solutions, as a Lead Data Engineer. You will design and develop Snowflake Data Cloud solutions, including data ingestion pipelines, data architecture, and data governance. This role involves leading technical teams, mentoring junior engineers, and optimizing data systems. The ideal candidate possesses extensive experience in data warehousing, ETL/ELT pipelines, and cloud technologies (AWS, Azure, GCP). Hakkoda offers a collaborative environment, opportunities for professional growth, and competitive benefits.

Requirements

• Bachelor’s degree in engineering, computer science or equivalent area
• Expertise in evaluating, selecting, and integrating ingestion technologies to solve complex data challenges
• Leadership in architectural decisions for high-throughput data ingestion frameworks, including real-time data processing and analytics
• 5+ years in related technical roles, data management, database development, ETL, Data Warehouses and pipelines
• Experience designing and developing data warehouses (Teradata, Oracle Exadata, Netezza, SQL Server, Spark)
• Experience building ETL / ELT ingestion pipelines with tools like DataStage, Informatica, Matillion
• SQL scripting
• Cloud experience on AWS
• Python Scripting
• Scala is required
• Ability to prepare reports and present to internal and customer stakeholders
• Track record of sound problem-solving skills and action-oriented mindset
• Strong interpersonal skills including assertiveness and ability to build strong client relationships
• Ability to work in Agile teams
• Experienced with SAP for Data
• Experience hiring, developing and managing a technical team
• Advanced English

Responsibilities

• Develop database architectures and data warehouses
• Ensure optimal data delivery architecture is consistent throughout ongoing customer projects
• Lead technical teams
• Work in the design and development of Snowflake Data Cloud solutions
• Develop data ingestion pipelines
• Design data architecture
• Implement data governance and security
• Optimize data systems and build them from the ground up
• Mentor junior engineers in best practices for data ingestion, performance tuning, and troubleshooting
• Prepare reports and present to internal and customer stakeholders

Preferred Qualifications

Experience with Azure and GCP

Benefits

• Medical, Dental, Vision
• Life Insurance
• Paid parental leave
• Flexible PTO Options
• Company Bonus Program
• Work from home benefits
• Technical training and certifications
• Robust learning and development opportunities
• Trip to Costa Rica
• Asociación Solidarista