Position Title: Data Analyst/Developer
Location: Toronto, ON (Hybrid)
Estimated Duration: 3 months
Story Behind the Need: Additional Assistance needed due to new project.
Business Unit: Wealth Management Data and Analytics team works with the Canadian Wealth Management Operations to provide data-driven solutions to various Wealth business applications data. The position involves maintaining data extraction, transformation processes and reporting development to support regulatory, compliance and daily business operations.
Project: The position involves maintaining data extraction, transformation processes and reporting development to support regulatory, compliance and daily business operations. This role will be working to build a new data basis, utilizing MS Access and SQL and to create monthly reporting processes.
Candidate Value Proposition:
The successful candidate will have the opportunity to work within one of the Top 5 Banking Institutions in Canada. You'll get to work with and learn from diverse industry leaders all over the globe, who have hailed from top technology companies around the world.
Typical Day in Role:
- Working closely with the Canadian Wealth Management Operations team to support day-to-day reporting activities.
- Working with data investigation, analysis, development and maintaining a strong knowledge of wealth management business workflow to deliver the expected solution.
- As a Developer Specialist who ensures re-engineering, works with business to understand existing functionalities, and develops new solutions and writes scripts for analysis, testing and regression. Understanding relationship database structure and how the data maps to various business applications.
- The core function will be to build a new MS Access database to calculate Advisor commission clawbacks for early redemptions of GICs (GIC Clawbacks).
- Identify programming / analysis skill gaps and keep up with the new data analysis tools and programming software to consistently improve self and existing processes.
- Will be responsible for performing heavy data-driven analytics and reconciliations for complex calculation logic in various wealth application data which is highly statistical and computation intensive
Candidate Requirements/Must-Have skills:
- 5 years experience as a Developer
- Understanding on wealth business knowledge
- In-depth knowledge of relational database concepts
- In-depth knowledge of Data analytics and Business intelligence – SQL, Microsoft Access, Microsoft VBA or VB .Net and Power BI
Nice to Have Skills:
- Prior Financial Institution Experience
Soft Skills:
- Strong Analytical Mindset
- Time Management Experience
Education:
- University degree in a quantitative discipline (mathematics, science, computer science, or engineering)
Best vs Average: The ideal candidate would have working in a financial environment and possess an understanding of GIC Products.
The pay range that the employer reasonably expects to pay for this position is between CA$55.00 and CA$62.00
Our voluntary benefits offering includes medical, dental, vision and retirement benefits.
Applications will be accepted on an ongoing basis.
Tundra Technical Solutions would like to thank you for the interest you have demonstrated in this opportunity. However, only candidates with the required skills will be contacted.
Tundra Technical Solutions is an Equal Opportunity/Affirmative Action Employer. We welcome and encourage diversity in our workplace.
Not interested in this position, but know somebody who might be? Check out our Referral Reward Program, referrals are a big secret behind our success. As always, we’re on the lookout for great people. And we know that you know great people!
Tundra Technical Solutions is among North America’s leading providers of Information Technology and Engineering staffing and consulting services. Our success and our clients’ success are built on a foundation of service excellence. Rather than continually trying to sell to new clients and companies and simply filling databases with candidates, we focus on developing stronger relationships and deeper knowledge of our existing clients’ challenges and opportunities.
Open ears. Open minds. Open futures