Business System Analyst (14-Month Contract)

Ledcor; Vancouver; Hybrid; CAD 75,000 - 104,000; Full time

Job summary

A telecommunications firm in Vancouver is seeking a Data Analyst to ensure exceptional accuracy in financial reporting and data exports. This role involves design and analysis of operational data, and requires over 4 years of relevant experience. The position has hybrid work conditions and offers a competitive compensation package ranging from $75,200 to $103,400 annually.

Benefits

Competitive compensation

Opportunities for skill development

Inclusive workplace culture

Qualifications

• 4+ years of experience designing operational database pipelines.
• 4+ years as a data analyst with proven communication and project management skills.
• Knowledge of Billing and Payroll data processes.

Responsibilities

• Ensure accuracy in financial reporting and data exports.
• Analyze discrepancies in processed data.
• Generate bi-weekly and monthly reports for Accounts Payable and Receivable.

Skills

Operational database design

Python

SQL

PowerShell scripting

Communication skills

Project management skills

Analytical skills

Tools

QuickBase

Jira

Power BI

Job description

You are a Data Analyst whose primary responsibility is to ensure exceptional accuracy in all financial reporting and data exports. You will act as the custodian of financial data, overseeing the timely and precise recording of all revenue and costs to guarantee 100% accuracy. You will require a thorough understanding of operations, cost structures, and revenue generation processes to ensure the systems and processes meet present and future operational needs.

Demonstrate deep understanding of Accounts Payable and Accounts Receivable workings and lead finance‑related projects to ensure their success.

This is a 14‑month contract position. Apply today to join Ledcor Technical Services in Vancouver, BC.

Essential Responsibilities

• Regularly review systems data to ensure completeness and correctness of inputted and processed data and verify accuracy and completeness.
• Analyze anomalies or discrepancies that arise from the processed data and determine the appropriate course of action to remediate those anomalies.
• Correct anomalous data within the systems when reasonable to do so.
• Configure the various systems with updated logic to ensure data integrity and completeness.
• Maintain constant business awareness on anticipated and unexpected changes that may impact Billing and Payroll processes. Advise and facilitate actions with associated teams, including internal teams and external vendors, with clear communications of potential effects and remedies without undue delay. Lead and own when implementing new system developments.
• Generate all bi‑weekly and monthly data reports for Accounts Payable (AP) and Accounts Receivable (AR), ensuring accurate and timely capture of data to support AP and AR requirements.
• Perform testing on new features, enhancements, and corrective fixes in the LTS systems to ensure no regressions and to confirm thorough understanding and correct implementation prior to general availability.
• Provide guidance to new and current staff and vendors on work processes so that data input into the various systems is coherent, correct, and complete, and review the work of the Systems staff executing data changes to ensure those actions are correct and complete.

Qualifications

• 4+ years of experience designing operational database pipelines involving third‑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.
• 4+ years of experience as a business systems analyst or data analyst with proven communication and project management skills.
• 4+ years of experience in financial data management.
• Knowledge of Billing and Payroll working processes.
• 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.
• Familiarity with data modelling concepts and RDBMS best practices.
• Strong analytical skills.

Work Conditions

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

Compensation

$75,200 - $103,400 annually. This is the expected base pay range for this role. Individual base pay will be determined based on a variety of factors including experience, knowledge, skills, education, and location.

Our competitive total rewards package provides compensation and benefits that support your physical, mental, and financial well‑being. We offer exciting, challenging work with opportunities to develop your skills and knowledge.

Additional Information

Ledcor Technical Services (LTS) designs, builds, and maintains wireline or wireless networks that span North America and beyond. We are a proven leader and innovator in telecommunications network construction, maintenance, and service installation and repair.

Our workplace culture has been recognized as one of Canada’s Best Diversity Employers, Canada’s Most Admired Corporate Cultures, and a Top 100 Inspiring Workplace in North America.

Employment Equity

At Ledcor we believe diversity, equity, and inclusion should be part of everything we do. We are proud to be an equal‑opportunity employer. All qualified individuals, regardless of race, color, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity, veteran status or any other identifying characteristic are encouraged to apply.

Our True Blue team consists of individuals from all backgrounds who contribute diverse perspectives and experiences to Ledcor. We are committed to continuing to build on our culture of empowerment, inclusion, and belonging.

Adjustments will be provided in all parts of our hiring process. Applicants must make their needs known in advance by requesting accommodations. For more information about Ledcor’s inclusion and diversity initiatives, please visit our diversity page.