Power BI Expert/Data Visualization Specialist | Remote | 5+ yrs

Power BI architecture, environment, and dataflows

•  Establish best practices and standards for managing Power BI artifacts, including reports, datasets, and dataflows within workspaces.
• Configure and manage dataflows to ingest, transform, and prepare data from various sources for analysis within Power BI.
• Develop and implement strategies for automating data refresh processes to keep Power BI reports and dashboards up-to-date.
• Collaborate with data engineers and data scientists to optimize dataflows and ensure data quality and consistency.
• Monitor and troubleshoot data refresh failures, performance issues, and other technical challenges related to Power BI datasets and dataflows.
• Manage Power BI deployment pipelines for development, testing, and production environments.
• Leverage Power BI REST APIs to automate CI/CD pipelines for updating, publishing, and deploying numerous dashboards at scale.

Power BI development

• Work closely with stakeholders to gather requirements, understand business needs, and translate them into technical solutions.
• Develop advanced Power BI reports, dashboards, and interactive visualizations that provide actionable insights and drive data-driven decision-making.
• Design and implement efficient and scalable data models using Power BI Desktop and SQL Server Analysis Services (SSAS).
• Write complex M query and DAX calculations to manipulate and transform data for analysis and reporting purposes.
• Integrate Python and/or R scripts into Power BI for data transformation and data visualization.
• Optimize performance of Power BI reports and dashboards to ensure fast load times and smooth user experience.
• Establish version control best practices using Git integration.

Documentation, training and support

• Create and maintain documentation related to Power BI solutions, including data models, calculations, and report designs.
• Provide training and support to upskill other data scientists on how to improve their Power BI capabilities.
• Stay current with industry trends and advancements in Power BI and related technologies and recommend innovative solutions to enhance data analytics capabilities.

• 5 - 10 years of experience in business intelligence and data analytics, ideally with 5 years of hands-on experience with Power BI.
• Expertise in designing and developing complex Power BI reports and dashboards from scratch, with strengths in creating elegant, highly professional data visualizations.
• Strong understanding of data modeling and data integration concepts and experience building data models using Power BI Desktop and SSAS.
• Proven expertise in designing and implementing Power BI architecture, including workspaces, datasets, and dataflows.
• Proficiency in Power Query M language and writing advanced DAX calculations and optimizing performance of Power BI solutions.
• Proficiency in configuring and managing data refresh schedules and automating data pipelines in Power BI.
• Experience working with large and complex datasets from multiple sources.
• Experience working with Power BI gateways.
• Strong problem-solving skills and attention to detail.
• Microsoft Power BI certification(s) preferred.

How you work:

• Highly organized, self-starting, methodical and with the ability to manage complex projects.
• Quick learner, highly adaptable, comfortable with ambiguity.
• Highly analytical with strong attention to detail.
• Experience supporting and working with cross-functional teams in a dynamic environment.
• Excellent communication and interpersonal skills, with the ability to effectively collaborate with stakeholders at all levels of the organization.