SQL Developer / Data Warehouse ETL Developer

South Geeks•Wyoming, NY

3d•Remote

About The Position

South Geeks connects engineers from Latin America with global organizations building long-term products. Its client is a mission-driven nonprofit operating a large data platform used by millions. The client’s data team depends on accurate, high-performing data for reporting and analytics. The SQL Developer will design, write, and tune complex queries and build and maintain ETL pipelines that feed the enterprise data warehouse. The role collaborates with data engineers, analysts, and business stakeholders to ensure data is accurate, performs well, and is ready for reporting and analytics.

Requirements

At least 3 years of hands-on experience writing complex SQL, including joins, CTEs, window functions, subqueries, and aggregations.
Proven experience optimizing SQL queries and tuning database performance, including reading and interpreting execution plans.
At least 3 years of experience developing ETL processes for a data warehouse.
Experience with at least one cloud-hosted data warehouse; Snowflake or Databricks preferred.
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 Haves

Power BI experience, including DAX, Power Query/M, and data modeling, or Tableau experience, including calculated fields, LOD expressions, and Server/Cloud publishing.
Amazon Redshift, Snowflake, or Databricks experience.
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.

Responsibilities

Write efficient SQL queries, stored procedures, views, and functions.
Translate business requirements into well-structured, maintainable SQL logic.
Build data extracts and datasets for reporting and analytics.
Analyze execution plans and address performance bottlenecks.
Recommend and implement optimizations such as query rewriting, caching, and materialized views.
Monitor database performance and resolve issues proactively.
Design, develop, and maintain ETL/ELT pipelines moving data from source systems or S3 into the warehouse.
Implement data quality checks, validation, and error handling.
Troubleshoot ETL job failures and data discrepancies.
Document data flows, mappings, transformations, and technical designs.
Clarify requirements with analysts and business users and participate in code reviews.