Business Data Analyst

**About BNA O&M General Partnership**

Bridging North America (BNA) was selected to design, build, finance, operate and maintain the CAD $6.4 billion Gordie Howe International Bridge project for Windsor-Detroit Bridge Authority (WDBA) - a Public-Private-Partnership (P3). BNAOM is the OMR entity managing the Operations, Maintenance, and Rehabilitation of the Project for a term of 30 years.

When completed, the bridge will be the longest cable-stayed bridge in North America. The project includes a bridge and border crossing spanning the Detroit River and connecting Detroit, Michigan, U.S., and Windsor, Ontario, Canada, by linking Interstate 75 and Interstate 96 in Michigan with the new extension of Highway 401 (Rt. Hon. Herb Gray Parkway) in Ontario. The scope also includes building new, state-of-the-art ports of entry on both the U.S. and Canadian sides of the Detroit River as well as improvements to existing infrastructure in both Michigan and Ontario.

The Canadian Port of Entry is an approximate 53 hectare or 130-acre site and will be the largest Canadian port along the Canada-US border, and one of the largest anywhere in North America. It includes inbound border inspection facilities for both passenger and commercial vehicles, outbound inspection facilities, toll collection facilities, a maintenance facility and parking.

The US Port of Entry has an approximate 68 hectare or 167-acre site and will be one of the largest US ports along the Canada-US border and in North America. It includes US inbound border inspection facilities for both passenger and commercial vehicles, US outbound inspection facilities, commercial exit control booths and parking.

**Job Summary**

The **Business & Data Analyst will report to the Toll & System Manager, or other such person as may be designated by the CEO, and is responsible for analyzing business processes, extracting and manipulating data, creating reports, identifying areas for improvement, and developing strategies to enhance efficiency and productivity. The Business & Data Analyst **directly supports and assists BNAOM senior management to plan and mobilize BNAOM for the Interim Operation and Maintenance period and the Operation, Maintenance and Rehabilitation period of the project.

**Roles & Responsibilities**

In this role, it will be important to have a service-oriented attitude and a commitment to delivering excellent solutions to our external clients. We are looking for someone with experience in process improvement who will constantly seek out opportunities for achieving greater efficiencies in our business. This position offers a broad and exciting range of technical challenges and opportunities.

**KEY RESPONSIBILITIES**
- Preparation of presentations and analyses for management
- Support internal clients by analyzing their needs and defining the required indicators, methodologies and relevant tools in order to provide useful information
- Configure automated reports and dashboards, and collaborate with business intelligence analysts
- Develop interfaces, extract, process, consolidate raw data from different systems, in order to produce specific analyses
- Measure the effectiveness and efficiency of various activities and identify savings opportunities related to process improvements
- Process various requests for data of varying complexity, managing priorities
- Report data integrity and confidentiality issues
- Develop an in-depth knowledge of how expert systems work: Toll Collection System, Intelligent Transport System, Security and Access Management System, Instrumentation and monitoring system for structures, Electrical distribution monitoring and Building Automation System, Asset Information Management System, Maintenance Management System, Functional and architectural lighting management system, Financial and accounting management system, Emergency Management System
- Develop an in-depth knowledge of the architecture and operation of backend components: Operating systems (Windows and Linux), Cloud platforms and services (Azure, AWS and OCI), Data processing services (Fabric, Power Platform), Database queries, security and optimization (Oracle, MS SQL Server and MariaDB), Scripting languages (PowerShell, Python, Bash), Programming languages (Java, HTML/CSS, C#)
- Advise management on the effectiveness of planned or utilized solutions and make recommendations for upgrading or improving systems
- Coordinate and supervise service and equipment suppliers to identify and resolve non-conformities during systems implementation and testing/commissioning leading to final acceptance of various systems and solutions
- Assist and train staff on the use of systems
- Prepare monthly, quarterly, annual and ad hoc reports in accordance with the Quality Management System (QMS) and the Technical Requirements
- Define network access rules and implement security measures to keep our company's networks and systems safe from unwanted intrusion, data leaks, and malicious acti