SQL Developer / Data Warehouse ETL Developer

Location: 100% remote

Payment: USD

Company

hirify.global connects engineers from Latin America with global organizations building long-term products and provides technical and professional growth support.

What you will do

• Write complex SQL queries, stored procedures, views, and functions and translate business requirements into maintainable SQL logic.
• Build data extracts and datasets for reporting and analytics.
• Analyze execution plans, optimize queries and database performance, and resolve performance bottlenecks.
• Design, develop, and maintain ETL/ELT pipelines moving data from source systems or S3 into the enterprise data warehouse.
• Implement data quality checks, validation, error handling, and troubleshooting for ETL failures and data discrepancies.
• Document data flows, mappings, transformations, and technical designs; collaborate with analysts, business users, data engineers, and stakeholders in code reviews.

Requirements

• 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 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, with the ability to work independently and maintain attention to detail.
• Clear written and verbal communication in English is required.
• Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent experience.

Nice to have

• Power BI with DAX, Power Query/M, and data modeling, or Tableau with calculated fields, LOD expressions, and Server/Cloud publishing.
• Amazon Redshift, Snowflake, or Databricks.
• Python for automation and data processing, plus Spark/PySpark.
• Dimensional modeling, star and snowflake schemas, and Kimball/Inmon data warehousing concepts.
• Git/GitHub, CI/CD pipelines for database and ETL deployments, and job scheduling or orchestration.

Culture & Benefits

• 100% remote work on long-term projects.
• Payment in USD and paid time off.
• Work-from-home and training reimbursement.
• English lessons, technical training, and career coaching.
• Growth-oriented environment with individualized personal and professional development support.