Data Analyst

2 months ago


Woodbridge, Canada 407 ETR Full time

Position Summary

This role focuses on financial data analysis and the development and maintenance of financial models to support decision-making and financial reporting. The position involves creating SQL queries for large-scale data extraction, building financial models in Excel, and automating operational reports and processes. Collaboration with various staff members and business units is essential to fulfill the role's responsibilities.

Duties:

- Assist the Senior Data Analyst in developing SQL queries to extract data from various data warehouses for use in financial models and ad-hoc reporting.
- Support the Senior Manager of Finance in completing ad-hoc requests and audit requirements within tight timelines.
- Maintaining financial models that are critical for understanding accounts receivable, revenue, cash receipts, and collections.
- Develop, monitor, and maintain data warehouses, including updating, adding new data requirements, and ensuring data integrity.
- Analyze and validate results from SQL query reports for reasonableness and reviewing of financial models for accuracy and consistencies.
- Automate manual processes by leveraging scripting or programming languages to improve efficiency and accuracy.
- Perform other duties as assigned.

Qualifications:

- Bachelor's Degree from an accredited college or university, preferably with a degree in business administration (finance and accounting), or a related field.
- Minimum 2 years of experience in financial reporting or analytics role.
- Intermediate proficiency in SQL, database systems and cloud platform is required, preferably on financial and customer data. Experience with SAP, SAS and Python is considered an asset.
- Strong background in financial analysis, accounting cycle, and understanding business operations, qualitative, and quantitative results.
- Experience with various software including Peoplesoft, Dbeaver, Tableau, Power BI, Salesforce and SAP is an asset.
- Ability to work independently, great organizational and time management skills; planning and project management, and ability to meet multiple deadlines.
- Outstanding interpersonal, collaboration, and written and verbal communication skills in a team setting to present results.
- Commitment to personal growth and development.

About 407 ETR

Highway 407 ETR is an all-electronic open-access toll highway located in the Greater Toronto Area in Ontario, Canada. The highway spans 108 kilometres from Burlington in the west to Pickering in the east.

407 International Inc. is the sole shareholder of 407 ETR and is owned by:

- Canada Pension Plan Investment Board (CPP Investments) through indirectly-owned subsidiaries (50.01%);
- Cintra Global S.E. which is a wholly-owned subsidiary of Ferrovial S.A. (43.23%); and
- AtkinsRéalis, formally known as SNC-Lavalin (6.76%).

Learn more at


