SQL Developer / Data Warehouse ETL Developer

The role

An experienced SQL Developer will design, write, and tune complex queries and build and maintain ETL pipelines for an enterprise data warehouse. You will work with data engineers, analysts, and business stakeholders to ensure data accuracy and performance for reporting and analytics.

What you will do

• Write complex, efficient SQL queries, stored procedures, views, and functions.
• Turn business requirements into well-structured, maintainable SQL logic.
• Build data extracts and datasets for reporting and analytics.
• Analyze execution plans to find and fix performance bottlenecks.
• Recommend and implement performance optimizations such as query rewriting, caching, and materialized views.
• Monitor database performance and fix issues before they affect users.
• Design, develop, and maintain ETL/ELT pipelines that move data from source systems or S3 into the warehouse.
• Build in data quality checks, validation, and error handling.
• Troubleshoot and resolve ETL job failures and data discrepancies.
• Document data flows, mappings, transformations, and technical designs.

Required qualifications

• 3+ years of hands-on experience writing complex SQL (joins, CTEs, window functions, subqueries, aggregations).
• Proven experience optimizing SQL queries and tuning database performance, including reading and interpreting execution plans.
• 3+ years of experience developing ETL processes for a data warehouse.
• Experience with at least one cloud-hosted data warehouse.
• Experience with at least one ETL tool or framework such as Databricks, Informatica, Talend, AWS Glue, or similar.
• Strong analytical, troubleshooting, and problem-solving skills.
• Ability to work independently with little supervision and strong attention to detail.
• Clear written and verbal communication in English.
• Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent experience.

Nice to have

• Power BI (DAX, Power Query/M, data modeling) or Tableau (calculated fields, LOD expressions, Server/Cloud publishing).
• Amazon Redshift, Snowflake, or Databricks.
• Python for automation and data processing; Spark/PySpark.
• Dimensional modeling (star and snowflake schemas) and data warehousing concepts (Kimball/Inmon).
• Git/GitHub, CI/CD pipelines for database and ETL deployments, and job scheduling/orchestration.

Benefits

• Long-term projects
• 100% remote work
• Payment in USD
• Paid Time Off (PTO)
• Work-from-home & training reimbursement
• English lessons
• Technical training
• Career coaching

About the company

South Geeks connects top-performing engineers from Latin America with global organizations building meaningful, long-term products.