Data Analyst

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.

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

• Bachelor’s degree and more than 3 years of experience in finance/accounting/FP&A, preferably in an AEC company environment.

• Experience with NYCT, MTA or other rail and transit agency required.

• Experience developing financial models, reports, and presentations.

• 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.

TYLin is committed to pay equity. As part of that commitment, we have provided the base compensation range of $80,000 - $120,000 annually for this position and local market. We recognize that each candidate brings a unique set of skills, experience, education and competencies to the table that will be reflected in our offer. TYLin is proud to offer exciting career development opportunities

TYLin offers a comprehensive total rewards package. Our benefits may 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.