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