Data Analyst - Finance

TYLin is a globally recognized, full-service infrastructure consulting firm committed to providing innovative, cost-effective, constructible designs for the global infrastructure market. With over 3,000 employees throughout the Americas, Asia, and Europe, the firm provides support on projects of varying size and complexity. Together, we enhance conventional designs with smarter, more resilient systems. We provide people with better mobility. We steward precious resources by finding more sustainable solutions.

Job Summary

Our Finance team is seeking a Data Analyst - Finance to support company growth.

This position will report to the Director of Finance and requires 7+ years of experience related to financial planning and analysis, ideally within an architecture/engineering/construction environment.

Responsibilities & Qualifications

DUTIES AND RESPONSIBILITIES:

• Perform financial forecasting, budgeting, reporting and operational metrics tracking
• Report on financial performance and assist with preparing business review presentations.
• Analyze past results, perform variance and root-cause analysis, identify trends, provide commentary.
• Analyze actual vs forecast and/or budget results at sector and consolidated level, identify main drivers, provide commentary
• Analyze WIP and AR accounts and registers, peform DSO and aging analysis
• Analyze and consolidate risks and opportunities register from various sectors.
• Status on cash collections and customer billings on a weekly basis.
• Analyze labor utilization and revenue variances on a weekly basis.
• Analyze balance sheet accounts and perform reconciliations.
• Assist in streamlining reporting and data analysis through automation.
• Perform various adhoc analysis and report updates from time to time and assist with other duties as requested by Director of Finance
  
  

QUALIFICATIONS (INCLUDING EDUCATION and/or JOB EXPERIENCE):

• Bachelor’s degree and more than seven years of experience in finance/accounting/FP&A, preferably in an AEC company environment.
• Experience developing financial models, reports, and presentations.
• Strong computer skills as follows:
• Proficient in advanced Excel functionalities, including VBA coding, lookup functions, pivot tables, dynamic array formulas, Power Query, and Power Pivot.
• Experience in working with BI tool such as Power BI with ability to build dashboards, querying, and data modelling
• Experience in use of Word and PowerPoint
• Experience with use of Deltek Vision is highly preferred
• Ability to manage multiple tasks and adapt to a changing, fast-paced environment
• Ability to work with large quantities of data
• Client focused, always striving to give clients the best solutions.
• Strong commitment to innovation by creating new and better ways to solve clients’ toughest challenges.
• High levels of integrity, always doing the right thing in an ethical, fair, and sustainable way.
• Demonstrated experience of collaboration in a diverse and inclusive team, working together toward technical excellence.
  
  

Additional Information

TYLin offers a comprehensive total rewards package. Our benefits include extensive medical, disability and life insurance coverage, continuing education benefits, paid time off, employee assistance program and a retirement savings plan with company matching contributions.

We encourage all candidates to explore our total rewards offering.

TYLin is an equal opportunity employer, and we prohibit discrimination and harassment of any type as protected by federal, provincial, state or local laws. We celebrate diversity and are committed to creating an inclusive environment for all employees. The company and its employees are required to comply with all local health authority, legal or lawful client requirements.