Financial Analytics Specialist — Power BI & SQL

Socket.dev

Vancouver

On-site

CAD 83,000 - 100,000

Full time

2 days ago

Be an early applicant

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Benefits offered by this job

Competitive compensation package

Health, dental, and insurance benefits

Generous vacation time

Parental leave top-up

Retirement matching

Education assistance program

Regular social events

Job summary

Aviso is seeking a Business Analytics Specialist to join our IT Business Analytics Team in Vancouver. You will update and distribute business analytics reports, mine data for analysis, and support decision makers with insightful financial metrics.

Reporting to the Manager, Business Analytics, you will combine business knowledge with SQL, Excel, and Power BI to enhance reporting. A strong background in financial analysis and bilingual English/French is a plus.

Qualifications

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.

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.