Business Analyst – Alteryx or SQL

Business Analyst – Alteryx or SQL

ProViso Consulting

Job Description

• As part of the Operations Client Reporting team, the Data Validation Analyst will report to Manager, Data Validation, and will be responsible for supporting the development of a data validation framework for client reporting. This role is responsible for ensuring the integrity and quality of data, by drawing data validation methods, strategies and meaningful insights from structured and unstructured data. The candidate will possess data analytics experience and will be expected to collaborate with key partners to build and implement a data validation framework.

Key Accountabilities:

• Operationalize identified solutions to automate or enhance existing processes through the creation of analytical tools and workflows, preferably using Alteryx
• Write queries based on defined criteria to validate client statements data points within big datasets from several data sources in an automated and recurrent way, proving auditable reports with the results
• Perform analysis and investigation to identify data trends, issues, outliers, and the associated root cause and potential solutions to enhance current processes
• Conduct ad-hoc quantitative analysis and provide support for data issues
• Participate in the development and maintenance of reports and dashboards created to communicate and manage the results of implemented data validation models
• Document business and technical requirements surrounding the data validation processes

Must have

• Good experience with Alteryx or SQL, able to perform effective queries involving multiple tables and subqueries, data mining, and data manipulation
• Advanced proficiency in MS Excel with knowledge of pivot tables, vlookup, conditional formulas, and other analytical functions
• Strong problem solving, logical thinking, quantitative and analytical abilities
• Strong initiative and willingness to learn and collaborate with teams
• Flexible and adaptable profile, comfortable working in uncertainty, and strong ability to learn new technologies or techniques
• 2-4 years’ experience in analytical roles (data analysis, data validation, reporting, and analytics techniques)

Nice to have

• Knowledge of Wealth Management/ Investments/ Finance industry (strong asset)
• Work experience with process automation
• Work experience with business intelligence and data visualization platforms – preferably with Tableau

Job Details



9 Months



Latest Blogs

© 2020 ProViso Consulting - Toronto Recruitment and Staffing Agency

Send this to a friend