Power BI Consultant (Freelance basis)

About The Company

GROPYUS is a technology-based construction company focused on building multi-story residential buildings. Thanks to its prefabricated building system with various design options, industrial offsite construction, and fully digitalized processes, the company manufactures aspirational, sustainable, and affordable homes using timber construction methods. GROPYUS is using scalable construction and manufacturing solutions to tap into a future market, boost Europe's strength in innovation, while also playing a substantial role in improving sustainability.

We're seeking a Power BI specialist to audit, optimize, and clean up our existing semantic model, data ingestion pipelines, and dashboards for a part time (50%) dedicated project from July to November 2026.  

About the Role 

Our Power BI environment has grown organically and needs professional optimization. We're looking for an experienced Power BI expert to drive a comprehensive cleanup and restructuring project. You'll audit our current semantic model for performance issues and design flaws, collaborate with our data engineers to optimize our data lake ingestion processes, and refactor our dashboards for consistency, usability, and efficiency while instilling best practices in our team for continued success after the project ends. 

Key Responsibilities 

• Audit and document the current semantic model structure & relationships for consistency with our ontologies and other existing applications


• Identify and eliminate redundant tables, views, columns, and measures within the MS Data Lake


• Rewrite inefficient or problematic DAX formulas for clarity and speed


• Identify problem areas on the Microsoft side of ingestion and collaborate with our data engineers for required modifications


• Verify data accuracy and consistency across Power BI


• Audit existing dashboards for consistency, usability, and performance and propose consolidation or redesign


• Create & update documentation for semantic models and dashboard usage


• Create guidance and best practices for Power BI usage 

Required Skills & Experience 

• Minimum 3+ years of professional Power BI experience, including data model optimization and integration with various data stores within & outside the MS ecosystem 


• Ability to diagnose and fix complex formula issues 


• Proven ability to audit and refactor existing BI solutions 


• Strong documentation and communication skills 


• Experience with version control or change management in BI environments  


• Familiarity with Dagster, DBT, and Postgres 

Join us on our mission to design buildings as continuously evolving products to create the most exciting and affordable experience for all. We build for people and conserve the resources of our planet.

We can't wait to get to know you. 
For more information, visit our website, and if you have any questions, please reach out to us via email.