Senior Consultant, Data Analyst - Tax

KPMG Canada; Ottawa; On-site; CAD 70,000 - 110,000; Full time

Job summary

An established industry player is seeking a Senior Consultant, Data Analyst to join their dynamic team. In this role, you will leverage your expertise in data analysis and visualization to transform insights into actionable strategies. Collaborating with experienced professionals, you'll design and implement data solutions that enhance business intelligence and drive informed decision-making. This position offers a unique opportunity to work with cutting-edge technologies in a supportive environment that values continuous learning and teamwork. If you are passionate about data and eager to make a meaningful impact, this role is perfect for you.

Qualifications

• 5-6 years of experience in Data Analysis and Business Intelligence.
• Proficiency in Power BI and Azure SQL Querying.

Responsibilities

• Design and maintain Azure data services using Azure SQL Database and Power BI.
• Develop ETL processes and optimize data retrieval performance.

Skills

Data Analysis

Data Visualization

Business Intelligence

Analytical Skills

Communication

Problem-Solving

Education

Bachelor's degree in Information Technology

Relevant Certifications (e.g., Microsoft Certified Data Analyst Associate)

Tools

Power BI

Azure SQL Database

Data Factory

Alteryx

Job description

Join to apply for the Senior Consultant, Data Analyst - Tax role at KPMG Canada

1 week ago Be among the first 25 applicants

Join to apply for the Senior Consultant, Data Analyst - Tax role at KPMG Canada

Overview
At KPMG, you’ll join a team of diverse and dedicated problem solvers, connected by a common cause turning insight into opportunity for clients and communities around the world.

We offer a continuous learning environment, a team approach, and interesting and challenging work, where you will collaborate with experienced tax professionals and develop a varied skill set.

What You Will Do

1. Design, build, and maintain Azure data services using Azure SQL Database, Data Factory, and Power BI.
2. Develop and implement ETL processes, Data pipelines, and Data integration solutions.
3. Work with stakeholders to assist with data-related technical issues and support their data infrastructure needs.
4. Collaborate with the team to design optimized data models for WAM DATA tools.
5. Ensure data security, compliance, and best practices are always maintained.
6. Optimize system performance, ensuring the fastest possible data retrieval and efficient data updates.
7. Keep up-to-date with emerging database technologies and trends.

What You Bring To The Role

1. Data Visualization: Design, develop, and maintain interactive data visualizations and reports using Power BI.
2. Data Modeling: Create and optimize data models to support business requirements. Data Integration: Integrate Power BI reports into other applications for enhanced business capabilities.
3. Collaboration: Work with business stakeholders to understand their data visualization and business intelligence needs.
4. Performance Optimization: Monitor and optimize the performance of Power BI reports and dashboards.
5. Security: Implement row-level security on data and ensure compliance with data governance policies.
6. Advanced Calculations: Use DAX (Data Analysis Expressions) to perform advanced calculations on data sets.
7. Documentation: Document processes and methodologies used in developing Power BI solutions.
8. Experience: Proven experience in Data Analysis, Data Visualization, and Business Intelligence.
9. Technical Skills: Proficiency in Power BI, Azure SQL Querying, Data Modeling, Alteryx.
10. Analytical Skills: Strong analytical and problem-solving skills.
11. Communication: Excellent communication and teamwork skills.
12. Certifications: Relevant certifications such as Microsoft Certified Data Analyst Associate are a plus.
13. Experience: Relevant experience of 5-6 years.
14. Education: Bachelor’s degree (or equivalent) in information technology or computer science.
15. Experience with data visualization and high proficiency in technical writing.
16. Exposure to Tax Business Domain is an added advantage.

Our Values, The KPMG Way

• Integrity: We do what is right
• Excellence: We never stop learning and improving
• Courage: We think and act boldly
• Together: We respect each other and draw strength from our differences
• For Better: We do what matters

KPMG in Canada is an equal opportunities employer committed to creating a respectful, inclusive, and barrier-free workplace. We welcome all qualified candidates to apply.

We are dedicated to fostering an inclusive recruitment process, providing adjustments or accommodations as needed. For support, contact KPMG’s Employee Relations Service team at 1-888-466-4778.