SQL Developer, Data Warehouse ETL Developer

This is a fully remote position, open to applicants in United States.

📋 Description

• Create advanced and efficient SQL queries, stored procedures, views, and functions.

• Transform business requirements into well-organized and maintainable SQL logic.

• Develop data extracts and datasets for reporting and analytical purposes.

• Evaluate execution plans to identify and resolve performance issues.

• Suggest and implement performance enhancements, including query rewriting, caching, and materialized views.

• Oversee database performance and address issues proactively to prevent user impact.

• Design, develop, and maintain ETL/ELT pipelines that transfer data from source systems or S3 into the data warehouse.

• Integrate data quality checks, validation processes, and error handling mechanisms.

• Diagnose and remedy ETL job failures and data inconsistencies.

• Document data flows, mappings, transformations, and technical designs comprehensively.

• Collaborate with analysts and business users to refine requirements and participate in code reviews.

⛳️ Requirements

• A minimum of 3 years of practical experience in writing complex SQL (including joins, CTEs, window functions, subqueries, and aggregations).

• Demonstrated experience in optimizing SQL queries and tuning database performance, including the ability to read and interpret execution plans.

• At least 3 years of experience in developing ETL processes for a data warehouse.

• Familiarity with at least one cloud-based data warehouse, preferably Snowflake or Databricks.

• Proficiency with at least one ETL tool or framework such as Databricks, Informatica, Talend, AWS Glue, or similar.

• Strong analytical, troubleshooting, and problem-solving abilities.

• Capacity to work independently with minimal supervision and possess a keen attention to detail.

• Excellent written and verbal communication skills in English.

• Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent professional experience.

• Familiarity with Power BI (DAX, Power Query/M, data modeling) or Tableau (calculated fields, LOD expressions, Server/Cloud publishing) is a plus.

• Experience with Amazon Redshift, Snowflake, or Databricks is advantageous.

• Knowledge of Python for automation and data processing; Spark/PySpark experience is beneficial.

• Understanding of dimensional modeling (star and snowflake schemas) and data warehousing methodologies (Kimball/Inmon) is a plus.

• Experience with Git/GitHub, CI/CD pipelines for database and ETL deployments, and job scheduling/orchestration is desirable.

🏝️ Benefits

• Engaging long-term projects.

• 100% remote working opportunity.

• Compensation in USD.

• Paid Time Off (PTO).

• Reimbursement for work-from-home expenses and training.

• English language lessons.

• Access to technical training.

• Career coaching support.