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