Senior Principle Data Engineer, Digital Business

Position: Lead Data Engineer - Data Warehouse, Digital Business

Purpose: This position is required to provide technology leadership on medium to large scale products/platform with internal and direct customer impact.

Education: B.E./B.Tech, MCA or Equivalent Computer Degree

Purpose:

Big Data team is responsible for providing the cloud-native platform for distributed data processing at SonyLiv, working with Spark, Presto as well as other supporting technologies. This team is central to batch data processing in Data Platform at SonyLiv. It provides support for Spark, to ETL data into the Petabytes-scale data warehouse and access that data using Spark and Presto & different Columnar Db like Redshift. It also provides sub-second latency for a certain class of queries using Timeseries Db for monitoring. This team will collaborate with different stakeholder like Marketing, Analytics team, sales team, content team to organises, classify, filter and structure data to make them available for their queries.

Location: Bengaluru

Reporting Relationship: Engineering Manager, Digital Business

Business/Channel/Function: Digital

Experience:

• + years in data-related AWS Cloud services
Have
• + year of experience in ClickHouse or any other OLAP system
• Mandatory to have knowledge of RedShift, Presto and BigQuery
• Good to have experience in Druid.
• Expert in SQL, Hive
• Worked on at least one distributed data processing framework: Spark (Core, Streaming, SQL), Storm or Flink, etc.
• Experience is building data warehouse for Marketing, sales and content team will be added advantage.

Roles & Responsibility

• Establish and enforce Data Model, Data Warehouse, ETL, and BI standards
• Gather and review analytical needs of key groups such as Sales & Marketing, Finance and Manufacturing
• Train internal customers on available technologies
• Analyse, document, develop, integrate, and deploy analytics as per business needs
• Carry out monitoring and performance tuning in EDW, ETL and BI environments
• Create, Manage the BI reports and Alerts for Product and Business requirement.

Why join us?

Sony Pictures Networks is home to some of India’s leading entertainment channels such as SET, SAB, MAX, PAL, PIX, Sony BBC Earth, Yay!, Sony Marathi, Sony SIX, Sony TEN, SONY TEN1, SONY Ten2, SONY TEN3, SONY TEN4, to name a few!

Our foray into the OTT space with one of the most promising streaming platforms, Sony LIV brings us one step closer to being a progressive digitally-led content powerhouse.

Our independent production venture- Studio Next has already made its mark with original content and IPs for TV and Digital Media.

But our quest to Go Beyond doesn’t end there. Neither does our search to find people who can take us there.

We focus on creating an inclusive and equitable workplace where we celebrate diversity with our Bring Your Own Self Philosophy. We strive to remain an ‘Employer

- 100 Best Companies for Women in India by AVTAR & Seramount for years in a row - UN Women Empowerment Principles Award 2022 for Gender Responsive

The biggest award of course is the thrill our employees feel when they can Tell Stories Beyond the Ordinary!