Remote SQL & Data Warehouse ETL Developer

South Geeks LLC; United States; A distancia; USD 90.000 - 140.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

100% remote work

Payment in USD

PTO

Work-from-home & training reimbursemen

English lessons

Technical training

Career coaching

Descripción de la vacante

South Geeks LLC is seeking an experienced SQL Developer to design, write, and tune complex queries and to build and maintain ETL pipelines feeding the enterprise data warehouse. You will work with data engineers, analysts, and business stakeholders to ensure data is accurate, performs well, and is ready for reporting and analytics.

You will collaborate with data engineers, analysts, and business stakeholders to ensure data is accurate, performant, and ready for reporting, analytics, and

Formación

• 3+ years writing complex SQL (joins, CTEs, window functions).
• 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, preferably Snowflake or Databricks.
• 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.

Responsabilidades

• 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.
• Work with analysts and business users to clarify requirements, and take part in code reviews.

Conocimientos

Complex SQL

Query optimization

ETL development

Cloud data warehousing

Databricks

Informatica

Talend

AWS Glue

Independent worker

English communication

Educación

Bachelor's degree in CS/IS or equivalent

Herramientas

Snowflake

Databricks

AWS Glue

Informatica

Talend

Descripción del empleo

South Geeks LLC is seeking an experienced SQL Developer to design, write, and tune complex queries and to build and maintain ETL pipelines feeding the enterprise data warehouse. You will work with data engineers, analysts, and business stakeholders to ensure data is accurate, performs well, and is ready for reporting and analytics.

You will collaborate with data engineers, analysts, and business stakeholders to ensure data is accurate, performant, and ready for reporting, analytics, and