Senior Data Engineer (Snowflake/SQL) - Software Industry

About Truelogic At Truelogic we are a leading provider of nearshore staff augmentation services headquartered in New York. For over two decades, we’ve been delivering top-tier technology solutions to companies of all sizes, from innovative startups to industry leaders, helping them achieve their digital transformation goals. Our team of 600+ highly skilled tech professionals, based in Latin America, drives digital disruption by partnering with U.S. companies on their most impactful projects. Whether collaborating with Fortune 500 giants or scaling startups, we deliver results that make a difference. By applying for this position, you’re taking the first step in joining a dynamic team that values your expertise and aspirations. We aim to align your skills with opportunities that foster exceptional career growth and success while contributing to transformative projects that shape the future. Our Client Our client is a technology company specializing in large-scale customer engagement and communication solutions. Their platform processes high volumes of real-time transactional and customer interaction data, helping organizations deliver personalized experiences at scale. Job Summary We are seeking a Senior Database Administrator / Specialist to take ownership of our production database performance and data movement. In this role, you will be the go-to expert for keeping our data systems fast, reliable, and integrated. You will be responsible for building and maintaining robust ETL pipelines that move data from multiple operational AWS PostgreSQL databases into our Snowflake data warehouse, while proactively auditing and tuning SQL queries across our platform to ensure seamless, high-volume message deployment. Responsibilities 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. Qualifications and Job Requirements 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. Nice to Have Skills Python scripting and automation experience. Experience with CDC technologies (Debezium, AWS DMS, Fivetran, etc.). Experience with real-time streaming platforms (Kafka, Kinesis, etc.). Knowledge of compliance frameworks such as TCPA, CTIA, and SOC 2. Bash/Shell scripting experience. Familiarity with monitoring and observability tools (Datadog, CloudWatch, Grafana, etc.). What We Offer 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. Why You’ll Like Working Here A Culture That Values You: We prioritize well-being and work-life balance, offering engagement activities and fostering dynamic teams to ensure you thrive both personally and professionally. Diverse, Global Network: Connect with over 600 professionals in 25+ countries, expand your network, and collaborate with a multicultural team from Latin America. Team Up with Skilled Professionals: Join forces with senior talent. All of our team members are seasoned experts, ensuring you're working with the best in your field. Apply now!