Build the next gen PowerBI dashboard

Our firm processes billions of data points related to client marketing performance. We operate out of previously built Power BI reports and now need your deep expertise to maintain, optimize, and evolve a comprehensive tracking dashboard. This dashboard fuels the speed and depth of how we are able to deliver marketing campaign performance tracking for clients. We're seeking a PowerBI specialist who can not only build compelling visual reports but also help transform our backend architecture to handle scale, performance, and usability challenges. Key Responsibilities • Lead Design and Collaboration Sessions: Lead design sessions with our partners and strategists to access key data to be analyzed based on current tracking review decks. • Develop and Improve Reports: Develop visualizations, charts, and graphs in PowerBI that tell a compelling and easily understandable story about campaign performance. This will include prototyping as well as maintenance and improvement of existing reports. • Data Modeling and Optimization: Transition three existing PowerBI reports from a non-relational to a relational semantic model. Audit results and collaborate with the data operations team to: 1) Redefine views and tables, 2) Clarify where measures and objects should reside (Database, Semantic Model, or Report), and 3) Optimize for performance and scalability • Documentation & Reporting Standards: Document the architecture and logic of both new and existing reports to ensure maintainability. Make performance recommendations, including evaluations of live database connections vs. CSV file-based ingestion. • Training and Knowledge Sharing: Provide training or guidance sessions with team members to improve internal capabilities and expertise. Technical Background & Challenges • We currently operate with a non-relational semantic model that handles 10GB+ of accumulated CSV data nightly. This frequently causes update delays and system instability. • You'll help us design an architecture structure for future growth and advise on smarter data sourcing strategies to decrease load failures. Ideal Candidate Profile • Proven experience optimizing Power BI dashboards at enterprise scale. • Hands-on expertise with DAX, relational modeling, and performance tuning. • Strong communicator who can document, teach, and collaborate across teams. • Comfortable operating in high-volume data environments with complex ETL challenges.