BI Data Modeling and Reporting Analyst

Apply now »

Date: 18 Sep 2023

Location: Pune, IN

Company: Tetra Pak

At Tetra Pak we commit to making food safe and available, everywhere; and we protect what's good – protecting food, protecting people, and protecting the planet. By doing so we touch millions of people's lives every day. And we need people like you to make it happen.

Job Summary

BI Data Modeling and Reporting Analyst.

Position is open for : Pune, Bangalore and Gurgaon locations

What you will do

  • You are responsible for understanding the data structure and model them.

  • Using SSIS, ETL to manipulate the data cleanse it for ease of use.

  • Create Tabular models and cubes to create interface for the data.

  • Create Power BI reports to display the data by linking the data and logic in Cubes. Build a Datawarehouse and enable data quality measurement.

  • You are also expected to re-engineer existing SSAS tabular models to improve their extendibility, maintainability and row/role level security.

  • Analyse the data based on use cases for bringing business value like predictive and proactive service management.

We believe you have

  • Minimum 5 years of experience within this field.

  • Expert in the below field / technology

  • Data modeling (Understand the data structure model the data for enterprise use)

  • Datawarehouse/ Datamart

  • Data analytics / PowerBI Report creation / DAX

  • SQL Server and Query language

  • Visual Studio /SSAS /SSIS and Data load

  • Creating Tabular models and Data cubes

  • Re-engineering existing cubes to improve maintainability.

  • Role/row level security

  • Database views and complex joints

  • Concepts like Star & Snowflake schema, Fact & Dimensions, OLTP/OLAP

  • Knowledge in the below area is an advantage

  • Working in Agile/ Scrum framework

  • Microsoft Flow

  • Scripting & Python programming

  • Understanding of Data fabric

We Offer You

  • A variety of exciting challenges with ample opportunities for development and training in a truly global landscape
  • A culture that pioneers a spirit of innovation where our industry experts drive visible results
  • An equal opportunity employment experience that values diversity and inclusion
  • Market competitive compensation and benefits with flexible working arrangements


Apply Now

If you are inspired to be part of our promise to protect what’s good; for food, people, and the planet, apply through our careers page at

This job posting expires on 02/10/2023

If you have any questions about your application, please contact Poonam Agarwal