Remote opportunity at
South GeeksSQL Developer / Data Warehouse ETL Developer
South Geeks is hiring an SQL Developer / Data Warehouse ETL Developer for a remote position. The selected professional will work with a large, mission-driven nonprofit…
Career Tools
About This Role
South Geeks is hiring an SQL Developer / Data Warehouse ETL Developer for a remote position. The selected professional will work with a large, mission-driven nonprofit organization that operates a major data platform serving millions of users. In this role, the developer will build, optimize, and maintain complex SQL queries and enterprise data warehouse ETL pipelines. Responsibilities include collaborating with data engineers, analysts, and business stakeholders to ensure data reliability…
Job Description
South Geeks is hiring an SQL Developer / Data Warehouse ETL Developer for a remote position. The selected professional will work with a large, mission-driven nonprofit organization that operates a major data platform serving millions of users. In this role, the developer will build, optimize, and maintain complex SQL queries and enterprise data warehouse ETL pipelines. Responsibilities include collaborating with data engineers, analysts, and business stakeholders to ensure data reliability and performance for organization-wide reporting and analytics.
This opportunity is ideal for specialists with a strong background in database development and cloud data warehousing. The position involves writing efficient SQL logic, managing data extracts, evaluating execution plans, and implementing performance tuning techniques. Candidates will also handle error validation, data quality checks, and technical documentation while engaging in code reviews and cross-functional communication.
Responsibilities
- Write complex and efficient SQL queries, stored procedures, views, and functions based on business needs
- Construct datasets and data extracts to support analytics and reporting activities
- Examine execution plans to locate and resolve performance bottlenecks
- Deploy performance enhancements such as caching, query rewriting, and materialized views
- Supervise database performance and address issues proactively
- Develop and maintain ELT and ETL pipelines transferring data from source systems or S3 into the data warehouse
- Implement error handling, validation, and data quality checks
- Investigate and correct ETL job failures and data discrepancies
- Document technical designs, data flows, transformations, and mappings
- Coordinate with business users and analysts to clarify requirements and participate in code reviews
Requirements
- Minimum of 3 years of hands-on experience writing advanced SQL including CTEs, joins, window functions, subqueries, and aggregations
- Demonstrated expertise in tuning database performance and optimizing SQL queries by interpreting execution plans
- At least 3 years of experience building ETL processes for data warehouses
- Experience utilizing a cloud-hosted data warehouse such as Snowflake or Databricks
- Familiarity with at least one ETL framework or tool like AWS Glue, Talend, Informatica, Databricks, or similar
- Strong analytical, troubleshooting, and problem-solving capabilities
- Ability to operate independently with minimal supervision and high attention to detail
- Clear written and verbal English communication skills
Qualifications
- Bachelor’s degree in Information Systems, Computer Science, or a related discipline, or equivalent work experience
- Familiarity with Power BI including DAX, data modeling, and Power Query/M, or Tableau involving calculated fields, LOD expressions, and Server/Cloud publishing
- Experience with Amazon Redshift, Snowflake, or Databricks
- Proficiency in Python for data processing and automation, along with Spark or PySpark
- Knowledge of dimensional modeling covering star and snowflake schemas, as well as Kimball or Inmon data warehousing concepts
- Experience with Git, GitHub, CI/CD pipelines for ETL and database deployments, and job scheduling or orchestration tools
Core Skills
Benefits
- Long-term projects
- 100% remote work
- Payment in USD
- Paid Time Off
- Work-from-home and training reimbursement
- English lessons
- Technical training
- Career coaching
Frequently Asked Questions
Answers are based only on the employer’s listing; where it doesn’t say, neither do we.
Is this position remote?
Yes, the posting offers 100% remote work.
What is the salary for this role?
The specific salary is not stated in the job posting, though compensation is paid in USD.
What experience is required for this position?
Applicants need at least 3 years of hands-on experience writing complex SQL, 3 years of experience developing ETL processes for data warehouses, and proven experience optimizing SQL queries and database performance.
What employment type is this?
The role is full-time and involves long-term projects.
Sample Interview Questions
AI-generated questions tailored to this specific role — a preview of the full practice set.