Senior Data Engineer (Snowflake/SQL) - Software Industry

🕒 Ontem

Candidatar-se

Encontrar Vagas Remotas Similares

Configurar Alerta de Email para Novas Vagas

📊 Verifique sua pontuação de currículo para esta vaga

Melhore suas chances de conseguir uma entrevista verificando sua pontuação de currículo antes de se candidatar.

Enviar Currículo

Truelogic Software

SiteLinkedInTodas as Vagas

501 - 1000 funcionários

Fundada em 2004

☁️ SaaS

🤝 B2B

🏢 Corporativo

SaaS • B2B • Enterprise

Truelogic Software é uma empresa de desenvolvimento de software nearshore especializada em serviços de staff augmentation ágil. Focamos em oferecer desenvolvimento de software sob medida terceirizado, com uma equipe de engenheiros altamente qualificados da América Latina. A Truelogic Software faz parceria tanto com startups quanto com empresas da Fortune 500, oferecendo soluções alinhadas aos fusos horários de seus clientes e garantindo resultados de alta qualidade por meio de colaboração e agilidade na resposta. Com presença em mais de 25 países, a Truelogic valoriza o trabalho remoto para uma melhor qualidade de vida, e seus engenheiros têm experiência em diversos setores, entregando uma ampla variedade de projetos bem-sucedidos globalmente.

Descrição

• Data Pipeline Execution (ETL): Build, manage, and monitor efficient ETL/ELT pipelines to consolidate data from multiple production AWS PostgreSQL instances into Snowflake for analytics and reporting. • Advanced Query Auditing & Performance Tuning: Continuously audit SQL queries across our production systems. Diagnose complex bottlenecks, rewrite sub-optimal queries, optimize indexes, and tune database configurations to ensure peak platform speeds. • Database Operations & Maintenance: Oversee the day-to-day health, backup strategies, security compliance, and scaling of our PostgreSQL (AWS RDS/Aurora) and Snowflake environments. • Query Best Practices & Collaboration: Partner with Software Engineers to review database schemas and queries before they hit production, acting as a trusted advisor on SQL best practices. • Troubleshooting & Optimization: Serve as the senior escalation point for database performance issues, ensuring minimal downtime and high availability for our core SMS services.

🎯 Requisitos

• 5+ years of experience in a heavily database-focused Data Engineering role. • Snowflake Proficiency: Strong experience working with Snowflake, including data loading, performance tuning, and warehouse cost management. • PostgreSQL Expertise: Deep hands-on experience managing and tuning PostgreSQL databases, specifically within the AWS ecosystem (RDS or Aurora). • Advanced SQL Profiling: Exceptional skills in query profiling, execution plan analysis (EXPLAIN), partition strategies, and index optimization. • Hands-on ETL/ELT: Proven experience building and maintaining data pipelines using tools like dbt, Airflow, AWS Glue, or custom Python scripting. • Data Migration & Synchronization: Core experience using AWS Data Migration Service (DMS) to move and continuously synchronize data between relational databases and data warehouses. • Version Control: Absolute proficiency with Git.

🏖️ Benefícios

• 100% Remote Work: Enjoy the freedom to work from the location that helps you thrive. All it takes is a laptop and a reliable internet connection. • Highly Competitive USD Pay: Earn an excellent, market-leading compensation in USD, that goes beyond typical market offerings. • Paid Time Off: We value your well-being. Our paid time off policies ensure you have the chance to unwind and recharge when needed. • Work with Autonomy: Enjoy the freedom to manage your time as long as the work gets done. Focus on results, not the clock. • Work with Top American Companies: Grow your expertise working on innovative, high-impact projects with Industry-Leading U.S. Companies.