SQL Developer / Data Warehouse ETL Developer
South Geeks9 days ago
Remote, AmericasMid Level
Responsibilities
- Write complex SQL queries, stored procedures, views, functions, and maintainable SQL logic from business requirements.
- Build datasets and data extracts for reporting and analytics.
- Analyze execution plans and optimize query and database performance through query rewriting, caching, and materialized views.
- Monitor database performance and resolve issues before they affect users.
- Design, develop, and maintain ETL/ELT pipelines from source systems or Amazon S3 into the data warehouse.
- Implement data quality checks, validation, and error handling, and troubleshoot ETL failures and data discrepancies.
- Document data flows, mappings, transformations, and technical designs.
- Collaborate with data engineers, analysts, business users, and stakeholders, including participating in code reviews.
Requirements
- At least 3 years of hands-on experience writing complex SQL, including joins, CTEs, window functions, subqueries, and aggregations.
- At least 3 years of experience developing ETL processes for a data warehouse.
- Proven experience optimizing SQL queries, tuning database performance, and interpreting execution plans.
- Experience with at least one cloud-hosted data warehouse, preferably Snowflake or Databricks.
- Experience with an ETL tool or framework such as Databricks, Informatica, Talend, AWS Glue, or similar.
- Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent experience.
- Power BI or Tableau experience is preferred.
- Experience with Amazon Redshift, Snowflake, Databricks, Python, Spark/PySpark, dimensional modeling, data warehousing concepts, Git/GitHub, CI/CD pipelines, and job scheduling/orchestration is preferred.
- Strong analytical, troubleshooting, problem-solving, communication, independence, and attention-to-detail skills are required.
Benefits
- 100% remote work.
- Long-term projects.
- Payment in USD.
- Paid Time Off (PTO).
- Work-from-home and training reimbursement.
- English lessons, technical training, and career coaching.
Tech Stack
Categories
Data Engineering
About South Geeks
Our mission is to power the evolution of leading companies in Fintech and Life Sciences by curating elite engineers from Latin America. We focus on agile and precision hiring and caring for the people who take care of our clients, building long-lasting strategic partnerships. With more than 8 years of experience and 200+ engineers in 8 countries deployed across 50+ challenging projects, South Geeks is proud to boost sustainable business and successful career paths.