MS Fabric PBI Architect - Data Domain Deliver & Material Supply (m/f/d)

Job description

At Siemens, we build technology solutions to shape the world we live in. We transform industries and societies by combining the real and digital worlds. With over 300.000 of the world’s most forward-thinking minds and the power of a presence in more than 190 countries, we make a truly global impact. About Portugal Tech Hub We take on challenges to make life easier, safer, and more sustainable for us and generations to come. We bring value to the business digitalization transition, from Portugal to the world, in areas such as Artificial Intelligence, Analytics & Business Intelligence, Application Lifecycle Management, Cybersecurity, IT Infrastructure Management, IT Project & Service Management, IT Strategy, User Experience, and many more. With a decade of history and around 1.600 experts, the Portugal Tech Hub is the home of the new technologists – Dream Builders, Impact Creators & Future Makers. Are you ready to be part of the change? Come join us! ⭐ Your mission will be… We are seeking a highly skilled and experienced Senior MS Fabric Expert and Architect to lead the strategic design, advanced data modeling, and performance optimization of our enterprise business intelligence solutions. This pivotal role involves taking full ownership of the architectural landscape, ensuring data is structured, governed, and optimized to deliver scalable, high-performance insights. The successful candidate will serve as a principal authority on our BI architecture and data modeling, guiding best practices, ensuring data integrity, and translating complex business data into robust, actionable intelligence that drives strategic decision-making across the organization. Key Responsibilities: Assume full ownership and accountability for the strategic architectural design, robust development, and comprehensive governance of enterprise-level Fabric (Power BI) solutions, ensuring seamless alignment with overall BI strategy and critical business objectives. Lead the design, development, and optimization of complex Power BI data models, leveraging advanced DAX and Power Query techniques to ensure scalability, performance, and data integrity. Serve as the principal authority and subject matter expert for Power BI architecture and data modeling, establishing and enforcing best practices for data structure, security, deployment, and lifecycle management within the Power BI ecosystem. Collaborate closely with data engineers, data scientists, and business stakeholders to meticulously understand data requirements, define key performance indicators (KPIs), and architect underlying data structures that enable accurate and insightful reporting. Drive the adoption of cutting-edge features and capabilities within Power BI, continuously evaluating industry trends and Microsoft updates to proactively enhance our BI architecture and data modeling capabilities. Architect and implement comprehensive strategies for Power BI performance optimization, including advanced query tuning, efficient data source connectivity, incremental refresh mechanisms, and proactive monitoring to ensure optimal responsiveness and user experience. Cultivate strong relationships with key business stakeholders, acting as a trusted advisor to translate complex business needs into robust technical specifications and architectural blueprints for Power BI solutions. Oversee Power BI administration, including capacity planning, workspace architecture, data gateway configuration, and the implementation of sophisticated security roles to ensure a secure, scalable, and well-governed BI environment. Provide expert guidance and mentorship to BI developers and analysts on data modeling, architectural patterns, and performance tuning, fostering a culture of technical excellence and innovation. We are looking for someone with… Bachelor’s degree in Information Technology, Engineering, or a related field. Proven experience (7+ years) in Business Intelligence, with at least 5 years specifically focused on architecting, advanced data modeling, and performance optimization within Microsoft Power BI in complex enterprise environments. Exceptional communication and interpersonal skills, with a demonstrated ability to articulate and advocate for complex technical architectures and data modeling strategies to both technical and non-technical audiences. Expert-level understanding of data warehousing concepts, ETL/ELT processes, and advanced data modeling principles (e.g., star schema, snowflake schema, slowly changing dimensions). Deep expertise and hands-on proficiency in Power BI Desktop, with a strong emphasis on advanced DAX for complex calculations and performance tuning, Power Query/M for robust data transformations, and Power BI Service for architectural governance. Extensive experience with SQL for complex data extraction, transformation, and optimization, coupled with practical experience in cloud-based data platforms (e.g., Azure SQL Database, Azure Synapse Analytics, Snowflake). Demonstrated experience in Power BI administration, including capacity planning, workspace architecture, data gateway management, and the design and implementation of intricate security models. A strong analytical mindset, meticulous attention to detail, and a profound passion for designing scalable, high-performance BI architectures that translate raw data into strategic business insights. Fluency in English is required . What We Offer Belong & Innovate: Work in diverse teams where every idea matters and innovation grows through collaboration and trust. Flexibility that Works: Hybrid model, flexible hours, and a home office budget — because balance fuels performance. Health & Well-being: Comprehensive health insurance, mental health support, and active sports communities to keep you feeling your best. Grow Without Limits: Access world-class learning platforms, mentoring, and continuous development opportunities. Purpose & Perks: Contribute to sustainability and volunteer initiatives, enjoy partner discounts, and take advantage of our convenient shuttle service. Please attach your CV in English to your application, otherwise your application will not be considered #Siemens #PortugalTechHub Siemens is deeply committed to fostering a diverse and inclusive environment. We are proud to be an equal opportunity employer and strongly encourage applications from a wide array of talented individuals! Apply Share Email WeChat WhatsApp X Facebook | Copy link Go back to top