Analytics Engineer - Digital Media

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 This company is a leading publisher and distributor of audiobooks, producing and delivering a wide range of spoken-word content across fiction, nonfiction, educational, and entertainment categories. It partners with authors, publishers, and narrators to create high-quality audio experiences and distributes content through major digital platforms worldwide. Job Summary This opportunity is ideal for a data professional who thrives at the intersection of analytics engineering, data modeling, and business intelligence. The role focuses on building scalable data solutions within a cloud-based environment, designing and optimizing data models, maintaining reliable pipelines, and ensuring high-quality analytics infrastructure. Working closely with business stakeholders, the successful candidate will translate reporting needs into robust data architectures while supporting BI platforms, documentation standards, and data governance initiatives. Strong SQL expertise, cloud data warehouse experience, and a passion for analytics best practices are essential. Responsibilities Design, build, and maintain scalable data models in Amazon Redshift to support reporting, dashboards, and ad hoc analysis. Collaborate with data engineering teams to expand and optimize the analytics warehouse architecture. Establish and enforce standards for schema design, naming conventions, and data lineage. Develop, maintain, and optimize data pipelines that deliver clean and reliable data to business users. Partner with stakeholders to gather requirements and translate business needs into scalable data solutions. Create and maintain comprehensive data documentation, including metrics definitions and transformation logic. Support BI platforms by ensuring analytics-ready datasets and assisting with dashboard development. Monitor data quality and implement testing, alerting, and validation processes to ensure warehouse reliability. Identify opportunities to improve data accessibility, consistency, and usability across the organization. Promote best practices in analytics engineering, including version control, code reviews, and reproducible workflows. Qualifications and Job Requirements 2–4+ years of experience in Analytics Engineering, Data Engineering, Business Intelligence, Analytics, or Data Science. Strong SQL expertise with the ability to build efficient, scalable, and well-structured queries and data models. Hands-on experience with cloud data warehouse technologies, preferably AWS and Amazon Redshift. Proven ability to work directly with business stakeholders and translate reporting requirements into data architecture solutions. Experience with, or strong interest in, dbt and version-controlled SQL transformation workflows. Solid understanding of data modeling concepts, including dimensional modeling, star schemas, snowflake schemas, and slowly changing dimensions. Experience creating and maintaining clear data documentation, metric definitions, and data catalogs. Familiarity with BI tools such as AWS QuickSight, Tableau, Omni, or similar analytics platforms. Experience with Git and version control best practices for managing SQL, pipelines, and documentation. Strong problem-solving, communication, and analytical skills. Python experience for data pipelines, automation, or data engineering workflows is a strong plus. 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!