About the position Activera Consulting is seeking a Power BI Data Visualization Specialist to transform complex datasets into compelling, interactive dashboards and reports. The position focuses primarily on data visualization and also requires foundational data modeling and transformation experience to support efficient, scalable reporting solutions. The specialist will work closely with business stakeholders to translate data into insights that support strategic decisions. Activera Consulting is a boutique management consulting firm serving clients across oil and gas, utilities, manufacturing, private equity, and technology. The role is based in Houston, Texas, with a hybrid work arrangement.

Responsibilities

• Design and develop high-impact Power BI dashboards and reports that communicate business insights.
• Work with business teams to understand reporting needs and translate them into clear, interactive visualizations.
• Optimize dashboards for performance, usability, and storytelling best practices.
• Perform basic data modeling, transformation, and DAX calculations to support visualization needs.
• Connect to data sources such as SQL, Excel, APIs, and cloud platforms, and ensure data accuracy and integrity.
• Collaborate with data engineers and analysts to improve data pipelines, governance, and data availability.
• Stay current on Power BI features and best practices, implementing new functionality where applicable.
• Train and support business users on Power BI best practices and self-service reporting.

Requirements

• 5–7+ years of experience in Power BI development, with a strong emphasis on data visualization.
• Proficiency in Power BI Desktop, Power BI Service, and Power Query (M Language).
• Experience with DAX functions for calculated measures and custom aggregations.
• Basic understanding of data modeling principles, including star schema, relationships, and normalization.
• Ability to work with data sources such as SQL, Excel, SharePoint, and APIs.
• Strong UI/UX design skills for building intuitive and visually appealing reports.
• Strong problem-solving skills and ability to translate business needs into data-driven solutions.
• Strong communication and stakeholder management skills.

Nice-to-haves

• Experience with SQL for querying and data extraction.
• Knowledge of or exposure to ETL processes and tools such as Power Automate, SSIS, or Azure Data Factory.
• Familiarity with other visualization tools, including Tableau and Qlik.
• Power BI certification (PL-300 or equivalent).