Senior Power BI Consultant / BI Lead

Build the Future with AspenView Technology Partners At AspenView, we are passionate about transforming the way organizations approach technology. We specialize in creating high-performing, nearshore IT teams to help North American clients innovate faster and more efficiently. As we continue to grow, we’re looking for exceptional people to join our team and help drive impactful change across industries. Why Join AspenView? At AspenView, we’re more than a nearshore IT partner—we’re a people-first, purpose-driven company that believes great culture drives great outcomes. We’re passionate about connecting talent and technology to deliver measurable value for clients—and meaningful career paths for our people. Here’s what you can expect: Competitive base 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 About the Role AspenView is seeking a Senior Power BI Consultant / BI Lead to serve as the senior, client-facing analytics expert on a short-term engagement supporting a U.S.-based client. This is a remote contract role of approximately two to three months, with an immediate start. You will sit at the intersection of business leadership and technical delivery—meeting with client stakeholders to understand their reporting and analytics needs, translating those needs into scalable Power BI solutions, and building them hands-on. Day to day, you will move between requirements conversations with executives, data modeling and DAX development, and close collaboration with engineering teams on integration and architecture. The strongest fit is someone who is genuinely expert in Power BI and equally comfortable operating in a senior consulting capacity: able to engage client leadership on the underlying business problem, earn credibility with technical teams, and turn ambiguous requirements into high-quality, well-governed BI solutions. What You Will Do Client Engagement & Requirements Work directly with client stakeholders to understand business, reporting, and analytics requirements. Communicate findings and recommendations clearly to both technical and executive audiences. Present technical concepts to senior business stakeholders in terms tied to business outcomes. Solution Design & Development 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 transformations. Data Modeling & Security Create and maintain dimensional data models with appropriate relationships. Configure and manage Row-Level Security (RLS) and dynamic hierarchies so that data access aligns to user roles. Analyze and cleanse data, and troubleshoot data-quality and reporting issues. Collaboration & Technical Advisory Partner with technical and engineering teams on data integration, architecture, and reporting requirements. Provide senior-level guidance and best practices for Power BI development and implementation. What You Bring Education Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Statistics, or a related field, or equivalent professional experience. Experience 5+ years of relevant BI and data analytics experience, with significant hands-on Power BI delivery. Demonstrated experience with dimensional modeling, data warehouses, and ER models. Hands-on experience implementing Row-Level Security and dynamic hierarchies. Prior experience working directly with U.S. clients and cross-functional technical teams. Strong client-facing communication and consulting skills, with the ability to operate independently in a senior advisory capacity. Technical Expertise Advanced expertise with Power BI, SQL, DAX, and Power Query/M. Strong working knowledge of Power BI Service and enterprise data modeling. Preferred Qualifications Power BI Report Builder and paginated reports. Microsoft Fabric. Power Platform, including Power Apps and Power Automate. Analysis Services. Azure DevOps and Git or comparable version control. Python for data analysis and cleansing. Tableau, Qlik, or Looker. Data governance and documentation practices. Microsoft and Azure data technologies such as Azure SQL Database, Azure Data Factory, and Azure Synapse Analytics. Certifications Microsoft PL-300, DP-600, DP-700, or PL-900 preferred. Databricks Certified Data Analyst Associate preferred. Engagement Requirements Must be based in the United States. Available to work standard U.S. business hours in close collaboration with client stakeholders. Remote work; contract engagement of approximately two to three months with an immediate start. Visa Sponsorship AspenView does not sponsor employment visas for this role. Applicants must be permanently authorized to work in their country of residence and must not require visa sponsorship now or in the future. Equal Opportunity Employer AspenView is proud to be an equal opportunity employer. We believe in creating an environment where all employees feel welcome, valued, and empowered to succeed. We celebrate diversity and strive to build a culture of inclusion where all individuals, regardless of their race, color, gender, gender identity or expression, sexual orientation, disability, age, or any other characteristic, can thrive. We encourage applicants from all walks of life to join our team and make a lasting impact.