Note: _At 407 ETR, we are committed to fostering a diverse, equitable, and inclusive work environment. We value the unique perspectives and backgrounds of all individuals, and we firmly believe that our individual differences make us stronger as a whole._
- Our commitment to inclusion extends beyond recruitment and encompasses an inclusive workplace culture through raising awareness, ongoing training, and encouraging feedback. We aim to create a safe and supportive environment where all employees can thrive._Highway 407 ETR is located in the Greater Toronto Area in Ontario, Canada and spans 108 km from Burlington in the west to Pickering in the east.


  • Data Analyst

    2 months ago


    Woodbridge, Canada Quality Cheese Inc. Full time

    **Passionate about Cheese!** With a long history of cheese making, and a deep respect for tradition and inspired innovation, Quality Cheese is recognized as one of Canada’s premium cheese manufacturers and continues to enhance that reputation as it strives for continued excellence and improvement. We are widely recognized for our innovative product...


  • Woodbridge, Ontario, Canada Viana Inc. Full time

    Job Title: Data Warehouse AnalystViana Inc. is seeking a highly skilled Data Warehouse Analyst to join our team. As a Data Warehouse Analyst, you will be responsible for designing and developing databases, operating database management systems to analyze data, and developing and implementing data administration policies, standards, and...


  • Woodbridge, Ontario, Canada Viana Inc. Full time

    Job Title: Data Warehouse AnalystViana Inc. is seeking a highly skilled Data Warehouse Analyst to join our team. As a Data Warehouse Analyst, you will be responsible for designing and developing databases, operating database management systems to analyze data, and developing and implementing data administration policies, standards, and...

  • Financial Analyst

    5 months ago


    Woodbridge, Canada REV Capital Full time

    Role: Financial Analyst Type: Permanent, Full-Time Location: Onsite, Woodbridge, ON **Financial Analyst** REV Capital is seeking a Financial Analyst to join our growing team! Reporting to the Director of Compliance, the Financial Analyst will analyze financial data to support decision-making processes. **About REV Capital**: REV Capital is the leading...

  • Financial Analyst

    4 months ago


    Woodbridge, Canada Best Way Stone Ltd. Full time

    Paving a Brighter Future Together!_ **Who we are**: **What we offer**: We offer a comprehensive compensation package, which includes: - A competitive wage, dependent on education, skills and experience. - Group Benefits (Health, Dental, HCSA). - Life Insurance - Company sponsored events - Employee & Family Assistance Plan (EFAP) - Wellness Program - Group...

  • Data Warehouse Analyst

    5 months ago


    Woodbridge, Canada Viana Inc. Full time

    Work Term: Permanent - Work Language: English - Hours: 35 hours per week - Education: Bachelor's degree - Experience: 1 year to less than 2 years **Tasks**: - Design and develop database - Operate database management systems to analyze data - Develop and implement data administration policy, standards and models - Research and document data requirements,...

  • Database Analyst

    1 month ago


    Woodbridge, Canada Add impact INC. Full time

    Work Term: Permanent - Work Language: English - Hours: 35 hours per week - Education: Bachelor's degree - Experience: 1 year to less than 2 years - Computer systems analysis/analyst - Computer science **Work setting**: - Willing to relocate - Trading **Tasks**: - Collect data to identify areas for improvement within an organization's IT infrastructure -...


  • Woodbridge, Canada MMNovatech Full time

    At MM Nova Tech, we are dedicated to staying ahead of market trends and making data-driven decisions to achieve our business goals. We are seeking a dynamic and detail-oriented Market Research Analyst to join our rapidly expanding office in _**Woodbridge and Brampton location**_. This role is crucial in providing insights that drive our strategies and help...

  • Credit Risk Analyst

    5 months ago


    Woodbridge, Canada REV Capital Full time

    Role: Credit Risk Analyst Employment type: Full-time permanent Location: On-site, Woodbridge, ON **Credit Risk Analyst** REV Capital is seeking a Credit Risk Analyst to play a pivotal role in maintaining the financial stability and growth of our organization through meticulous credit assessment and risk management practices. The Credit Risk Analyst will...

  • Jr. Sales Analyst

    2 months ago


    Woodbridge, Canada Summer Fresh Full time

    Summer Fresh Salads is a leading manufacturer of hummus, dips, and salads in Canada. We are seeking a detail-oriented and analytical Junior Sales Analyst to join our insights team. This key position within our organization will report to the Business Intelligence Manager. This role is ideal for someone looking to start or grow their career in sales...


  • Woodbridge, Canada Buttcon Full time

    **_Transforming visions into buildings. _** **About Buttcon** Buttcon is proud to be a 100% employee-owned COR certified, leading Canadian General Contractor with projects from coast to coast. As a leader in the construction industry, we deliver quality services in ICI and multi-unit residential construction with a focus on off-site construction and...


  • Woodbridge, Canada Buttcon Limited Full time

    _**Transforming visions into buildings.**_ **About Buttcon** Buttcon is proud to be a 100% employee-owned COR certified, leading Canadian General Contractor with projects from coast to coast. As a leader in the construction industry, we deliver quality services in ICI and multi-unit residential construction with a focus on off-site construction and...

  • Merchandising Analyst

    5 months ago


    Woodbridge, Canada Sporting Life Inc Full time

    Sporting Life is a leading, iconic Canadian sports lifestyle retailer. Since 1979, we've been committed to providing our customers and their families with the best possible experience—and we continuously work to improve it every day. We offer the best in outdoor apparel and fashion, footwear, equipment and accessories for men, women and kids. The mix of...

  • Merchandising Analyst

    6 months ago


    Woodbridge, Canada Sporting Life Inc Full time

    As a Merchandising Analyst for Sporting Life (SL) your role will be pivotal in supporting the Accessories Buyer in product management and coordination for our stores nationwide. Your contributions will directly impact our ability to serve our customers' needs. In this role, you will manage and distribute inventories to all stores by working...

  • Merchandising Analyst

    5 months ago


    Woodbridge, Canada Golf Town Operating Limited Partnership Full time

    Golf Town has grown to become the Home of Golf in Canada. Our online web business and stores across Canada have everything customers need to play their very best. The Golf Town stores and site are sanctuaries where golf devotees come to try, buy, learn about and improve their golf game. Our big box stores which average 18,000 square feet allow us to carry an...


  • Woodbridge, Canada 407 ETR Full time

    Position Responsibilities: - Develop a solid understanding of AWS databases and their structures to support reporting on key business information. - Acquire data from primary or secondary data sources and maintain data dictionary and mapping. - Review, analyze data, interpret, and summarize key information to help identify trends and insights related to...

  • Credit Risk Analyst

    4 months ago


    Woodbridge, Canada REV Capital Full time

    Role: Credit Risk Analyst Employment type: Full-time, Permanent Location: On-site, Woodbridge, ON **Credit Risk Analyst** REV Capital is seeking an Credit Risk Analyst to play a pivotal role in maintaining the financial stability and growth of our organization through managing complex accounts and conducting thorough risk assessments while ensuring...

  • Inventory Analyst

    2 months ago


    Woodbridge, Canada White Cap Canada Inc. Full time

    _A position at White Cap Canada isn’t your ordinary job. You’ll work in an _**exciting and diverse **_environment, meet interesting people, and have a _**variety of career opportunities.**_ _We serve customers in the _**construction, industrial**_**, **_**and institutional markets**_ _and we are one of the most agile distributors of fasteners, tools,...


  • Woodbridge, Canada 407 ETR Full time

    Position Summary: The Customer Solutions Analyst’s core responsibility is to be a customer experience and internal process expert. They are driven to improve the customer experience through all channels. The individual will complete customer data analysis, review, and recommended process efficiencies. They will support transformational initiatives and...

  • Financial Analyst

    4 months ago


    Woodbridge, Canada Westlake Careers Full time

    **SUMMARY** The Financial Analyst is responsible for providing financial accounting and analysis to support the Controller and the Finance Group for the one of the divisions of the business. Responsibilities encompass monthly financial close and reporting, assisting with monthly forecasts and annual budgets. The role is a hybrid role of approximately 70/30...