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

A global insights and strategy organization specializing in media, entertainment, and technology. The company provides data-driven intelligence and analytics platforms that help organizations understand audiences, content performance, and growth opportunities across digital and connected media environments.

Job Summary

The Senior Data Warehouse Engineer will be responsible for designing, building, and optimizing enterprise data warehouse solutions that power analytics and reporting across the organization. This role focuses on developing scalable data integration pipelines, managing warehouse performance, and ensuring strong data governance across modern database platforms.

You will work closely with engineers, product managers, DevOps, QA, and business stakeholders to deliver reliable data infrastructure that supports analytics professionals and decision-makers across the organization. The ideal candidate combines deep database expertise with experience building automated data pipelines and maintaining high-performance warehouse environments.

Responsibilities

• Design, develop, and maintain data warehouse solutions that support analytics and reporting across multiple teams.

• Build and manage data integration workflows using ETL/ELT tools such as dbt or SSIS.

• Optimize warehouse performance through query tuning, indexing strategies, and resource management.

• Develop stored procedures, optimized SQL scripts, and database objects across warehouse technologies.

• Implement and maintain user access controls including roles, permissions, and governance policies.

• Enforce data quality and integrity through automated validation scripts and cleansing workflows based on business rules.

• Monitor and troubleshoot warehouse performance issues and production data workloads.

• Support production deployments and ensure stability and reliability of warehouse environments.

• Collaborate with engineering and product teams to deliver scalable data solutions supporting analytics initiatives.

Qualifications and Job Requirements

• Advanced knowledge of Snowflake, PostgreSQL, Oracle, or Redshift, including scripting and warehouse management.

• Strong experience developing ETL/ELT pipelines using tools such as dbt or SSIS.

• Expertise in SQL scripting, stored procedures, and query optimization across database platforms.

• Solid understanding of database architecture, backup strategies, and data security practices.

• Experience implementing roles, user access management, and permission controls in data warehouse environments.

• Strong experience with data pipeline automation and warehouse performance tuning.

• Ability to manage multiple concurrent projects with strong organizational and communication skills.

• Self-motivated mindset with the ability to work independently while collaborating across teams.

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!