Senior Data Analyst
Location: | Mississauga, Ontario – Hybrid (2 days/week in office) |
Company: | Mattamy Asset Management |
Department: | IT Enterprise Services, Mattamy Asset Management Division |
Employment Type: | Full-Time |
Reports to: | Sr. Manager, Data Analytics |
At Mattamy Asset Management (MAM), everyone has an important role to play in our shared success. Developing thoughtfully planned communities is complex work and our diverse teams come together to deliver on that mission in every aspect. We are thoughtful planners, precise project managers and practiced subject matter experts. And in each area of our evolving business, we are trusted to drive results. Here, your opinion will be invited, and your contributions will count. You’ll be surrounded by caring people who encourage you to be exactly who you are. You’ll grow in your area of expertise, learning alongside committed colleagues. With a relentless focus on industry leadership and a deep commitment to sustainability, we’ve got big plans for the future – and for you.
Learn more about what makes working at Mattamy special and our award-winning culture.
What we offer
Reporting to the Sr. Manager, Data Analytics, the Senior Data Analyst performs advanced data analytics for all business units under Mattamy Asset Management including the US and Canadian Home Building businesses. This role designs and applies appropriate data analytics solutions with a strong focus on data visualization, data transformation, 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 should work closely with the business to understand the business domain, define specific problems and requirements, create reports & interactive dashboards, design & implement data pipelines, and report back with the outcome of analytics in business terms. This role will work independently to design and implement appropriate analytics solutions including necessary data pipeline, data transformation and data quality. This role is also expected to perform research of external data sources and evaluate data analytics related technologies as needed.
Mattamy has strong desire to use data analytics to enhance its core US and Canadian Home Building businesses. This is a great opportunity to join a growing team and shape the future of the Home Building industry.
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.
- Design and build data pipelines that extract, transform, and load (ETL) data from various sources into our data warehouse using Active Data Factory (ADF).
- Ensure data consistency, integrity and quality during the integration process, performing data validation and cleaning as needed
- Optimizes data pipelines and data processing workflows for performance, scalability, and efficiency
- 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
- Experience slicing and pivoting SSAS OLAP cubes, Azure Active Directory, OAuth and RLS (row level security).
- Advanced knowledge of T-SQL (Microsoft SQL Server databases / Microsoft Azure SQL databases) along with Azure Data Factory framework and Python scripting using databricks
- Proven experience in designing and implementing data pipelines, transformation and optimization
- Strong knowledge of data integration/data ingestion processes using Azure Data Factory, Synapse and Databricks
- Create and maintain data models that ensure data consistency, accuracy, and accessibility.
- 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.
We encourage applicants who meet most of the role requirements to hit that submit button and apply! It’s okay if you don’t have 100% of the requirements. If you’re the right candidate, we’ll help you learn and grow.
Who we are
Mattamy Asset Management (MAM) is the parent company of Mattamy Homes Canada and Mattamy Homes U.S., which together make up the largest privately held homebuilding platform in North America.
Be yourself. We want it that way.
At Mattamy, we're passionate about creating and promoting a diverse and inclusive environment where everyone can do their best work. Diversity and inclusion are important to the work we do to support our homebuyers, colleagues, and communities. From how we build our teams to cultivating our leaders, we're on a journey toward a welcoming, barrier-free culture for everyone.
Mattamy Asset Management is committed to providing accommodation for people with disabilities. If you require accommodation through any aspects of the selection process, please notify us on your application and we will work with you to meet your needs.
Qualified applicants will be contacted directly by the Talent Acquisition team.
