Job
Description
ROLE OVERVIEW We are seeking an experienced and highly skilled Power BI expert/Data Visualization Specialist to join our team. You will be responsible for designing, developing, and maintaining complex Power BI solutions to meet the analytical needs of our organization, as well as advising on and maintaining our Power BI architecture and environment. You will collaborate closely with stakeholders to understand requirements, create visually appealing and insightful reports and dashboards, provide expertise in data modeling, DAX calculations, data visualization best practices, and provide expertise in setting up Power BI workspaces, dataflows, client-facing applications, and automatic data refresh processes. A key requirement will be helping to create a modular suite of dashboards for maximum configurability, scalability, and re-use. RESPONSIBILITIES 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. SKILLS/QUALIFICATIONS 8 - 15 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.
