We are looking for a Power BI Consultant who will be responsible for developing and maintaining the data models, reports, and various Power BI features. Responsibilities: Design and develop reporting data models such as star and snowflake schemasDeliver Power BI reports while applying visualisation best practicesBuild data transformations utilising Power Query and DAX languageWrite SQL queries against Azure SQL Database / SynapseProvide production support for Power BI issues such as data load problems, transformation, and translation problems.Manage Power BI Tenant admin activities for successful enterprise Power BI rolloutGateway installation and maintenance to connect to on-premises Effectively translate requirements for Business Intelligence, Reporting and Analytics to database modelling and designActively test and document implementations, so others can easily understand the requirements, implementation, and test conditionsPartner with the Business Stakeholders, Data Architects, Product Managers and Scrum Masters to deliver Power BI solutionsSuccessfully engage with customers to translate business requirements to technical specificationsRequired: Comprehensive, hands-on experience working as a Power BI consultant. Ideally, a minimum of 3 years in BI and Analytics projectsMust have experience with at least two (2) end-to-end implementations of an enterprise Power BI solutionExpertise in data modelling implementing complex views, stored procedures and standard DWH and ETL/ELT conceptsDeep understanding of relational data stores, methods, and approaches (star and snowflake, dimensional modelling)Experience with data security and data access controls and designProficiency in RDBMS, complex SQL queries, database performance tuning and troubleshootingCommercial experience with Power BI modelling (M code), Dax, data storytelling, report publishing, security, and knowledge of how people make decisions with dataMust have experience with Agile development methodologiesExperience working directly with technical and business teamsStrong written communication skills. Is effective and persuasive in both written and oral communicationAbout One51 One51 Consulting is home to the collective knowledge and experience of diverse backgrounds but like-minded individuals. At the core of our culture, we value: A passion for what we do: We believe in the positive impact data and analytics can have in the data-driven organisation and individual.Trust goes a long way: This starts with our employees and extends by nature to our clients. We are committed to building long-term partnerships based on trust, clear communication, and understanding.Creativity and curiosity: Simple solutions to complex problems are possible when the solution design focuses on solving problems and is supported by the correct use of previous experiences and the appetite to keep learning every day.At One51, you will have the opportunity to work with companies in different business sectors in a relaxed and supportive environment. One51 uses a hybrid working arrangement – primarily working from home, with optional office days scheduled 1-2 days per week at our Melbourne office.
#J-18808-Ljbffr