Tekvaly is hiring for a Senior Data Analyst to work on contract for it's client.

The Role

Senior Data Analyst will be reporting to the Sr. Manager, Data Analytics, the Senior Data Analyst performs advanced data analytics for all business units including the US and Canadian businesses. This role designs and applies appropriate data analytics solutions with a strong focus on data visualization and data quality. This role is supported by a team of data engineers who maintain a modern data lake technology stack in the Azure cloud and perform necessary data ingestion, cleansing and curation.

The Senior Data Analyst will work closely with the business to understand the business domain, define specific problems and requirements, create reports & interactive dashboards, and report back with the outcome of analytics in business terms. This role will work independently to design and implement appropriate analytics solutions and provide guidance for data preparation to the data engineering team. This role is also expected to perform research of external data sources and evaluate data analytics related technologies as needed.

What you’ll do

• Work with various business units within Mattamy to define problems and requirements.
• Select the appropriate data analytics technics and data assets to address the business requirements with a strong focus on data visualization.
• Create DAX queries in Power BI desktop.
• Responsible for design methodology and project documentation.
• Provide requirements and guidance for data ingestion and data processing to the Data Engineering team.
• Present the outcome of the data analytics solution to the business units using business friendly terms.
• Ensure all appropriate services levels and quality objectives are met.
• Provide support to other citizen data analytics across the organization and promote a data driven culture within Mattamy.

What you bring

• Degree in computer science, math, statistics related field or equivalent working experience
• Minimum 4-5 years’ relevant experience in advanced data analytics focusing on data visualization using Power BI
• Knowledge and skills for secondary tools such as Microsoft Azure, SQL data warehouse, etc.
• Experience slicing and pivoting SSAS OLAP cubes, Azure Active Directory, OAuth and RLS (row level security).
• Advanced knowledge of Microsoft Power BI development, publishing, and scheduling reports.
• Proficiency in DAX queries in Power BI desktop.
• Advanced knowledge of T-SQL (Microsoft SQL Server databases / Microsoft Azure SQL databases)
• Design and build data pipelines that extract, transform, and load (ETL) data from various sources into our data warehouse.
• Create and maintain data models that ensure data consistency, accuracy, and accessibility.
• Experience creating data quality rules using SQL or tools like Colibra DQ,
• Experience using modern cloud-based data lake technologies such as Azure, Cloudera, or Google
• Strong experience collaborating with business and non-technical teams to provide insights from data.
• Strong experience in working with the business to define business requirements.
• Strong ability to communicate and collaborate effectively with business, management, and project teams.
• Excellent analytical, organizational, planning and time management skills.
• Ability to effectively manage multiple priorities simultaneously. 
• Ability to work on your own and be able to conduct training.

Bonus points

• Knowledge and experience in the land development and builder industry in US and/or Canada
• Knowledge and experience in Microsoft Power Apps
• Knowledge and experience in Colibra tools like DIC & DQ,
• Experience in mortgage lending industry and/or financial modeling
• Experience working in a multi-client/multi-division and cross functional matrix environment