Remote SQL & Data Warehouse ETL Specialist

South Geeks LLC; Cheyenne (WY); Remote; USD 95,000 - 140,000; Full time

Benefits offered by this job

Remote work

USD payment

PTO

Training reimbursement

English lessons

Career coaching

Long-term projects

Job summary

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

The role requires 3+ years in SQL, ETL, and cloud data warehousing with Snowflake or Databricks, and strong English communication.

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, 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.

Responsibilities

• Write complex, efficient SQL queries, stored procedures and views.
• Translate business requirements into maintainable SQL logic.
• Build data extracts and datasets for reporting and analytics.
• Analyze execution plans to identify performance bottlenecks.
• Suggest and implement performance optimizations including caching and materialized views.
• Monitor database performance and fix issues before users are affected.
• Design, develop, and maintain ETL/ELT pipelines moving data from sources into the warehouse.
• Build data quality checks, validation, and error handling.
• Troubleshoot and resolve ETL job failures and data discrepancies.
• Document data flows, mappings, transformations, and technical designs.
• Collaborate with analysts and business users to clarify requirements and participate in code reviews.

Skills

SQL

ETL pipelines

Data warehousing

Query optimization

Cloud data warehouse

Data quality

English communication

Education

Bachelor's degree

Tools

Snowflake

Databricks

AWS Glue

Informatica

Talend

Job description

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

The role requires 3+ years in SQL, ETL, and cloud data warehousing with Snowflake or Databricks, and strong English communication.