Power BI Consultant

Summary

AspenView Technology Partners specializes in building nearshore IT teams that help North American clients innovate and operate more efficiently. The Power BI Consultant will lead a short-term, fully remote engagement by gathering requirements, designing and developing Power BI dashboards and data models, and advising business and technical stakeholders. The role emphasizes advanced Power BI and DAX expertise, executive dashboarding, data security, and client-facing consulting.

Responsibilities

• Work directly with client stakeholders to understand business, reporting, and analytics requirements
• Communicate findings and recommendations clearly to both technical and executive audiences
• Provide guidance and best practices around Power BI development and implementation
• Translate business requirements into scalable Power BI solutions and data models
• Design, develop, and optimize Power BI dashboards, reports, and visualizations
• Develop advanced DAX calculations and Power Query/M solutions
• Create and maintain dimensional data models with appropriate relationships
• Configure and manage Row-Level Security (RLS) and dynamic hierarchies so data access aligns with user roles
• Analyze and cleanse data, and troubleshoot data-quality or reporting issues
• Partner with technical and engineering teams on data integration, architecture, and reporting requirements

Skills

• Bachelor's degree in Computer Science, Information Systems, Analytics, or a related field, or equivalent practical experience
• 3+ years of relevant BI and data analytics experience, with significant hands-on Power BI work
• Demonstrated executive dashboarding experience — reporting built for and presented to senior leadership, not only operational or team-level reports
• Prior experience working directly with U.S. clients and cross-functional technical teams
• Advanced expertise with Power BI and DAX, along with SQL and Power Query/M
• Strong experience with Power BI Service and data modeling
• Working knowledge of dimensional modeling and relational data structures, plus the light data preparation a BI analyst typically encounters — profiling, cleansing, and shaping source data in Power Query. Full ETL or data engineering experience is not required
• Hands-on experience implementing Row-Level Security and dynamic hierarchies
• Strong client-facing communication and consulting skills
• Ability to explain technical concepts and present findings to senior business stakeholders
• Must be a U.S. citizen
• Applicants must be permanently authorized to work in their country of residence and must not require visa sponsorship now or in the future

Qualifications

Must Haves

• Bachelor's degree in Computer Science, Information Systems, Analytics, or a related field, or equivalent practical experience
• 3+ years of relevant BI and data analytics experience, with significant hands-on Power BI work
• Demonstrated executive dashboarding experience — reporting built for and presented to senior leadership, not only operational or team-level reports
• Prior experience working directly with U.S. clients and cross-functional technical teams
• Advanced expertise with Power BI and DAX, along with SQL and Power Query/M
• Strong experience with Power BI Service and data modeling
• Working knowledge of dimensional modeling and relational data structures, plus the light data preparation a BI analyst typically encounters — profiling, cleansing, and shaping source data in Power Query. Full ETL or data engineering experience is not required
• Hands-on experience implementing Row-Level Security and dynamic hierarchies
• Strong client-facing communication and consulting skills
• Ability to explain technical concepts and present findings to senior business stakeholders
• Must be a U.S. citizen
• Applicants must be permanently authorized to work in their country of residence and must not require visa sponsorship now or in the future

Benefits

• Comprehensive benefits and wellness support
• Flexible work model: hybrid, remote, or in-office
• Real growth opportunities and leadership visibility
• Inclusive, respectful culture that blends U.S. innovation with Colombian heart
• A company that listens, invests in you, and celebrates wins together
• 100% remote for the duration of the engagement