Sql analyst Jobs in North York, ON

Joining Arup

At Arup we’re dedicated to shaping a better world. Our purpose, shared values and collaborative approach have set us apart for over 80 years. We solve the world's most complex problems and deliver what seems impossible, with curiosity and creativity. We’re a thriving and growing organization which offers you many possibilities to shape a better world, and your future.

We are currently seeking a Billing Analyst to work in our Los Angeles office. Our Billing Analysts’ staff are integral members of our finance teams. It is business imperative that we continue to hire and develop highly engaged skilled professionals that will provide consistent billing and financial support for our business and our project managers/directors.

The Opportunity

• Effectively communicate with Project Managers and Project Directors to determine proper costs to invoice for the month.

• Prepare client invoices in accordance with company procedures, client requirements and terms and conditions of the contract.

• Review contracts for each new project and setup all templates and procedures to administer invoicing for all new projects.

• Record invoices into accounting system.

• Reconcile and include, as part of project invoices, sub-consultant billings for fees and reimbursable expenses.

• Work with the cash receipts team to reconcile variances that occur in the application of cash and review/clean-up of unallocated cash.

• Daily monitoring of cash receipts against sub-contractor billing tracker to release sub-consultant payments under pay-when-paid policy.

• Ensure all monthly activity is complete and accurate in the areas of customer billings, accounts payable and related postings to the accounting system.

• Assist project team with follow-up and collection of aging invoices.

• Demonstrate strong problem-solving skills and the ability to identify and correct quality control issues such as duplicate billing, data entry errors, set up/system errors, etc.

• Ability to monitor key financial metrics on projects, such as aging debts, aging WIP and cash flow.

• Assist with monthly forecasting of billings and cash collections.

• Special and ad hoc projects as assigned.

Is this role right for you?

• 2+ years of relevant experience in billing. Experience in a professional services firm is preferred.

• Experience with billing large scale major government agency projects and/or understanding FAR is preferred.

• Bachelor’s Degree is preferred in Business or related fields.

• Must have a solid knowledge of standard contract terms, including hourly, lump sum, not-to-exceed and how they are applied in the billing process.

• Advanced Excel skills are required (Pivot Tables, VLookups, sumif, etc.). Must have familiarity with general accounting software packages.

• Strong written and verbal communication skills and the ability to multi-task.

• Must be detail oriented with ability to work under pressure and within a team.
  

At Arup, you belong to an extraordinary collective – in which we encourage individuality to thrive. Our strength comes from how we respect, share and connect our diverse experiences, perspectives and ideas. You will have the opportunity do socially useful work that has meaning – to Arup, to your career, to our members and to the clients and communities we serve.

What We Offer You

At Arup, we care about each member’s success, so we can grow together.

Guided by our values, we provide an attractive total reward package that recognizes the contribution of each of our members to our shared success. As well as competitive, fair and equitable pay, we offer a career in which all of our members can belong, grow and thrive – through benefits that support health and wellbeing, a wide range of learning opportunities and many possibilities to have an impact through the work they do.

We are owned in trust on behalf of our members, giving us the freedom, with personal responsibility, to set our own direction and choose work that aligns with our purpose and adds to Arup’s legacy. Our members collaborate on ambitious projects to deliver remarkable outcomes for our clients and communities. Profit Share is a key part of our reward, enabling members to share in the results of our collective efforts.

Benefits at Work - At Arup, we have a comprehensive and valuable benefits program that works for our employees and their families while keeping costs low. These benefits provide health and welfare security for you as well as paid time off for rest and renewal. As a member of Arup, everyone shares in our success through a global profit share scheme (payments are dependent on the firm’s financial performance). Our Global Profit Share Plan (paid bi-annually) provides an opportunity for you to share in the success of the Firm. As a valued employee of Arup, you can also choose to participate in our 401(k) plan with up to 10% company match to help you save for your future.

Flexible Working - We believe that flexible arrangements create a more inclusive way of working that supports our diversity and the wellbeing of our people. Options for alternative schedules and the ability to work outside of the office for a portion of your workweek are available.

Hiring Range - The good faith base salary hiring range for this job if performed in Los Angeles is $78,000 to $85,000 per year. This range is commensurate with experience, educational background, and skill level. Benefits are not included in the base salary. Please note hiring ranges for candidates performing work outside of Los Angeles will differ.

Different People, Shared Values

Arup is an equal opportunity employer that actively promotes and nurtures a diverse and inclusive workforce. We welcome applications from individuals of all backgrounds, regardless of age (within legal limits), gender identity or expression, marital status, disability, neurotype or mental health, race or ethnicity, faith or belief, sexual orientation, socioeconomic background, and whether you’re pregnant or on family leave. We are an open environment that embraces diverse experiences, perspectives, and ideas – this drives our excellence.

Our Application Process

Arup is an equal opportunity employer. All qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, spouse of a protected veteran, or disability.

Stay safe online. Recruitment fraud is on the rise, and Arup’s name, logo, and branding have been used in fraudulent job advertisements. Arup will never ask for bank information as part of our recruitment process.

Recruitment Agencies - We have a Preferred Supplier List of trusted partners to assist us when required and do not acknowledge any speculative CVs or unsolicited candidate introductions from agencies not on the list.

#LI-JB2