(CEN) POWER BI SPECIALIST

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

• Implement scoring framework as calculated measures in DAX
• Develop statistical measures with percentile normalization
• Build correlation and trend analysis views

• 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

• Document the full data model, DAX measure library, and Power Query transformations
• Conduct knowledge transfer sessions with the internal team

• 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.

• Analytical reasoning
• Visual design sensibility
• Self-direction
• Documentation discipline

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.

• Analytical reasoning
• Visual design sensibility
• Self-direction
• Documentation discipline

Academic Background

• Bachelor’s degree in Data Science, Statistics, Computer Science, Engineering, Information Systems, or a quantitative field

• 3+ years of hands-on Power BI development
• 2+ years working with cloud data warehouses
• Experience building dashboards from data model to production.

• 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

• Proactive problem-solving
• Structured thinking
• Attention to detail
• English proficiency

• 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 Communications Team

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.