Power BI Engineering Analytics
Critical Software · Lisbon, Lisbon, Portugal
- On site
- Full-time
- $85,000 / year
- Lisbon, Lisbon, Portugal
This role may have been filled. Drop your résumé and we'll check if it's still open — or find you similar roles.
Job highlights
- Analyze rail data using Power BI.
- Design and maintain Power BI dashboards.
- Develop data warehouses and ETL processes.
- Utilize SQL, Python, and PowerShell for data.
- Collaborate with stakeholders for data insights.
About the role
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
Skills & topics
- Power BI
- Data Analytics
- Data Engineering
- Business Analysis
- SQL Server
- ETL
- Python
- PowerShell
- Data Warehousing
- Requirements Engineering
- Critical Software
- Stadler Digital Labs
- Rail Technology
- Microsoft Ecosystem
How to get hired
- Tailor your resume: Highlight Power BI, SQL, ETL, Python, and analysis experience relevant to Critical Software and Stadler Digital Labs.
- Showcase your skills: Quantify achievements in data modeling, dashboard creation, and data integration projects.
- Demonstrate your fit: Emphasize your passion for rail technology and collaborative spirit in your application.
- Prepare for interviews: Be ready to discuss your technical expertise in data engineering and your approach to stakeholder engagement.
- Network and learn: Explore Stadler Digital Labs' website and industry trends to inform your questions and discussions.
Technical preparation
Master Power BI data modeling and DAX.,Practice SQL queries and database optimization.,Build sample ETL pipelines with SSIS.,Script data transformations in Python.
Behavioral questions
Describe a complex data problem you solved.,How do you handle conflicting stakeholder needs?,Share an experience of learning a new technology.,How do you ensure data quality in projects?
Frequently asked questions
- What are the core responsibilities of a Power BI Engineering Analytics at Critical Software?
- As a Power BI Engineering Analytics at Critical Software, you will be responsible for designing and maintaining Power BI reports and dashboards, translating business requirements into effective data models and visualizations, developing data warehouses, and optimizing ETL processes. You'll also be involved in data validation, quality assurance, and automation using Python and PowerShell.
- What is the required academic background for this Power BI Engineering Analytics role?
- The role requires an academic background in Engineering or a related field such as Software, Electronics, Physics, or Mathematics. This provides a strong foundation for the analytical and technical demands of the position.
- How much experience is needed for the Power BI Engineering Analytics position at Critical Software?
- Critical Software is looking for candidates with at least 3 years of relevant professional experience, specifically in requirements engineering and business analysis for data projects within the Microsoft ecosystem, including Power BI and SQL Server.
- What programming languages and tools are essential for this Power BI Engineering Analytics job?
- Proficiency in Power BI, Microsoft SQL Server, SSIS, SSRS, SSAS, and T-SQL is crucial. Additionally, hands-on experience with data migration, transformation, automation, and scripting using Python and PowerShell is highly valued.
- What kind of data sources will I be working with as a Power BI Engineering Analytics at Critical Software?
- You will integrate data from multiple heterogeneous sources, including enterprise systems like SAP and Oracle, as well as databases such as MariaDB, Postgres, Progress, and flat files. This requires strong know-how in ETL process design and data mapping.
- Does Critical Software offer remote work for this Power BI Engineering Analytics position?
- The job description emphasizes 'Offices designed to make you feel like you belong' and 'Home Office Support,' suggesting a flexible or hybrid arrangement. Specific remote work details would need to be confirmed directly with the hiring team.
- What are the benefits of working at Critical Software, specifically for the Stadler Digital Labs venture?
- Critical Software offers a comprehensive benefits package including Private Health Insurance, Employee Assistance Programme, Home Office Support, Extra Holidays, Extra Parental Leave, Flex-time, Gradual Return to Work Support, and a Sabbatical programme, alongside a culture that values work-life balance and professional growth.