Senior Consultant/Manager- Data Visualization

Activera Consulting; Houston (TX); Hybrid; Full time

Job summary

A management consulting firm based in Houston is seeking a Power BI Data Visualization Specialist to create interactive dashboards and reports from complex datasets. The ideal candidate will have over 5 years of experience in Power BI development, focusing on data visualization and modeling. Strong UI/UX design skills and the ability to translate data into strategic insights are essential. This role offers a hybrid work environment and the opportunity to work closely with business stakeholders.

Qualifications

• 5-7+ years of experience in Power BI development focused on data visualization.
• Proficiency in Power BI Desktop and Power BI Service.
• Understanding of data modeling principles.

Responsibilities

• Design high-impact Power BI dashboards that communicate business insights.
• Translate reporting needs into interactive visualizations.
• Optimize dashboards for performance and usability.

Skills

Power BI development

Data visualization

DAX functions

SQL

UI/UX design

Stakeholder management

Tools

Power BI Desktop

Power BI Service

Power Query

Job description

Company: Activera Consulting, a boutique management consulting firm spearheading innovation in organizational metamorphosis. With a diverse clientele spanning oil and gas, utilities, manufacturing, private equity, and technology sectors, we're the driving force behind sustainable change.

Location: Houston, TX (hybrid)

About Us: At Activera Consulting, we don't just navigate change; we ignite it. We're a tight-knit team of change agents dedicated to empowering organizations to rewrite their success stories. Our innovative solutions and unwavering commitment to excellence set us apart, making us the go-to partner for clients seeking transformative change.

Position Overview: We are seeking a Power BI Data Visualization Specialist to transform complex datasets into compelling, interactive dashboards and reports. This role is primarily focused on data visualization but also requires foundational experience in data modeling and transformation to ensure efficient and scalable reporting solutions. The ideal candidate will work closely with business stakeholders to translate data into insights that drive strategic decisions.

Responsibilities

• Design and develop high-impact Power BI dashboards and reports that effectively 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 various data sources (SQL, Excel, APIs, cloud platforms) and ensure data accuracy and integrity.
• Collaborate with data engineers and analysts to improve data pipelines, governance, and availability.
• Stay updated on Power BI features and best practices, implementing new functionalities where applicable.
• Train and support business users on Power BI best practices and self-service reporting.

Qualifications

• 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 (star schema, relationships, normalization).
• Ability to work with various data sources (SQL, Excel, SharePoint, APIs).
• Strong UI/UX design skills for building intuitive and visually appealing reports.
• Excellent problem-solving skills and the ability to translate business needs into data-driven solutions.
• Strong communication and stakeholder management skills.

Preferred Qualifications

• 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 (PowerBI, Tableau, Qlik) is a plus.
• Power BI certification (PL-300 or equivalent) is a plus.