Analytics Engineer – Digital Media

This is a fully remote position, open to applicants in Colombia.

📋 Description

• Design, construct, and maintain scalable data models within Amazon Redshift to facilitate reporting, dashboards, and ad hoc analyses.

• Collaborate with data engineering teams to enhance and optimize the architecture of the analytics warehouse.

• Set and uphold standards for schema design, naming conventions, and data lineage.

• Develop, maintain, and optimize data pipelines that provide clean and reliable data to business users.

• Partner with stakeholders to gather requirements and convert business needs into scalable data solutions.

• Create and sustain comprehensive data documentation, including definitions of metrics and transformation logic.

• Support BI platforms by ensuring the availability of analytics-ready datasets and assisting with dashboard creation.

• Monitor data quality and implement testing, alerting, and validation processes to guarantee warehouse reliability.

• Identify opportunities to enhance data accessibility, consistency, and usability across the organization.

• Advocate for best practices in analytics engineering, including version control, code reviews, and reproducible workflows.

⛳️ Requirements

• 2–4+ years of experience in Analytics Engineering, Data Engineering, Business Intelligence, Analytics, or Data Science.

• Strong SQL proficiency with the capability to construct 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 collaborate directly with business stakeholders and translate reporting requirements into data architecture solutions.

• Experience with, or a 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 in creating and maintaining clear data documentation, metric definitions, and data catalogs.

• Familiarity with BI tools such as AWS QuickSight, Tableau, Omni, or other 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.

🏝️ Benefits

• 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.