Senior Data Engineer (2097)

Location: Remote from LATAM Contract Type: Full-time Contractor Time Zone Alignment: CT About In All Media We are a Managed Nearshore Teams provider headquartered in Austin, specializing in building and embedding high-performing software development teams. From design to deployment, we deliver customized solutions by connecting global talent with innovative client projects. Our model lets you tackle international challenges, collaborate with diverse teams, and grow your career while being part of a company that values expertise, creativity, and impact. Project Overview In this role, you will be a key player in our data operations, supporting a high-impact project focused on building, optimizing, and maintaining robust data pipelines and database architectures. You will join a collaborative, fast-paced team dedicated to ensuring data quality, performance, and seamless integration across both relational and document-based systems. The project involves designing complex schemas, optimizing queries, and deploying automated pipelines to support advanced data science and engineering efforts. As a critical member of the team, you will drive production support, implement agile continuous delivery methodologies, and deliver highly reliable, scalable data solutions. Key Responsibilities Database & Schema Design: Design, model, and maintain complex data structures across relational (MS SQL Server) and document-based (MongoDB) systems, resolving data quality issues as needed. Performance & Optimization: Write complex queries, develop stored procedures, and perform deep indexing and query performance tuning to ensure high-speed data retrieval and system reliability. Pipeline & Deployment Management: Execute automated pipeline deployments and migrate schemas into production environments, applying agile methods and continuous delivery concepts. API & Backend Support: Build and maintain secure, high-performing data pipelines and APIs, leveraging your experience with REST, JSON, and strict security and testing standards. Quality Assurance & Strategy: Drive test strategies and test automation, maintaining a strong focus on data quality, problem-solving, and simplicity in software design. Production Delivery: Ship, maintain, and troubleshoot production software products in a fast-moving environment where attention to detail and quality are highly prized. Must-Have Skills Education & Experience: BS in Computer Science and a minimum of 5+ years of experience delivering production solutions, including a minimum of 5+ years working in Data Science or Data Engineering. Relational Databases Mastery: Strong production experience with MS SQL Server, including schema design, complex query writing, stored procedure development, indexing, and query performance tuning. NoSQL Expertise: Hands-on MongoDB experience, including document modeling and successfully integrating NoSQL systems with relational databases. Data Modeling & Quality: Proven…