Data Engineer

We are seeking a skilled Data Engineer to design and implement a data store solution for our OTT platform. You will work on creating a system that collects data from our transactional database and prepares it for generating comprehensive reports on viewership, subscriptions, and funnels. This role requires a strong understanding of database architecture, ETL processes, and backend development using Node.js, TypeScript, and PostgreSQL.

Responsibilities

• Design, build, and maintain a data store solution to aggregate data for analytics and reporting.
• Develop efficient ETL pipelines to collect data from the transactional database.
• Work closely with product and data teams to define key metrics for viewership, subscriptions, and funnels.
• Optimize the data store for performance, scalability, and future data needs.
• Ensure data accuracy, consistency, and integrity throughout the pipeline.
• Collaborate with the backend development team to ensure seamless integration with the existing Node.js/TypeScript system.

Requirements

• Proven experience as a Data Engineer or in a similar role.
• Strong proficiency in Node.js and TypeScript.
• Solid experience with PostgreSQL and database design principles.
• Experience building ETL pipelines and working with large datasets.
• Familiarity with data warehousing concepts and analytics platforms.
• Ability to work with transactional databases and handle complex queries.
• Excellent problem-solving skills and attention to detail.
• Strong communication skills and the ability to work in a collaborative environment.

Preferred Qualifications

• Experience in the media or OTT industry.
• Familiarity with reporting tools.
• Experience with cloud-based data solutions (AWS, GCP, etc.).