Job Description

We are looking for a Power BI Specialist to build automated performance dashboards and data visualizations for social media data during a 6-month project-based engagement.

The infrastructure is already in place. Social media platform APIs (LinkedIn, Instagram, Facebook, X) are connected and feeding data into Snowflake. The data is structured and organized. What we need is someone who can take this foundation and build on top of it combining advanced Power BI development and statistical modeling to enhance decision making in the External Communications team.

Main Responsibilities

Dashboard Design & Development (50% of time)
- Design and build Power BI dashboard architecture from a detailed wireframe and prototype specification already developed
- Implement the data model in Power BI connecting to Snowflake, including a proper date dimension table, audience bridge table, and normalized taxonomy tables
- Build sync slicers across all pages

Statistical Analysis (25% of time)
- Implement scoring framework as calculated measures in DAX




- Develop statistical measures with percentile normalization
- Build correlation and trend analysis views

AI & Advanced Features (20% of time)
- Integrate Copilot for Power BI to enable querying of the dashboard
- Build Smart Narratives that auto-generate written insight summaries
- Implement predictive analytics based on historical efficiency patterns
- Build automated anomaly narratives with contextual explanation

Documentation & Handoff (5% of time)
- Document the full data model, DAX measure library, and Power Query transformations
- Conduct knowledge transfer sessions with the internal team

Key challenges:
- The same underlying data needs to be presented in different ways for different organizational levels.
- Statistical rigor in DAX to handle edge cases.
- Snowflake-to-Power BI performance optimization needs
- 6-month hard deadline, entire build must be completed, tested, documented, and handed off within 6 mo

📌 (Cen) Power Bi Specialist (México)
🏢 Corporate Website
📍 México