Job title:  (CEN) POWER BI SPECIALIST

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 months. Key Competencies: Analytical reasoning Visual design sensibility Self-direction Documentation discipline Position Challenges 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 months. Key Competencies: Analytical reasoning Visual design sensibility Self-direction Documentation discipline Qualifications Academic Background Bachelor’s degree in Data Science, Statistics, Computer Science, Engineering, Information Systems, or a quantitative field Areas of Expertise 3+ years of hands-on Power BI development 2+ years working with cloud data warehouses Experience building dashboards from data model to production. Technical Skills DAX (advanced) Power Query / M Language Data modeling Snowflake SQL Statistical fundamentals Power BI visual design Python or R for statistical analysis Power BI Copilot / AI integration Soft Skills Proactive problem-solving Structured thinking Attention to detail English proficiency Plus / Nice to Have Microsoft Certified: Power BI Data Analyst Associate. Familiarity with social media platforms and their metrics. Familiarity with Snowflake’s Snowpark. Experience with Azure AI services. Portfolio of published or shareable Power BI dashboards. Internal/External Relations INTERNAL External Communications Team EXTERNAL N/A CEMEX Diversity and Inclusion Statement At CEMEX, we recognize the diversity of the world in which we live and in which we do business. We respect diversity, we address the inclusion and non-discrimination of any talented person, regardless of gender, physical ability, age, sexual orientation, culture, ethnicity, religion, political affiliation, marital status, pregnancy / maternity / paternity, and nationality. We promote a culture of equity for the construction of a sustainable business and the well-being and development of CEMEX employees.