Sr. Process Associate - FPS (Power BI)

Siemens

The Role

Overview

Design and develop Power BI dashboards and data models for finance & procurement.

Key Responsibilities

  • dashboard development
  • data modeling
  • refresh scheduling
  • source integration
  • advanced visuals
  • dax calculations

Tasks

-Conduct performance optimization of reports and dashboards to ensure fast load times and seamless user experience -Design, develop, and deploy interactive dashboards and reports using Power BI Desktop -Develop and implement robust data models that ensure accuracy, efficiency, and scalability -Identify areas and processes where Microsoft 365 and Office 365 can be better leveraged and facilitate process improvement. -Set up and configure auto refresh schedules to ensure data is always up to date -Configure and manage incremental refresh strategies to optimize data loading and performance -Establish and manage connections to multiple data sources including Snowflake, SQL databases, APIs, and OneDrive -Build advanced visualizations including asymmetric matrix concepts and other custom visual solutions -Apply proper visualization techniques and best practices to create intuitive and user-friendly reports -Design and implement Power BI Dataflows for data preparation and transformation -Create complex calculations and measures using DAX (Data Analysis Expressions) and Time Intelligence functions.

Requirements

  • azure
  • snowflake
  • power apps
  • sql
  • etl
  • bachelor's

What You Bring

-Experience with Microsoft Azure cloud -Knowledge of DBT and Snowflake will be added advantage. -Understanding of data warehouse concepts and ETL processes -Strong analytical and problem-solving skills -Excellent communication and collaboration abilities -Knowledge of software development principles and lifecycle -Capable of troubleshooting common database issues -Knowledge of SQL and RDBMS technologies. -1years to 3 years of relevant experience to do primary responsibilities mentioned above -Knowledge of Power Apps and Power Automate will be added advantage. -Experience with Power Query (M language) -Min. bachelor’s degree in computer science or related discipline -Microsoft certifications from related areas – DA100, PL-900, PL-600, PL-400, AZ-900

The Company

About Siemens

-The company drives progress with solutions in electrification, automation, and digitalization across industries. -With cutting-edge products and services, it leads sustainable innovation for industries like energy, manufacturing, and infrastructure. -Its impressive portfolio includes smart grids, automated factories, advanced healthcare technologies, and solutions for urban mobility. -Siemens’ digital solutions enhance efficiency and sustainability in everything from smart buildings to electric vehicles. -It has contributed to iconic projects, including energy-efficient train systems and automation in key industrial sectors. -Transforming how industries use digital technology to optimize operations and tackle global challenges.

Sector Specialisms

Industrial Automation

Building Automation

Rail Transport

Health Technology

Factory Automation

Process Industries

Pharmaceuticals

Chemicals

Food and Beverage

Electronics

Semiconductors

Power Systems

Healthcare

Transportation

Energy

Infrastructure

Digital Industries

Industrial Control Systems

Sensors

Radio-Frequency Identification

Product Lifecycle Management

Simulation and Testing

Cloud-based IoT

Software as a Service

Digital Twins