Power BI Developer - Consultant

Position Overview: Amplytics is seeking a highly skilled and experienced Power BI Developer Consultant specializing in Power Query, data pipeline creation, and semantic modeling. The ideal candidate will have extensive experience scripting M-Code to solve complex data pipeline challenges, developing robust dataflows, and leveraging Microsoft Fabric for scalable solutions. This role requires technical expertise and a strong consulting background to effectively communicate with clients, gather requirements, and deliver tailored solutions that meet business needs. Key Responsibilities: Client Consulting & Engagement: Collaborate closely with clients to understand their business requirements, challenges, and data objectives. Translate these needs into technical specifications and Power BI solutions that deliver measurable business value. Data Pipeline Development: Design, build, and optimize end-to-end data pipelines using Power Query and M-Code. Implement scalable and efficient solutions for integrating data from diverse sources, ensuring high data quality. Power Query Expertise: Use advanced Power Query techniques to clean, transform, and shape large datasets—Automate data preparation workflows to ensure data reliability while clearly communicating solutions and their benefits to stakeholders. M-Code Scripting: Develop custom M-Code scripts for advanced data transformations and problem-solving. Ensure robust data processing and seamless integration across various environments to meet specific client requirements. Semantic Modeling: Design and implement semantic models within Power BI, ensuring users interact with clean, well-structured data. Explain the benefits of semantic models for improving data accessibility and report performance in client environments. Dataflow Creation: Develop and manage Power BI Dataflows to centralize and reuse data transformation logic, providing consistent and scalable data solutions tailored to client use cases. Microsoft Fabric Utilization: Leverage Microsoft Fabric to improve data connectivity, manage large data volumes, and ensure smooth data pipeline operations. Explain the added value Fabric brings to the client’s data architecture. Report and Dashboard Development: Collaborate with business users, analysts, and client stakeholders to design intuitive and interactive reports and dashboards that provide actionable insights. Customize these reports to fit the client’s needs. Documentation & Best Practices: Maintain clear documentation of data pipelines, M-Code solutions, and semantic models. Ensure clients have access to best practices and training in Power BI development to maintain their solutions post-implementation. Cross-Functional Collaboration: Work with internal teams and client-side stakeholders, including data engineers and business analysts, to align on project requirements and ensure successful project delivery. Qualifications: 5 years of experience in Power BI development and consulting, specializing in Power Query and data pipeline creation. Advanced knowledge of M-Code scripting to solve complex data transformation problems and optimize dataflows for clients. Proven experience with semantic modeling in Power BI, including the ability to explain its advantages and best practices to business stakeholders. Expertise in creating and managing Power BI Dataflows and understanding how they contribute to scalable, client-focused data solutions. Strong understanding of Microsoft Fabric , with the ability to explain its benefits and apply its capabilities for data management and connectivity. Proficiency in DAX (Data Analysis Expressions) to create advanced calculations and improve report performance, tailoring reports to meet client needs. Experience consulting with clients to identify and translate business problems into technical solutions using Power BI and other tools. Excellent problem-solving and analytical skills, with the proven ability to present complex technical concepts to non-technical stakeholders. Strong communication and collaboration skills, with the ability to work effectively across both internal teams and client-facing environments. Preferred Qualifications: Experience with large-scale data integration projects and consulting in enterprise environments. Familiarity with Agile or Kanban project management methodologies in a consulting capacity. Experience with Power BI Premium or Embedded. Relevant certifications ( PD-600 : Implementing Analytics Solutions Using Microsoft Fabric or PL-400 : Microsoft Power Platform Developer. Amplytics is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. We believe in fostering an inclusive workplace where differences are celebrated, and all employees can truly be themselves. Our diversity fuels our innovation and connects us closer to our customers and the communities we serve.