Assistant Manager - Power BI

John Cockerill, enablers of opportunities Driven since 1817 by the entrepreneurial spirit and thirst for innovation of its founder, the John Cockerill Group develops large-scale technological solutions to meet the needs of its time: facilitating access to low carbon energies, enabling sustainable industrial production, preserving natural resources, contributing to greener mobility, enhancing security and installing essential infrastructures. Its offer to businesses, governments and communities consists of services and associated equipment for the sectors of energy, defence, industry, the environment, transports, and infrastructures. With over 6,000 employees, John Cockerill achieved a turnover of € 1,209 billion in 2023 in 29 countries, on 5 continents. www.johncockerill.com

Location - Mumbai, India

Job Purpose As a Power BI Specialist, your main responsibilities will include understanding end user’s needs, translating them into analytical models, creating interactive dashboards, reports, apps with Power BI, testing the deliverables, deploying the solution, and ensuring knowledge transfer to end users.

Key Responsibilities

• Collaborate with stakeholders to understand and meet their data analysis needs.
• Develop and maintain Power BI dashboards and reports.
• Use Power Query for data transformation and manipulation.
• Write advanced DAX formulas for complex business calculations.
• Implement dimensional modelling (star schema) for efficient data organization.
• Manage semantic models’ data refreshes.
• Implement Power BI Row Level Security (RLS) to provide data access based on user roles.
• Create and manage dataflows to automate data updates.
• Write SQL queries for data extraction and analysis.
• Organize backlog in the Jira ticketing tool.
• Write comprehensive documentation.

Deliverables

• Dimensional modelling (star schema)
• Power BI dataflows
• Power BI datasets/semantic models
• Power BI reports
• Power BI dashboards
• Power BI apps

Education & Experience

• Bachelor of Engineering.
• 1-3 Years of relevant experience.

Certifications

• PL-300: Microsoft Power BI Data Analyst is an asset.

Soft Skills Background, Skills and Competencies

• Excellent problem-solving skills
• Excellent communication skills in English both written and verbal is mandatory for this role.
• Proven international experience in a multi-cultural environment is mandatory for this role.
• Able to convert business requests into business requirements.

Mandatory Technical skills:

• Proficiency with Power Query.
• Proficiency with DAX.
• Proficiency with dimensional modelling (star schema).
• Proficiency with SQL.
• Proficiency with Power BI report development.
• Proficiency with Power BI dataset/semantic model development.

Considered An Asset

• Knowledge of Power BI Row Level Security.
• Knowledge of Power BI dataflows.
• Knowledge of Power BI portal administration.
• Knowledge of Microsoft Azure.
• Knowledge of Jira Service Management
• Knowledge of Microsoft Power Platform
• Knowledge of Microsoft Fabric
• Knowledge of Agile/SCRUM.

Equal Opportunity Employer John Cockerill and all John Cockerill Companies are equal opportunity employers that evaluate qualified applicants without regard to race, color, national origin, religion, ancestry, sex (including pregnancy, childbirth and related medical conditions), age, marital status, disability, veteran status, citizenship status, sexual orientation, gender identity or expression, and other characteristics protected by law. John Cockerill offers you career and development opportunities within its various sectors in a friendly working environment. Do you want to work for an innovative company that will allow you to take up technical challenges on a daily basis? We look forward to receiving your application and to meeting you! Discover our job opportunities in details on www.johncockerill.com