Sql data analyst Jobs in Etobicoke, ON

Location:

Toronto, Ontarioor Mississauga, Ontario –Hybrid (4 days/week in office)

Company:

Mattamy Asset Management

Department:

IT Enterprise Services

Employment Type:

Full-Time

Reports to:

Senior Manager, Financial Systems

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

The Financial Data & Systems Analyst is responsible for ensuring the integrity, accuracy, security, and governance of financial data across enterprise financial systems (e.g., OneStream, Oracle PBCS, ERP platforms).

This role combines hands-on system administration with data governance leadership, ensuring that financial data is reliable, controlled, and aligned with business, audit, and regulatory requirements while supporting planning, forecasting, and financial close processes.

What you’ll do

• Provide day-to-day administration and support of financial systems, including configuration, maintenance, and troubleshooting
• Maintain system components such as: Metadata, hierarchies, dimensions, mapping tables integrations, security roles and access controls
• Execute and monitor processes supporting: Financial close cycles, Budgeting and forecasting
• Manage system updates, data loads, and validation processes to ensure accuracy and completeness
• Support the implementation and enforcement of data governance standards and controls, including data definitions, business rules, data ownership, segregation of duties (SoD), and access reviews, ensuring compliance and audit readiness.
• Maintain comprehensive documentation (data governance policies, system configuration, data flows, and control artifacts) and support internal and external audits, ensuring traceability and compliance.
• Ensure data accuracy through validation, reconciliation, and audit controls
• Monitor and resolve data quality issues, including root cause analysis and remediation
• Maintain alignment of financial data between source systems (ERP) and reporting platforms
• Manage financial data flows across systems, including Data extraction, transformation, loading, integration monitoring and issue resolution
• Contribute to maintaining documentation including data governance policies,system configuration, data flows, audit and compliance artifacts
• Support internal and external audits for financial systems and data controls

What you bring

• Minimum 1 year of experiencein financial systems administration (e.g., OneStream, Oracle, SAP, Workday) Data governance, data management, or financial data analysis
• Experience with data validation, reconciliation, controls, financial close, budgeting, and forecasting processes
• Knowledge of: Data governance frameworks, best practices, financial data structures (chart of accounts, entities, cost centers, etc.)
• Strong analytical and problem-solving skills
• High attention to detail and data accuracy
• Ability to translate business requirements into system and data solutions
• Strong collaboration across Finance, IT, and Data teams
• Effective communication with both technical and business stakeholders

Bonus Points

• Experience with OneStream or Oracle PBCS
• Basic SQL or data query skills
• Exposure to ETL/data integration tools
• Understanding of SOX or audit controls

Compensation

The expected base salary range for this position is $57,500 - $87,500. Actual pay may vary depending on your job-related knowledge, competencies, and skills. We recognize that exceptional situations may fall outside this range, and we encourage all interested candidates to apply.

You are also eligible to participate in Mattamy’s annual bonus program which gives you the opportunity to increase your total compensation if business and individual goals are achieved.

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 family-owned 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.