About the role
Job Description
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.
As part of the Finance Reporting team, the Senior Analyst will organize financial data using SQL Server and prepare management reports using Power BI and Excel. They will also communicate with internal clients across the country to discuss new reports and answer business questions.
What you will do
- Data Management (15% of time):
- Design, develop, and administer SQL Server databases
- Use ETL processes to transfer, cleanse, and assimilate data
- Identify data discrepancies
- Report Creation (60% of time):
- Create dashboards and reports in Power BI
- Create financial reports and ad hoc analyses in Excel
- Write SQL queries to import data into Power BI and Excel
- Review reports to ensure accuracy
- Collaboration (20% of time):
- Reach out to end users and stakeholders to share findings and solutions, ensuring clarity and understanding
- Work with internal clients to answer their business questions
- Work with other Finance Reporting team members to solve problems and discuss improvements
- Learning (5% of time):
- Research data management and data visualization best practices
- Enhance SQL Server, Power BI, and Excel skills
- Learn about the business and its reporting challenges
What you bring to the role
- 1-2 years experience in financial analysis and/or data analytics
- Post Secondary Education or Undergraduate degree in business, finance, accounting, or data science
- Strong communication skills and ability to build working relationships in a remote environment
- Ability to engage in effective communication and collaboration with various internal teams/stakeholders
- Ability to work autonomously to gather and analyze information, demonstrating a strong sense of ownership and accountability
- Demonstrated analytical problem-solving mindset
- Advanced Microsoft Excel skills
- Experience writing SQL queries
- Experience creating Power BI reports and creating measures in DAX
About KPMG
KPMG is a global network of professional firms providing Audit, Tax and Advisory services. We have 273,000 outstanding professionals working together to deliver value in 143 countries and territories. With a worldwide presence, KPMG continues to build on our successes thanks to clear vision, defined values and, above all, our people.
Our industry focus helps KPMG firms’ professionals develop a rich understanding of clients' businesses and the insight, skills and resources required to address industry-specific issues and opportunities.
The independent member firms of the KPMG network are affiliated with KPMG International Cooperative (“KPMG International”), a Swiss entity. Each KPMG firm is a legally distinct and separate entity and describes itself as such.
About the role
Job Description
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.
As part of the Finance Reporting team, the Senior Analyst will organize financial data using SQL Server and prepare management reports using Power BI and Excel. They will also communicate with internal clients across the country to discuss new reports and answer business questions.
What you will do
- Data Management (15% of time):
- Design, develop, and administer SQL Server databases
- Use ETL processes to transfer, cleanse, and assimilate data
- Identify data discrepancies
- Report Creation (60% of time):
- Create dashboards and reports in Power BI
- Create financial reports and ad hoc analyses in Excel
- Write SQL queries to import data into Power BI and Excel
- Review reports to ensure accuracy
- Collaboration (20% of time):
- Reach out to end users and stakeholders to share findings and solutions, ensuring clarity and understanding
- Work with internal clients to answer their business questions
- Work with other Finance Reporting team members to solve problems and discuss improvements
- Learning (5% of time):
- Research data management and data visualization best practices
- Enhance SQL Server, Power BI, and Excel skills
- Learn about the business and its reporting challenges
What you bring to the role
- 1-2 years experience in financial analysis and/or data analytics
- Post Secondary Education or Undergraduate degree in business, finance, accounting, or data science
- Strong communication skills and ability to build working relationships in a remote environment
- Ability to engage in effective communication and collaboration with various internal teams/stakeholders
- Ability to work autonomously to gather and analyze information, demonstrating a strong sense of ownership and accountability
- Demonstrated analytical problem-solving mindset
- Advanced Microsoft Excel skills
- Experience writing SQL queries
- Experience creating Power BI reports and creating measures in DAX
About KPMG
KPMG is a global network of professional firms providing Audit, Tax and Advisory services. We have 273,000 outstanding professionals working together to deliver value in 143 countries and territories. With a worldwide presence, KPMG continues to build on our successes thanks to clear vision, defined values and, above all, our people.
Our industry focus helps KPMG firms’ professionals develop a rich understanding of clients' businesses and the insight, skills and resources required to address industry-specific issues and opportunities.
The independent member firms of the KPMG network are affiliated with KPMG International Cooperative (“KPMG International”), a Swiss entity. Each KPMG firm is a legally distinct and separate entity and describes itself as such.