Principal Data Engineer

Sonatafy Technology; Medellín; A distancia; COP 259.412.000 - 333.531.000; Jornada completa

Descripción de la vacante

A leading nearshore software development company in Medellín is seeking a Principal Data Engineer to lead the redesign and performance optimization of data systems. This hands-on leadership role involves managing data architecture, performance, and governance while collaborating closely with the engineering team. The ideal candidate will have extensive experience in PostgreSQL and data pipeline implementation, along with strong communication skills.

Servicios

Competitive compensation

Remote-first lifestyle

Career growth opportunities

Formación

• 8+ years of experience as a Data Engineer, Database Architect, or Principal Engineer.
• Expert-level proficiency in PostgreSQL schema design and optimization.
• Strong grasp of query planning, indexing, caching, and partitioning.

Responsabilidades

• Analyze and re-architect existing Postgres database for performance.
• Implement near real-time data pipelines for data ingestion.
• Own data platform modernization roadmap with engineering leadership.

Conocimientos

PostgreSQL schema design

Performance tuning

Data pipeline implementation

Communication skills

Collaboration skills

Descripción del empleo

Sonatafy Technology, headquartered in Scottsdale, Arizona, is an award-winning nearshore software development company with a strong reputation. They have a dedicated in-house team of engineers, offering end-to-end software solutions and supporting client development staff augmentation. Catering to companies of all sizes and industries, including some of the world's largest brands, Sonatafy Technology is a trusted provider of nearshore enterprise-level cloud and mobile application software development services.

Sonatafy seeking aPrincipal Data Engineerto lead the redesign and performance optimization of the core data warehouse and related APIs for one of our amazing customers. This is a hands-on leadership role working alongside the Head of Engineering.

Key Responsibilities:

1. Data Architecture & Optimization

• Analyze and re-architect the existing Postgres database to eliminate over-normalization and improve query performance.
• Introduce indexing, partitioning, caching, and replication strategies for high-throughput workloads.

2. Performance & Reliability

• Refactor or replace the current dynamic query engine responsible for 50+ table joins per report.
• Diagnose and resolve bottlenecks in Postgres query planning and execution.
• Implement near real-time data pipelines for weekly ingest (game data) and high-volume read scenarios (API and analytics queries).

3. Data Engineering Leadership

• Own the end-to-end data platform modernization roadmap in partnership with the Head of Engineering.
• Educate internal engineers on modern data engineering principles, act as the internal SME for database and query optimization.

5. Security and Data Governance

• Implement persona-based data access models ensuring strict permission boundaries.
• Maintain compliance and integrity of sensitive team data (e.g., "translations" and play call terminologies).

Required Qualifications:

• 8+ years of experience as a Data Engineer, Database Architect, or Principal Engineer in high-scale, read-heavy systems
• Expert-level proficiency in PostgreSQL schema design, optimization, and performance tuning
• Proven experience re-architecting highly normalized databases for analytical workloads
• Strong grasp of query planning, indexing, caching, and partitioning
• Experience implementing data pipelines and ETL/ELT frameworks across distributed systems
• Strong communication and collaboration skills. Must be proactive, articulate, and comfortable managing stakeholders

Nice to haves:

• Prior work in sports analytics, betting, or media data systems
• Experience with AI-assisted query generation or semantic query systems
• Knowledge of functional programming paradigms (Elixir, Erlang, or similar)

Why Work with Sonatafy?

At Sonatafy, you'll join a community of highly skilled engineers across Latin America supporting innovative U.S.-based teams. You'll be part of a fast-moving, client-first culture where your code has real-world impact. We offer competitive compensation, a remote-first lifestyle, and career growth opportunities across industries and technologies.

If you have reached this point and feel you are our ideal candidate, it's time for you to apply To apply,please submit your resume in English.

Recruitment Scam Notice:

Sonatafy recruitment communications will only come fromemail addresses. We do not request fees, sensitive financial information, or conduct hiring solely through online forms without interviews. If you receive a suspicious message, contact us