Business System Analyst (14-Month Contract)

Overview

Maintain 100% accurate financial reporting and data integrity across AP/AR systems.

Key Responsibilities

• data reporting
• anomaly analysis
• system review
• system configuration
• staff guidance
• feature testing

Tasks

-Generate all bi-weekly and monthly data reports for Accounts Payable (AP) and Accounts Receivable (AR), ensuring the accurate and timely capture of data to fully support AP and AR requirements. -Analyze anomalies or discrepancies that arise from the processed data and determine the appropriate course of action to remediate those anomalies. This will include consultation various teams and its members when necessary, -Regularly review systems data to ensure completeness and correctness of inputted and processed data and verifying accuracy and completeness. -Maintain constant business awareness on anticipated and unexpected changes that may potentially impact Billing and Payroll processes. This role will advise & facilitate actions with associated teams including internal teams & external vendors with clear communications of potential effects and possible remedies without undue delay. In some cases, team leadership & ownership may be required when implementing new systems development. -Configure the various systems with updated logic to ensure data integrity and completeness. -Provides guidance to new and current staff and vendors on various work processes so the data that is input into the various systems is coherent, correct and complete, and also review the work of the Systems staff that are executing data changes to ensure those actions are correct and complete -When necessary correct anomalous data within the systems and when reasonable to do so, and -Performs testing on new features, enhancements, and corrective fixes in the LTS Systems to ensure there are no regressions and the feature is thoroughly understood and fully implemented prior to general availability to the end user.

Requirements

• python
• sql
• powershell
• power bi
• quickbase
• data modelling

What You Bring

-4+ years of experience designing operational database pipelines involving 3rd party apps, including low-code platforms such as QuickBase, Jira and Power BI -4+ years of experience with Python, SQL, and PowerShell scripting considered a strong asset -Knowledge of Billing and Payroll data and its exceptions -Expert knowledge of business systems and reporting best practices; ability to translate business requirements into robust system and reporting design specifications. -Knowledge of Billing and Payroll working processes -4+ years of experience as a business systems analyst, or data analyst with proven communication and project management skills -4+ years experience in financial data management -Strong analytical skills. -Familiarity with data modelling concepts and RDBMS best practices.

People Also Searched For

Benefits

-This is a hybrid position where you will be required to work from home and the office.

About Ledcor

-The company has been building a legacy of delivering projects across multiple sectors. -Operates throughout North America, offering a wide range of construction and infrastructure services. -Their expertise spans from residential and commercial construction to industrial and heavy civil projects. -They manage large-scale projects in energy, utilities, water resources, and transportation industries. -With decades of experience, they have developed a reputation for tackling complex, large-scale developments. -Their portfolio includes everything from skyscrapers to power plants, bridges, and pipeline systems. -They have a rich history of successfully completing multi-faceted projects, making them a trusted partner in construction. -From urban developments to remote infrastructure, their ability to adapt and deliver is unmatched. -Unique in its broad service offerings, they work on both public and private sector projects with a focus on quality and innovation.

Sector Specialisms