Senior Data Engineer – Media & Entertainment Analytics | Mexico at Truelogic

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 Engineer will join a collaborative team responsible for building and enhancing data-driven applications and platforms used by professionals across the entertainment and technology industries. In this role, you will work closely with organizational leaders, product managers, technical project managers, QA engineers, DevOps engineers, and client service stakeholders to implement new features and products. The ideal candidate is a self-driven engineer who can work independently while contributing to a highly collaborative environment, focusing on developing scalable data solutions, optimizing data warehouses, and ensuring reliable, high-quality data pipelines. RESPONSIBILITIES - Design, develop, and maintain scalable data integration solutions using ETL tools such as dbt and SSIS. - Develop optimized scripts and stored procedures across database and data warehouse platforms. - Build and maintain data pipelines and implement modern automation practices for data processing workflows. - Perform database performance tuning and optimization for data warehouses and queries. - Implement and manage database security, including user management, roles, and permissions based on approval processes. - Enforce data integrity and quality by developing automated scripts and guardrails for data cleansing based on business logic. - Support deployment and maintenance of database solutions in production environments. - Collaborate with cross-functional teams including engineering, product, QA, DevOps, and client services to deliver data-driven features and solutions. - Contribute to database design, development, and best practices for networking concepts and system architecture. QUALIFICATIONS AND JOB REQUIREMENTS - Advanced knowledge of data warehouse and database technologies including Snowflake (SnowSQL/T-SQL), PostgreSQL (PL/pgSQL), Oracle (PL/SQL), and/or Redshift. - Experience designing and implementing ETL and data integration solutions using tools such as dbt and SSIS. - Strong experience with database performance tuning, query optimization, and warehouse optimization. - Experience managing database users, roles, permissions, and access control mechanisms. - Knowledge of database backup strategies and data security best practices. - Strong experience writing optimized scripts and stored procedures across database technologies. - Understanding of data pipelines and modern data pipeline automation techniques. - Experience deploying database and data solutions in production environments. - Ability to manage multiple projects simultaneously while maintaining high productivity and communication standards. - Strong collaboration skills with the ability to work independently in a fast-paced environment. 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!