Sr. Data Analyst

  • Full Time
  • Toronto
  • This position has been filled

Our client is one of North America’s premier real estate organizations is looking for a Sr. Data Analyst, kindly see below:

Senior Data Analyst Role

Key Job Responsibilities:

  • Participates in analyzing, evaluating and developing reporting requirements for various business units across the enterprise
  • Develops reports and reporting structures using SQL Reporting Services (SSRS) reports, Crystal reports and advanced MS Excel reporting tools.
  • Performs quality assurance testing for all deliverables.
  • Provides support, advice and training to end-users.
  • Communicates reporting changes, enhancements, and modifications through written documentation to management and other team members.

Skills & Abilities:

  • Extensive experience with report writing and technical requirements analysis, business process modeling/ mapping, methodology development, and data modeling.
  • Extensive experience with reporting tools, software, and other applications, including Microsoft Windows Server, SSRS/SSIS and SQL Server.
  • Demonstrated proficiency in programming SQL scripting, database stored triggers, procedures, functions, and views.
  • Ability to create, organize, and use data stores, indexes, and queries to retrieve required data
  • Seasoned knowledge of tuning and optimization techniques including optimization of stored procedures, triggers, tables and indices.
  • Advanced MS Excel experience, including pivot tables, graphs/charts, tables/matrices, and complex functions.
  • Knowledge of the operation and analysis of SQL relational database software and standards, data retrieval methodologies, importing data for use in report software, spreadsheets, graphs, and flowcharts.
  • Knowledge of building dashboards, scorecards, and key performance indicators (KPIs)
  • Ability to translate business needs into technical requirements.
  • Detail oriented with strong organizational skills to effectively work in a dynamic environment
  • Excellent oral and verbal communication skills are needed with the ability to work effectively in a team environment

Qualifications & Experience:

  • Bachelor’s degree in Computer Science, Information Technology or equivalent
  • Minimum 5 years proficiency with report development in MS SQL Reporting Services using SSRS 2012/2016 (SSRS).
  • Minimum 2 years database design and development experience in MS SQL Server 2012/2016