Bring your Knowledge of Power BI and Data Analysis
To our Information Technology Team
CPA Ontario is currently in search of a Data Analyst who will be responsible for extracting, analyzing, and interpreting financial data from various sources to support strategic decision-making and operational initiatives. As part of our Enterprise Architecture team, you will work closely with other cross-functional departments including IT, Finance and Operations, collaborating with business stakeholders to provide actionable insights and recommendations. As a Data Analyst you will be accountable for understanding data needs, working to design and develop reports and dashboards, and conducting thorough data analysis to identify trends, patterns, and opportunities for improvement.
What You’ll Be Doing:
Working collaboratively with business stakeholders within IT, Business Intelligence and Finance departments and other operational teams to understand business requirements and translate them into data-driven solutions.
Extracting, cleaning, and manipulating large datasets from multiple sources including financial databases, CRM systems, ERP systems, and spreadsheets.
Performing analysis of data to identify trends, anomalies, and opportunities for improvement.
Designing and developing reports, dashboards, and data visualizations to present findings in a clear and concise manner.
Preparing regular and ad-hoc reports and dashboards to communicate findings to stakeholders.
Conducting variance analysis and performance reporting to support budgeting and forecasting processes.
Assisting in the design and implementation of data collection systems and strategies to optimize efficiency and data quality.
Administering, monitoring, supporting and maintaining SQL servers in our environment.
Staying current in industry trends and best practices in data analysis and modeling.
Who You Are:
A post-secondary graduate preferably in information systems, information technology, computer science, or related field.
Experienced in working with databases and ERP systems with a minimum of 3 years’ experience in a Data Analyst role.
Proficient in SQL, Microsoft Excel and data processing tools and software – in particular Power BI.
Proficient in Microsoft Dynamics 365 and SharePoint. Experience with Salesforce or other CRM considered an asset.
Highly organized and able to manage projects and timelines within tight deadlines in a fast-paced environment.
Able to work efficiently and effectively as a team member, as well as independently.
An excellent communicator with the ability to convey ideas succinctly and conveying complex findings and insights to technical and non-technical stakeholders with ease.
A self-starter with excellent problem-solving skills and the ability to think analytically about solutions.
Committed to ongoing training and a desire to learn new skills and continually expand upon knowledge and expertise.
What We Offer:
A fast-paced environment. Collaboration, innovation and passionate professionals are at our core. We relentlessly pursue what’s next to unlock the full potential of you and us together.
Flexible work environments. As part of our Hybrid work culture, we provide flexible, remote work options to support you in your career, in addition to in-office teamwork and collaboration.
Diversity and inclusion. We recognize the value in our differences and prioritize inclusivity to bring together the best talent to protect the public, advance the profession and enable CPAs to lead business and society forward.
Ongoing learning and career growth. We want your career to skyrocket. We support career advancement and professional development opportunities with learning investments to promote your future growth. Thrive with us.
Focus on your well-being. With industry leading benefits and wellness programs, including a healthy lifestyle allowance, mental health resources and more, we’re committed to your well-being.
Who We Are:
We protect the public. We advance the profession. We enable CPAs to lead business and society forward. We ensure that our 103,000 members and 18,000 students meet the highest standards of integrity and expertise. We help them stay ahead of global market trends and abreast of regulatory change. CPAs represent a globally recognized, premium designation. Our Chartered Professional Accountants are valued by organizations in all industries for their financial expertise, strategic thinking, management skills and leadership. We believe that success happens when both business and society benefit. For information on the profession visit: cpaontario.ca.
We Appreciate Your Interest In CPA Ontario And This Position:
At CPA Ontario, we are committed to building high-performance teams. Our selection process is thorough, and all candidate applications are reviewed. Should your qualifications and experience meet the requirements of this role, a member of our recruitment team will contact you. We encourage you to set up CPA Ontario job alerts for positions that align to your experience and career goals.
CPA Ontario is an inclusive employer. Accommodation is available under the Ontario Human Rights Code. If you require a disability-related accommodation to participate in the recruitment process, please email accessibility@cpaontario.ca with “Accommodation Required” in the subject line to provide your contact information. A member of the Recruitment team will contact you within 48 hours.