Data and Analytics Support Consultant SA

Canon Business Services ANZ; Adelaide; On-site; AUD 90,000 - 120,000; Full time

Benefits offered by this job

Birthday leave

Canon Day leave

Kyosei Day

Wellbeing benefits

Discounted Canon products

Education assistance

Job summary

Canon Business Services ANZ is seeking a data analytics and BI specialist to support and enhance data solutions across SQL Server, Power BI and Microsoft Fabric environments. You will resolve incidents, improve performance and deliver reliable reporting for enterprise and government customers.

The role requires visiting the Adelaide site weekly, collaborating with delivery teams and stakeholders to drive continuous improvement in analytics capabilities and automation.

Qualifications

• Experience in data analytics or BI support with MS data platforms.
• Strong SQL Server and T-SQL troubleshooting skills.
• Experience developing Power BI reports and data models.
• Knowledge of ETL/ELT and data integration best practices.
• Excellent communication with technical and non-technical stakeholders.
• Exposure to Microsoft Fabric or cloud analytics is preferred.
• Familiarity with SSIS/SSRS/SSAS and Azure DevOps is advantageous.
• Microsoft certifications or willingness to pursue them is valued.

Responsibilities

• Provide L2/3 support for data, analytics, BI solutions.
• Troubleshoot incidents and perform root cause analysis.
• Support SQL Server databases, stored procedures, ETL processes.
• Develop and maintain Power BI reports and data models.
• Assist with Fabric technologies including Lakehouse, Data Factory pipelines.
• Participate in testing, deployment, and release activities.
• Create and maintain technical documentation and runbooks.
• Collaborate with customers and service delivery teams to achieve outcomes.
• Identify opportunities to automate analytics processes.

Skills

SQL Server

T-SQL

Power BI

Data models

DAX

Tools

SSIS

SSRS

SSAS

Power BI Report Server

Azure DevOps

Git

Job description

• Work for a fast paced MSP focused on customer success, technical excellence and innovation
• Be part of our growing AI Business Solutions practice delivering modern analytics and reporting solutions for enterprise and government customers
• Join a collaborative team that values continuous improvement and professional development
• Hybrid role with the flexibility to work from home 2 days in a week – Adelaide location

• Work for a fast paced MSP focused on customer success, technical excellence and innovation
• Be part of our growing AI Business Solutions practice delivering modern analytics and reporting solutions for enterprise and government customers
• Join a collaborative team that values continuous improvement and professional development
• Hybrid role with the flexibility to work from home 2 days in a week – Adelaide location

About Us

At Canon Business Services, we're a technology solutions partner for ambitious organisations. Across Australia, New Zealand and the Philippines, we help customers move past roadblocks, embrace opportunities and achieve real business outcomes through smart technology, business process and workplace solutions. By combining deep expertise with a focus on outcomes, we help organisations move faster, work smarter and unlock what's next. What makes Canon Business Services different is our people and our solutionist mindset. We don't jump to quick fixes, we look deeper, ask the right questions and work closely with our customers to solve what really matters. Through our Truly Care approach, we listen with curiosity, plan with expertise and deliver with efficiency, building trusted partnerships that create lasting value and real results.

About The Role

This role plays a key part in supporting and maintaining data, analytics and business intelligence solutions for a range of customers. You will work across SQL Server, Power BI and Microsoft Fabric environments, helping resolve incidents, improve platform performance and deliver reliable reporting solutions. The role requires visiting our Adelaide based customer site one day in a week.

Scope of the Role

• Providing Level 2/3 support for data, analytics and business intelligence solutions
• Troubleshooting incidents, service requests and platform issues, including root cause analysis
• Supporting SQL Server databases, T-SQL scripts, ETL processes and Microsoft BI technologies
• Developing and maintaining Power BI reports, semantic models, DAX measures and Power Query transformations
• Assisting with Microsoft Fabric technologies including Lakehouse, Warehouse, Data Factory pipelines and semantic models
• Participating in testing, change management, deployment and release activities
• Creating and maintaining technical documentation, knowledge articles and support runbooks
• Collaborating with customers, service delivery teams and technical specialists to deliver excellent outcomes
• Identifying opportunities to automate and improve existing analytics and reporting processes

About You

You are a customer focused technology professional with experience supporting data and analytics environments. You enjoy investigating technical issues, working collaboratively with stakeholders and continuously expanding your technical capability across modern Microsoft data platforms. You bring strong Microsoft BI and reporting experience and enjoy problem solving, customer engagement and working with both modern and legacy data platforms. Key Skills and Experience include:

• Experience in data analytics, business intelligence, application support or a similar Microsoft technology environment
• Strong SQL Server and T-SQL skills, including troubleshooting queries, stored procedures and data issues
• Experience developing or supporting Power BI reports, data models, Power Query and DAX
• Understanding of ETL/ELT, data integration and production support practices
• Experience investigating incidents, identifying root causes and implementing practical solutions
• Strong written and verbal communication skills, with the ability to translate technical concepts for non-technical stakeholders
• Exposure to Microsoft Fabric, Azure data services or modern cloud based analytics platforms will be highly regarded
• Experience with SSIS, SSRS, SSAS, Power BI Report Server, Azure DevOps or Git is advantageous
• Relevant Microsoft certifications, or a willingness to pursue certification, will be highly regarded

You can Expect

When you join Canon Business Services, you'll be part of a business that invests in your growth and development. You'll have the opportunity to work alongside talented experts, contribute to meaningful outcomes for customers and take on new challenges that help you build your career. Together, we're creating smarter solutions, delivering real results and making a genuine impact for the organisations we support. We offer career development opportunities, flexible working arrangements, wellbeing initiatives and a culture that values inclusion, innovation and continuous learning. Benefits include but not limited to:

• Bonus Leave including Birthday leave, Canon Day leave, Kyosei Day
• Training and development opportunities to help you bring your goals to life
• Wellbeing benefits, including everything from discounted health insurance to flu vaccines to confidential counselling
• Canon products offered at discounted rates
• Education assistance to support the cost of any external training that gives you new skills for your job

We believe in the power of an inclusive and diverse workforce. We trust you will bring your authentic self to work and we will focus on making sure that together, we make a strong contribution to the broader community in which we operate. Where possible, flexible working arrangements are the norm, as we know a better work-life balance can improve your motivation, performance, and productivity.

As an equal opportunity employer focused on strengthening our inclusive culture, all applicants will be considered and we welcome applications from people of all ages, cultures including Aboriginal and Torres Strait Islander peoples, abilities, religious beliefs, national origin, sexual orientation and gender identities. Benefits/perks may vary depending on the nature of your employment with Canon Group and the country where you work. All applicants must be eligible to work in the country they are applying to at the time of application.