Expression of Interest - Consultant

Job Description

Consultant Melbourne location We Are Fujitsu We use technology to make happier lives. We are a global leader in technology and business solutions that transform organizations and the world around us. We have a long heritage of bringing innovation and expertise, continuously working to contribute to the growth of society and our customers. About the role As a Data & AI Consultant, you leverage your expertise in Power BI to analyse, visualize, and transform business data into actionable insights. You collaborate with business stakeholders to gather requirements, design data models, and create dynamic reports and dashboards that support decision-making and improve operational efficiency. Your role combines a deep understanding of data analysis, database management, and advanced Power BI development to deliver solutions that address both strategic and tactical business needs.Responsibilities and Accountabilities 1. Data Analysis and Reporting: Data Collection & Analysis: Gather and analyse data from various sources (SQL databases, cloud services, APIs, etc.) to identify trends, insights, and business opportunities. Report & Dashboard Development: Design and develop interactive, user-friendly Power BI reports and dashboards that meet business requirements and provide meaningful insights. Ad-Hoc Reporting: Provide ad-hoc reporting support to business units, answering data related queries, and delivering insights based on specific needs. 2. Power BI Development & Maintenance: Power BI Data Models: Create and maintain data models in Power BI, ensuring they are optimized for performance and scalability. Data Transformation: Utilize Power Query to clean, transform, and load data from various sources into Power BI, ensuring data accuracy and consistency. DAX Formulas: Develop complex DAX (Data Analysis Expressions) measures, calculated columns, and KPIs to derive business insights and improve report functionality. Dashboard Design: Design visually appealing and intuitive Power BI dashboards that align with business goals and allow users to easily interpret the data. 3. Data Integration and ETL: ETL Processes: Develop and manage ETL (Extract, Transform, Load) processes to integrate data from multiple systems and sources into Power BI. SQL Query Writing: Write and optimize SQL queries to extract and transform data from relational databases or data warehouses to support Power BI reports and dashboards. Database Integration: Integrate data from different sources (SQL databases, Excel, APIs, web services) into a unified Power BI model. 4. Performance Optimization: Report Performance Tuning: Ensure that Power BI reports and dashboards are optimized for performance by implementing best practices for data modelling, query design, and DAX functions. Data Load Optimization: Minimize data load times by optimizing data sources, applying incremental data refreshes and reducing unnecessary data imports. 5. Collaboration & Stakeholder Communication: Requirement Gathering: Work closely with business stakeholders to understand their reporting needs, gather requirements, and provide actionable insights. Business Process Understanding: Gain an in-depth understanding of the business processes and workflows to ensure reports and dashboards meet operational needs and goals. Training & Support: Provide training and support to end-users, ensuring they can navigate Power BI reports and dashboards effectively. 6. Documentation & Maintenance: Documentation: Document Power BI report specifications, data models, DAX formulas, and other technical aspects to ensure proper knowledge transfer and support. Ongoing Maintenance: Ensure that reports and dashboards are up to date, refreshing data as needed, and implementing enhancements based on user feedback. 7. Key Skills: Communicating with business and technical stakeholders at all levels Agile ceremony participation includes standups, retros, and sprint planning. Maintaining and updating work backlogs, users storis and tasks. Helping peers and junior members of the team. Raising and reviewing issues and risks with the team and technical and business project managers. Active participation in data visualisation and other guilds, team and all hands meetings. Constant upskilling through Microsoft certifications and online courses. Requirements and Experience: Educational Qualifications: Bachelors degree in Information Technology, Computer Science, Data Analytics, Business Intelligence, or a related field. Relevant certifications, such as Microsoft Certified: Data Analyst Associate, will be highly regarded. Technical Skills: Power BI: At least 35 years of hands-on experience with Power BI Desktop, Power BI Service, and Power BI Report Server. DAX (Data Analysis Expressions): Proficiency in writing DAX queries for data analysis and building metrics. Power Query (M Language): Expertise in using Power Query to transform and clean data. SQL: Strong experience in writing complex SQL queries for data extraction, analysis, and reporting. Data Modelling: Solid understanding of data modelling concepts, including star and snowflake schema, and best practices for efficient Power BI reports. ETL Processes: Experience in designing and implementing ETL processes, ideally involving cloud data sources. Cloud Integrations: Familiarity with integrating Power BI with cloud services (e.g., Azure, SharePoint) is a plus. Version Control & Deployment: Experience with deploying Power BI reports to production environments using Power BI Service. Microsoft Fabric: Familiarity with Microsoft Fabric for data engineering, data integration, and analytics workflows. Experience with integrating Microsoft Fabrics data lakes, data pipelines, and data factories into Power BI solutions is highly desirable. Soft Skills: Strong communication skills with the ability to work directly with business stakeholders and translate their needs into technical solutions. Ability to prioritize tasks, manage time effectively, and handle multiple projects concurrently. Strong problem-solving skills and attention to detail. Ability to work both independently and as part of a team in a collaborative environment. Why Fujitsu? We are an organization with a strong set of values and a history of respecting fairness and equality, whilst promoting diversity, equity, and inclusion. We constantly push ourselves to do better and strive to bring together a diverse mix of perspectives and talents in an inclusive environment, where we encourage our people to bring their full selves to work. We call this Be Completely You. We put people first. We believe in the power of diversity to drive innovation and our AWEI (Australian Workplace Equality Index) Gold Employer status, and Rainbow Tick certification for LGBTI+ inclusion show that we value an inclusive culture. We offer tailored career paths across our global organization to support your professional and personal growth. Our customers trust us. We have an excellent reputation across the region and globally. Best in-class reward and recognition programs flexible work, volunteering leave, and more. We live our values of aspiration, trust, and empathy, all day, every day. Commitment to Diversity, Equity and Inclusion As an inclusive employer, Fujitsu aims to recruit a diverse range of talents to help us achieve our purpose. In line with our diversity, equity, and inclusion strategy, we highly welcome applications from women and gender-diverse people; Aboriginal and Torres Strait Islander people ; Māori and Pacific people; LGBTI+ people; people with a disability; culturally and linguistically diverse people; veterans, Australian Defence Force (ADF) and emergency responders . Transgender and gender-diverse applicants can request a copy of our Frequently Asked Questions to assist with the recruitment journey. If you don't tick every box in this job description, please don't rule yourself out. Research suggests that underrepresented groups tend to only apply if they meet every requirement. We focus on hiring people who value inclusion, collaboration, adaptability, courage, and integrity, rather than ticking boxes so if this resonates with you, then please apply. For more information, please email . Search Firm Representatives PLEASE READ: Fujitsu does not accept unsolicited assistance from search firms for employment opportunities. All CVs or resumes submitted by search firms to any employee at our company without a valid written agreement in place for this position will be considered the sole property of our company. No fee will be paid if a candidate is hired by Fujitsu due to an agency referral where no existing agreement is in place with the Fujitsu Talent Acquisition Team. Where agency agreements are in place, introductions must be through engagement by the Fujitsu Talent Acquisition Team. #J-18808-Ljbffr