Business Analytics Specialist

Aviso Wealth; Vancouver; On-site; CAD 83,000 - 100,000; Full time

Benefits offered by this job

Competitive pay

Excellent benefits package

Generous vacation time

Retirement plan matching

Learning & development

Job summary

Aviso Wealth is seeking a Business Analytics Specialist to join the IT Business Analytics Team in Vancouver, focusing on updating and distributing reporting and conducting ad-hoc data mining for analysis to support decision makers.

The ideal candidate has 3+ years of financial analysis experience, strong SQL, Excel, and Power BI skills, and a post-secondary degree. The role offers competitive compensation and benefits.

Qualifications

• Post-secondary degree in business, accounting, computer science or related field.
• Experience in the brokerage or investment management industry.
• Minimum 3+ years of related financial analysis experience.
• Preference given to those with experience as a business intelligence developer.
• CSC is considered an asset.
• Create reporting and analysis through the use of SQL, Excel Services and Power BI.
• Be able to write relational database SQL queries.
• Advanced Excel and Power BI skills.
• Strong computer literacy with the ability to utilize and leverage various forms of related software and technology.
• Exceptional creativity, problem solving skills and flexibility.
• Excellent verbal and written communications, at both individual and group level in English and bilingual skills in French are an asset.

Responsibilities

• Business Analytics Reporting and Analysis.
• Updating and distributing established business reporting for internal and external decision makers.
• Ad-hoc data mining for specific analysis.
• Use a balance of business knowledge and technical skills to maintain and enhance reporting and analysis for key decision makers.
• Employ light project management to oversee reporting solution development.
• Preparing, analyzing and reporting on key financial performance metrics.
• Gathering, analyzing and interpreting financial data. Compiling monthly reports for senior management

Skills

Data analysis

Financial analysis

SQL

Excel

Power BI

Education

Post-secondary degree in business, accounting, computer science or related field

Tools

SQL

Excel

Power BI

Job description

The Opportunity:

We’re looking to fill an opening for a Business Analytics Specialist to join our IT Business Analytics Team.

Reporting to the Manager, Business Analytics the Business Analytics Specialist will be instrumental in supporting the business analytics functions at Aviso Wealth. Principle responsibilities include updating and distributing Business Analytics reporting and ad-hoc data mining for analysis.

Asoneaviso:

• We Care– Youdo the right thing forclients,partnersand colleagues. Youbuild trusted relationships,championservice excellence, andcontribute to a culture where people feel valued and supported
• We Dare–You challenge the status quo with bold ideasand fresh perspectives. Youembrace change, seek opportunities toinnovateand are comfortable exploring new ways of working
• We Share– Youcollaborate openlyand build meaningful relationships. Youseek outdiverse perspectives, share yourknowledgeand work together to helpcolleagues,clientsand partners succeed
• We Deliver– Youtake ownership of your work,honouryourcommitmentsand focus on delivering meaningful results.You hold yourself accountable and continuously look for ways to improve

What your day looks like:

• Business Analytics Reporting and Analysis
• Updating and distributing established business reporting for internal and external decision makers.
• Ad-hoc data mining for specific analysis
• Use a balance of business knowledge and technical skills to maintain and enhance reporting and analysis for key decision makers
• Employ light project management to oversee reporting solution development
• Preparing, analyzing and reporting on key financial performance metrics
• Gathering, analyzing and interpreting financial data. Compiling monthly reports for senior management

Your experience and skills:

• Post-secondary degree in business, accounting, computer science or related field
• Experience in the brokerage or investment management industry
• A minimum of 3+ years of related financial analysis experience
• Preference given to those with experience as a business intelligence developer
• CSC is considered an asset
• Create reporting and analysis through the use of SQL, Excel Services and Power BI
• Be able to write relational database SQL queries
• Advanced Excel and Power BI skills
• Strong computer literacy with the ability to utilize and leverage various forms of related software and technology
• Exceptional creativity, problem solving skills and flexibility
• Excellent verbal and written communications, at both individual and group level in English and bilingual skills in French are an asset
• Strong attention to detail, organizational and time management skills
• Strong customer service orientation
• Ability to work well under pressure and in a fast-paced environment
• Ability to work independently to achieve required objectives, within company and regulatory requirements

At Aviso, you will find a dynamic and inclusive culture that rewards innovation and celebrates success.

Here are a few things that set us apart:

• Competitive compensation package that rewards and recognizes individual contributions
• Excellent health, dental and insurance benefits to meet the diverse needs of our employees
• Generous vacation time, fitness benefit, parental leave top-up options
• Matching contributions to our retirement program
• Commitment to the continuous improvement of our staff through learning & development and an education assistance program
• Regular social events to foster teamwork

Salary

This position is posted with an expected salary range of $83,000 - $100,000 CAD annually. Individual compensation packages are based on various factors unique to each candidate and the requirements of the position.

Your Information

By submitting your application, you consent to the collection, use, and disclosure of your provided personal information for the purposes of assessing your qualifications and suitability for employment with Aviso. Your information will be handled in accordance with applicable Canadian privacy laws, including thePersonal Information Protection and Electronic Documents Act (PIPEDA)and relevant provincial legislation. Your data may be shared with authorized personnel involved in the recruitment process and retained only as long as necessary to fulfill these purposes or as required by law.

Further information is available on the Privacy link on our Career Page –Privacy Policies

Equal Employment Opportunity

Aviso welcomes and encourages applications from all qualified individuals including persons with disabilities. If you require an accommodation, we will work with you to meet your needs in all stages of the hiring process.

Company Overview:

Aviso is a leading wealth management and investment services provider for the Canadian financial industry, with approximately $145 billion in total assets under administration and management, and over 1,000 employees. We’re building a comprehensive, technology-enabled, client-centric wealth services ecosystem. Our clients include our partners, advisors, and investors. We’re a trusted partner for nearly all credit unions across Canada, in addition to a wide range of portfolio managers, investment dealers, insurance and trust companies, and introducing brokers. Our partners depend on Aviso for specific solutions that give them a competitive edge in a rapidly evolving, highly competitive industry. Our investment dealer and mutual fund dealer and our insurance services support thousands of investment advisors. Our asset manager, NEI Investments, specializes in investing responsibly. Our online brokerage, Qtrade Direct Investing®, empowers self-directed investors, and our fully automated investing service, Qtrade Guided Portfolios®, serves investors who prefer a hands-off approach. Aviso Correspondent Partners provides custodial and carrying broker services to a wide range of firms. We have offices in Toronto, Vancouver, and Montreal. Aviso is backed by the collective strength of our owners: the credit union Centrals, Co-operators/CUMIS, and Desjardins.We’re proud to power businesses that empower investors.

A career with Aviso means being part of a group of talented, energetic professionals who live their values every day, and belonging to an organization dedicated to your success and career development. If you’re looking for interesting and challenging work, at a company committed to its people