Data Analyst
Job Overview
Job title: Data Analyst
Job description: Reporting to the Manager, Data Analytics and Insights, the Data Analyst is responsible for enforcing and upholding the importance of data policies and strategies to create suite of analytics solution to achieve organization’s strategic goals and objectives. The Data Analyst works with various stakeholders to identify analytical needs, and translate the requirements; develop, compile and present the analysis supported by data. In addition, other responsibilities will include process improvement initiatives, as well as, working with data stewards to ensure data quality, create and document data models, and collaborate with database developers to improve systems and database designs.
From coordinating with the data architecture team to transforming business problems to suitable cloud-based solutions, the Data Analyst will play a key role in all stages of the data management process, with focuses on development, implementation and maintenance. In order to succeed, the analyst must demonstrate both sound technical knowledge and outstanding soft skills.
Responsibilities:
- Assist Manager, Data Analytics and Insights in management and development of various analytics projects across multiple business functions and teams
- Act as a primary source of expertise in the data structure and workflow of various supporting systems
- Work directly with business users with variety of level of expertise and requirements to identify and translate the business case into technical requirements for development of full analytics solutions
- Research and review large sets of data, using peer analysis with benchmarking and competitor analysis
- Evaluate query designs, data structure, and data quality to provide recommendation for improvement as needed
- Analyze problems and errors produced by business applications.
- Develop targeted metrics and KPI’s for descriptive, and prescriptive analytics
- Work with teams to provide input into test strategy, test scenarios, test data requirements and support user validation
- Conduct insightful ad-hoc analysis to investigate ongoing, or one-time issues
- Develop documentation of key processes, issues, and assist in creating data dictionary
- Conduct analysis to validate system issues and work with IT to resolve those issues
- Provide training and support cross functional teams
- Complete all other duties as assigned
Qualifications:
- A bachelor’s degree in Business, Mathematics, Statistics, Computer Science, or another quantitative field
- 4-6 years experience in a similar role preferred.
- Advanced proficiency in Microsoft Excel (Functions, formulas, charts, tables, and power query)
- Demonstrated experience in Power BI, Power Apps, Power Automate and creating suite of analytics dashboards
- Experience in data modelling, and financial modelling preferred
- Actively demonstrates confidentiality, tact and discretion in preparing, disclosing and handling information of a confidential and/or sensitive nature
- Ability to work effectively both independently and as a member of a team
- Experience with cloud technologies would be an asset. Specifically – Hana, SQL Server, Azure Data Factory, Stream Analytics
- Experience with SAP ECC, BW and BODS suite of tools
- Knowledge of big data infrastructures such as Hadoop or Snowflake will be an asset
- Strong problem-solving skills, mathematical and data literacy
- Strong organizational and project management skills with the ability to work independently and in a team environment, and mentor and train other members of the team
- Creative, innovative, and critical thinker with excellent problem-solving skills
Company: Capreit
Expected salary:
Location: Toronto, ON
Job date: Sat, 12 Nov 2022 06:50:06 GMT
Job Source: Careerjet.ca