Senior Data Analyst

at  Raymond James Financial Inc

SENIOR DATA ANALYST

• 2402211
  At Raymond James, we develop, we collaborate, we decide, we deliver, and we improve together.
  Raymond James Ltd. is Canada’s leading independent investment dealers offering high quality investment products and services to Canadians seeking customized solutions to their wealth management needs.
  We are seeking an experienced Senior Data Analyst. Reporting to the Senior Manager of the Enterprise Data team the Senior Data Analyst will be responsible for designing and building business intelligence and data integration solutions.

EDUCATION AND EXPERIENCE:

• Diploma of Technology, Bachelor’s degree in Computer Science, MIS, Business or a related field preferred.
• Minimum of five (5) years of relevant experience.
• Database design and development experience is an asset.
• Power BI design and development skills mandatory – minimum (3) years of hands-on experience
• Excellent SQL knowledge required.
• Knowledge on cloud data tech stack is an asset.
• Experience in the financial services industry preferred but not required.

HOW DOES THE ROLE IMPACT THE ORGANIZATION?

Under the direction of the Senior Manager, Enterprise Data, Data Analyst responsibilities include conducting full lifecycle activities including requirements analysis, data analysis, data modeling, design and development of reporting dashboards. Assists the business in turning data into information, turning information into insight and insight into decisions.

WHAT WILL YOUR ROLE BE RESPONSIBLE FOR?

• Interpret business and data requirements after eliciting the problem that needs to be solved.
• Collaborate with team members of the Enterprise Data team to identify data sources and relationships between data sources that are required to solve the business requirements.
• Coach and mentor other analysts on team on best practices in data analysis and designing robust solutions.
• Contribute to the overall enterprise data architecture, design, and process improvement.
• Data mapping and data modeling.
• Compile documentation of requirements and data mapping.
• Design and develop Power BI dashboards.
• Design solutions for analyzing historical and multidimensional data leveraging tools like SSAS.
• Profile data sources using SQL and other data discovery tools in support of data quality analysis and business intelligence design efforts.
• Create detailed business requirements for functional (e.g., business processes, rules) and non-functional (e.g., data, security) capabilities.
• Partner with team members to develop project schedules, reports and documentation; and
• Perform other duties and responsibilities as assigned.