Analytics Engineer – Digital Media

Remote from
LATAM flag
LATAM
Annual salary
Undisclosed
Salary information is not provided for this position. Check our Salary Directory to estimate the average compensation for similar roles.
Employment type
Full Time,
Job posted
Apply before
12 Jul 2026
Experience level
Midweight
Views / Applies
13 / 1

About Truelogic

Accelerate Your Digital Transformation

Actively Hiring
Verified job posting
This job post has been manually reviewed for authenticity and compliance.

AI Summary

This role is for an Analytics Engineer at Truelogic, supporting a leading audiobook publisher. The position focuses on building scalable data models and pipelines in Amazon Redshift, collaborating with stakeholders to translate reporting needs into robust data architectures. Ideal candidates have strong SQL expertise, experience with cloud data warehouses, and familiarity with dbt and BI tools. The role emphasizes data quality, documentation, and governance to ensure reliable analytics infrastructure.

Role DNA

Job Complexity
Easy Hard
Pace & Pressure
Relaxed Fast-paced
Autonomy Level
Guided Full Ownership
Communication Load
Independent Highly Collaborative
AI Insight The job requires 2-4+ years of experience and proficiency in SQL, cloud data warehouses, and data modeling, which indicates a moderate difficulty level. The need to work with stakeholders and enforce best practices adds complexity but remains within a mid-senior range.

Salary Analysis

Median Market Rate
$120,000
US Market
$90k – 160k
0 $176k
AI Insight The offered salary is not specified, but based on the role and US market, the typical salary for an Analytics Engineer ranges from $90,000 to $160,000, with a median around $120,000. This is competitive for the required 2-4+ years of experience and technical skills.

Key Skills

SQL Amazon Redshift dbt Data Modeling Business Intelligence Data Pipelines AWS Cloud Data Warehousing Data Governance Data Documentation

Dear Hiring Manager,

I am excited to apply for the Analytics Engineer position at Truelogic. With over three years of experience in analytics engineering and a strong background in SQL, Amazon Redshift, and dbt, I am confident in my ability to design and maintain scalable data solutions that drive business intelligence. My expertise in data modeling and ETL pipelines aligns perfectly with the requirements of this role.

I have collaborated closely with stakeholders to translate reporting needs into robust data architectures, ensuring data quality and consistency. I am passionate about implementing best practices like version control and code reviews to maintain reliable analytics infrastructure. Additionally, my familiarity with BI tools such as QuickSight and Tableau will help support dashboard development seamlessly.

I am eager to contribute to your team's success and help deliver high-quality audio experiences through data-driven insights. Thank you for considering my application.

Sincerely,
[Your Name]

Can you describe your experience with designing and maintaining data models in Amazon Redshift?
I have over 3 years of experience with Amazon Redshift, designing star and snowflake schemas to support reporting. I ensure efficient query performance through proper distribution and sort keys, and I maintain data models using dbt for version control. For example, I reduced query times by 30% by optimizing table design in a project for a media company.
How do you approach translating business requirements into scalable data solutions?
I start by meeting with stakeholders to understand their metrics and reporting needs. I then create a conceptual data model, validate it with the team, and implement it using SQL and dbt. I also set up documentation and data lineage to ensure transparency. For instance, I worked with marketing teams to develop a unified data model for campaign performance.
Describe a time when you had to ensure data quality and reliability in a data pipeline. What steps did you take?
I implemented automated testing with dbt tests and custom validation queries. I also set up monitoring and alerting for data freshness and integrity. In one role, I created a data quality dashboard using QuickSight that tracked anomalies and allowed stakeholders to spot issues early.
How do you stay current with best practices in analytics engineering?
I follow blogs like the dbt Community and AWS Big Data blog, attend webinars, and participate in local meetups. I also enjoy experimenting with new tools in my homelab, such as Snowflake and Airflow. Continuous learning helped me adopt version control workflows that improved team collaboration.
Explain the difference between a star schema and a snowflake schema and when you would use each.
A star schema has denormalized dimensions directly connected to the fact table, which simplifies queries and improves performance. A snowflake schema normalizes dimensions into multiple levels, saving storage but requiring more joins. I use star schema for most BI use cases due to simplicity and speed, but for complex, heavily normalized data sources, snowflake can be appropriate.

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!

Apply now >

This job listing has been manually reviewed by the Jobicy Trust & Safety Team for compliance with our posting guidelines, including verification of the company's legitimacy, accuracy of job details, clarity of remote work policy, and absence of misleading or fraudulent content.

How to apply

Did you apply? Let us know, and we’ll help you track your application.

See a few more

Similar Data Science & Analytics remote jobs

Job Search Safety Tips

Here are some tips to help you search and apply for jobs safely:
Watch out for suspicious jobs Don't apply for jobs that offer high pay for little work or offer to hire you without an interview. Read more ›
Check the employer's profile Make sure you're applying for a trustworthy job by visiting the employer's profile and learning more about them. Read more ›
Protect your information Don't share personal details like your bank account or government-issued ID on suspicious websites or messengers. Read more ›
Report jobs that feel unsafe If you see a job that seems misleading, inappropriate or discriminatory, report it for going against our policies and we'll review it.

Share this job

Jobicy+ Subscription

Jobicy

614 professionals pay to access exclusive and experimental features on Jobicy

Free

USD $0/month

For people just getting started

  • • Unlimited applies and searches
  • • Access on web and mobile apps
  • • Weekly job alerts and digest
  • • Access to additional tools like Bookmarks, Applications, and more

Plus

USD $8/month

Everything in Free, and:

  • • Ad-free experience
  • • Daily job alerts and digest
  • • Personal career consultant
  • • AI-powered job advice
Go to account ›