Senior Data Analyst at Vito Solutions

DESCRIPTION OF POSITION:

Data Preparation

• Acquire data from various data sources and combine & transform data into interpretable datasets, reports or dashboards
• Assess the effectiveness and accuracy of new data sources and data gathering techniques
• Extend the company's data with third party sources of information when required
• Process, cleanse and verify the integrity of data used for analysis
• Perform data profiling of data contained in source systems
• Provide detailed analysis of all data implemented into the database
• Provide the data mapping and associated transformation rules for each data item
• Ensure that the business requirements and subsequent development activities are supported by accurate information.

Analysis and Visualization

• Interpret data, analyze results using analytical techniques and provide reports and/or dashboards
• Identify, analyze, and interpret trends or patterns in complex data sets
• Use data to answer key questions about the business
• Own and maintain dashboards, ongoing reporting, and ad hoc requests from the organization
• Support and maintain the project data models at multiple levels of detail and functionality (conceptual, logical, normalized, relational, dimensional, application level, subject-level, integrated, etc.)
• Assist Data Modelers to draw up detailed data models.

Stakeholder Engagement

• Work directly with management and other business users to gather requirements, provide status updates, and build relationships
• Present information using data visualization techniques
• Facilitate of requirements gathering workshops with the business
• Collaborate with internal and external stakeholders to analyze information needs, functional requirements and business processes

Coaching/Mentorship

• Provides problem solving assistance to other team members
• Coach and assist junior team members

KNOWLEDGE AND SKILLS:

• Adept at queries, report writing and presenting findings for stakeholder use
• Ability to translate business requirements into non-technical terms
• Ability to comply to and manage data assets under strict governance framework
• Ability to translate business requirements into non-technical terms
• Strong analytical-thinking and problem-solving abilities
• Ability to collect, organize, analyze, and disseminate significant amounts of information
• Attention to detail and accuracy

QUALIFICATIONS REQUIRED:

• Diploma/Bachelor Degree (Information Systems; Statistics; Data or Computer Science; Engineering) or equivalent (preferred but not essential)

EXPERIENCE REQUIRED:

• Functional experience in analytics, data visualization or reporting
• 2-5 years of experience performing data analysis in a BI environment
• Knowledge of and experience with reporting packages
• Experience working with data in various data sources and databases
• Demonstrated experience in handling large data sets and relational databases with proven SQL skills
• Experience in agile development

ADVANTAGEOUS SKILLS:

• Business experience in financial services
• Ability to work with data profiling, data quality and reference data toolsets
• Experience in Data Vault modelling methodology