Power BI Engineering Analytics

About Critical Software and Stadler Digital Labs

The future of rail isn’t just about movement, it’s about intelligence, security, and connection. Critical Software unites rail expertise with digital innovation to create smarter, safer, and more sustainable transportation solutions. Technology here speaks with purpose: accelerating digitalization, embedding cybersecurity, and shaping the next era of rail. Behind every breakthrough are people, their talent, creativity, and drive to push boundaries. Together, we’re building confidence, resilience, and a new standard for connected mobility powered by innovation.

This position is for Stadler Digital Labs, a joint venture between Stadler Rail and Critical Software serving as the digital competence center for the Stadler Group. Visit their website: https://stadlerdigitallabs.com

About The Role

We are seeking a Power BI Engineering Analytics professional to join our team. You will be instrumental in translating business requirements into insightful Power BI data models and visualizations. This role involves designing, developing, and optimizing data solutions within the Microsoft ecosystem, ensuring data reliability and consistency through rigorous validation and testing.

Responsibilities

• Design and maintain Power BI reports and dashboards for business stakeholders.
• Translate business requirements into effective Power BI data models and visualizations.
• Design, develop, and optimize data warehouse solutions using Microsoft SQL Server, SSIS, SSRS, SSAS, and T-SQL.
• Design ETL processes, including data mapping and integration from various heterogeneous sources (e.g., SAP, Abacus, Oracle, MariaDB, Postgres, Progress, flat files).
• Perform data validation, quality assurance, and testing to ensure data reliability and consistency.
• Conduct data migration, transformation, and automation using Python and PowerShell scripting.
• Produce comprehensive technical and functional documentation.
• Engage effectively with stakeholders and provide cross-departmental support.

Qualifications

• Academic background in Engineering or similar (Software, Electronics, Physics, Mathematics, etc.).
• At least 3 years of relevant professional experience in requirements engineering and business analysis for data projects within the Microsoft ecosystem.
• Proven skills in Power BI report and dashboard design and maintenance.
• Strong experience in data warehouse (DWH) design, development, and optimization using Microsoft SQL Server, SSIS, SSRS, SSAS and T-SQL.
• Proficiency in ETL process design, data mapping, and integration from multiple heterogenous sources.
• Experience with data validation, quality assurance, and testing methodologies.
• Hands-on experience in data migration, transformation, automation, and scripting using Python and PowerShell.
• Ability to produce clear technical and functional documentation.
• Excellent stakeholder engagement and cross-departmental support skills.
• Fluent in English.
• Passionate, driven, curious, and eager to share and learn.

What We Provide

• Work that fits your life, not the other way around.
• Offices designed to make you feel like you belong.
• A team that knows how to work hard, but also how to have fun.
• Competitive pay and performance-based rewards.
• Growth opportunities: training, support, and advancement.

Perks With Purpose

• Private Health Insurance.
• Employee Assistance Programme.
• Home Office Support.
• Extra Holidays.
• Extra Parental Leave.
• Flex-time.
• Gradual Return to Work Support.
• Away From Keyboard - Sabbatical programme.

Key skills/competency

• Power BI
• Data Analytics
• Data Engineering
• Business Analysis
• SQL Server
• ETL
• Python
• PowerShell
• Data Warehousing
• Requirements Engineering