Data Integration Administrator


Data Integration Administrator

POSITION SUMMARY

Reporting to the Manager, Digital Business, the Data Integrations Administrator leads in supporting integrations between software platforms, programs, and applications. This includes the conception, design, development and ongoing support of interfaces and integration architectures.

MAJOR POSITION ACCOUNTABILITIES

  • Develop and ongoing support for data integration applications.
  • Develop and ongoing support for in-house web applications.
  • Ensures that best practices are followed for all in-house development.
  • Ensures data quality, timeliness, context, and volume is appropriate to the business need to ensure value can be provided.
  • Responsible for optimizing existing data integrations and applications to continually improve performance.
  • Works with business users to convert operational specifications into technical designs and documentation.
  • Follows ITIL Change Management framework when implementing changes.
  • Leads the Data Analytics Coordinators in developing and supporting data integration projects and applications.
  • Supervises the Data Analytics Coordinators and promotes their development through performance management.
  • Completes assignments for the Manager, Digital Business, and others, as required.

JOB SPECIFICATIONS

Formal Education

  • Degree from a College or University, specifically with a Technology background or a Diploma in Technology or related experience.
  • Relevant certifications from organizations such as ITIL, Microsoft, ISC2, Esri

Related Experience

  • Minimum 5 years of related experience developing integrations between applications using APIs such as SOAP or REST.

Other Requirements

  • Experience with various programming languages such as C# and Python.
  • Experience with structured query languages such as T-SQL.
  • Experience with markup languages such as HTML, and XML.
  • Experience with SSIS or other data ingestion and transformation tools.
  • Experience using Safe FME for processing geospatial data.
  • Experience with report writing, organizing, and presenting data supporting decision-making.
  • Knowledge of relational database structures, theories, principles, and practices.
  • Knowledge of ETL methodologies.
  • Knowledge of the Esri ArcGIS Enterprise platform is an asset.
  • Demonstrates statistical and empirical analytical skills.
  • Excellent interpersonal and communication skills (both verbal and written).
  • Good knowledge of data privacy practices.
  • Strong ability to organize and present data in support of decision-making.
  • Demonstrated ability to manage multiple projects concurrently and to handle changing priorities effectively.
  • Enthusiastic and self-motivated. 
  • Works well individually and in a team environment.
  • Creative and intuitive thinker.
  • Demonstrates commitment to the Port’s Vision.
  • Able to obtain security clearance under Transport Canada’s Security Clearance Program.

The starting base salary range for this role is $102,937 – 128,671

Equity, Diversity, Inclusion and Belonging are at the heart of PRPA’s culture and play a vital role in our growth strategy. We are committed to ensuring that everyone feels a sense of belonging and can contribute to their maximum potential. Our differences are the reason great things happen here. If you are an applicant in need of accommodations or special assistance throughout the interview process, please submit a request by email to careers@rupertport.com.

Individuals of Indigenous descent are strongly encouraged to apply.

Data Integration Administrator

APPLY NOW

Other career opportunities

Position

Posting Date
Closing Date

Paralegal

Reporting to the Director, Legal Services, the Paralegal provides a broad range of legal support services to the Commercial & Regulatory Affairs Department.
2024/11/25
2025/01/31
+

POSITION SUMMARY

Reporting to the Director, Legal Services, the Paralegal provides a broad range of legal support services to the Commercial & Regulatory Affairs Department.

ACCOUNTABILITIES

  • Works with internal stakeholders to draft a wide variety of commercial agreements, including leases, licenses, amendments, assignments, memorandums of understanding, master service agreements, feasibility agreement, project development agreements and construction contracts.
  • Manages contracting requirements for major capital projects by coordinating legal agreements, attending meetings, tracking deadlines, completing due diligence requirements, managing closing agendas and creating final closing books.
  • Conducts legal research of case law, legislation and regulations to develop succinct and detailed research memos.
  • Maintains internal templates and clause banks to ensure compliance with current legislation and evolving case law.
  • Acts as a liaison and corresponds with external and opposing counsel to manage and coordinate files, deadlines, and deliverables.
  • Manages electronic files and workflow in accordance with internal policies and procedures, ensuring documents and correspondence are appropriately filed in the electronic database (MFiles), deadlines are diarized, and file alarms are set and actioned.
  • Drafts content for the Management Report and project specific Board submissions, as the subject matter expert on legal activities and ongoing projects. Develops other Board materials as required
  • Conducts due diligence searches including corporate registries, Land Titles, and Personal Property registrations.
  • Provide legal guidance, leadership and support to the Legal Assistant(s), Contract Compliance Specialist and other members of the Commercial & Regulatory Affairs team.
  • Ensures all confidential files and correspondence are handled professionally, efficiently and with great care and detail.
  • Performs other duties as required.

JOB SPECIFICATIONS

Formal Education

  • Paralegal Diploma or Certification from an accredited institution.

Related Experience

  • Paralegal with a minimum of 5 years’ of broad corporate and commercial experience in a law firm or mid-to-large size corporation • Experience in drafting contracts
  • Experience in corporate, commercial, and real property law preferred
  • Experience in employment law and/or litigation is an asset

Other Requirements

  • Strong knowledge of legal research methods and databases.
  • Strong spoken and written communication skills.
  • Strong organizational skills and attention to detail.
  • Good interpersonal skills with an ability to establish and maintain effective working relationships.
  • Demonstrated ability to manage multiple projects concurrently and to effectively handle changing priorities.
  • Enthusiastic and self-motivated. Works well individually as well as in a team environment.
  • Ability to manage multiple tasks and meet deadlines.
  • Resilient. Embraces and thrives on change.
  • Able to obtain security clearance under Transport Canada’s Security Clearance Program.
  • Possess a valid Class 5 Driver’s Licence.

The starting base salary range for this role is $102,937 – $128,671

Equity, Diversity, Inclusion and Belonging are at the heart of PRPA’s culture and play a vital role in our growth strategy. We are committed to ensuring that everyone feels a sense of belonging and can contribute to their maximum potential. Our differences are the reason great things happen here. If you are an applicant in need of accommodations or special assistance throughout the interview process, please submit a request by email to careers@rupertport.com.

Individuals of Indigenous descent are strongly encouraged to apply.

Legal Assistant (Executive & Governance)

Reporting to the Vice-President, the Legal Assistant is responsible for providing executive-level legal and administrative support to the Vice-President, the Board of Directors, and the Associate Corporate Secretary& Compliance Officer. The Legal Assistant ensures efficient coordination and maintenance of the Commercial & Regulatory Affairs Department’s responsibilities and functions including oversight of the department’s files, activities, and schedule.
2024/11/28
2025/01/31
+

POSITION SUMMARY

Reporting to the Vice-President, the Legal Assistant is responsible for providing executive-level legal and administrative support to the Vice-President, the Board of Directors, and the Associate Corporate Secretary& Compliance Officer. The Legal Assistant ensures efficient coordination and maintenance of the Commercial & Regulatory Affairs Department’s responsibilities and functions including oversight of the department’s files, activities, and schedule.

ACCOUNTABILITIES

  • Provides executive level support to the Vice-President and the Board of Directors by ensuring correspondence, appointments, and administrative services are effectively managed including timely filing, response, and follow-up on emails while maintaining working knowledge of ongoing business files, initiatives, and contacts of the Vice-President, and the Board of Directors.
  • Receives and manages incoming correspondence, telephone calls, and emails on behalf of the Vice President, providing timely reminders to ensure efficient and effective responses while assisting the Vice President in maintaining the effective and smooth operations of the Vice President’s activities, schedule, and office administration.
  • Ensures all confidential files and correspondence are handled confidentially, professionally, and efficiently.
  • Maintains a working administrative knowledge of the various corporate files, including the commercial initiatives, contracts, projects and regulatory files of the Vice President and Associate Corporate Secretary & Compliance Officer, to ensure appropriate response and follow-up, providing administrative advice and reminders to ensure his/her efficient and effective management.
  • Manages electronic files and workflow for the Vice-President and Board of Directors in accordance with internal policies and procedures, ensuring documents and correspondence are appropriately filed in the electronic databases (M-Files and Diligent Boards)).
  • Prepares a variety of correspondence, legal documents, memos, presentations, meeting agendas, and reports for the Vice-President, the Board of Directors, and the Associate Corporate Secretary & Compliance Officer.
  • Performs legal research, generates reports, and completes special projects as required.
  • Coordinates business meetings, luncheons and other special functions.
  • Responsible for updating the Board Governance Manual, Board and Committee calendars, Directors’ Handbook, and other Board related materials as required, and for drafting Board meeting agendas, resolutions, content for the Management Report, and Board submissions, in addition to developing other Board materials as required.
  • Responsible for coordinating travel arrangements, and preparing expense claims, and reports for the Vice-President, the Associate Corporate Secretary & Compliance Officer, and the Board of Directors.
  • Provides legal and administrative support to other PRPA departments, as required.
  • Proofs all documents, reports, and correspondence for format, content, grammar, spelling, and make edits as necessary.
  • Responsible for overall oversight of the Commercial & Regulatory Affairs department, including maintaining department calendar, schedules, and task lists, coordinating task assignments for the department, and diarizing files and calendars of applicable court dates or other work-related deadlines.
  • Tracks the CRA department’s work accomplishments and progress towards organizational strategic objectives. Responsible for conducting annual Legal Department Survey and tracking performance of KPIs.
  • Coordinates the budget development and review process for the department to ensure process timelines are met. Responsible for scheduling regular budget reviews and for ensuring invoices are properly coded for the Finance Department.
  • Participates in departmental and project meetings for purposes of recording activity, meeting discussions, action items, and outcomes for corporate records.
  • Performs other duties as required.

 JOB SPECIFICATIONS

Formal Education

  • Minimum 2 years post-secondary education – legal assistant designation or university degree considered an asset.

 Related Experience

  • Minimum 5 years related experience as an executive assistant, legal assistant, or other comparable experience.

 Other Requirements

  • Strong knowledge of computers and proficient in MS Office, especially Outlook, Word, Excel, and PowerPoint.
  • Strong spoken and written communication skills.
  • Strong organizational skills and attention to detail.
  • Sound judgement and tact in dealing with sensitive issues and confidential information.
  • Good interpersonal skills with an ability to establish and maintain effective working relationships.
  • Demonstrated ability to manage multiple projects concurrently and to effectively handle changing priorities.
  • Enthusiastic and self-motivated. Works well individually as well as in a team environment.
  • Ability to manage multiple tasks and meet deadlines.
  • Resilient. Embraces and thrives on change.
  • Able to obtain security clearance under Transport Canada’s Security Clearance Program.
  • Possess valid Class 5 Driver’s Licence.

The starting base salary range for this role is $74,092 – $92,615

Equity, Diversity, Inclusion and Belonging are at the heart of PRPA’s culture and play a vital role in our growth strategy. We are committed to ensuring that everyone feels a sense of belonging and can contribute to their maximum potential. Our differences are the reason great things happen here. If you are an applicant in need of accommodations or special assistance throughout the interview process, please submit a request by email to careers@rupertport.com.

Individuals of Indigenous descent are strongly encouraged to apply.

Account Manager

Reporting to the Manager of Marketing, the Account Manager plays a forward-facing role by engaging with our customers and supply chain service providers in the container industry. This role involves working alongside our terminal operators and supply chain partners and serves as the primary point of contact for customers utilizing the Prince Rupert Gateway.
2024/09/27
2024/12/31
+

POSITION SUMMARY

Reporting to the Manager of Marketing, the Account Manager plays a forward-facing role by engaging with our customers and supply chain service providers in the container industry. This role involves working alongside our terminal operators and supply chain partners and serves as the primary point of contact for customers utilizing the Prince Rupert Gateway.

The account manager’s primary focus is on the Port’s intermodal customers. By engaging with customers and supply chain partners, the Account Manager is pivotal in driving volume growth and diversification to maximize the port’s potential as a competitive gateway.

ACCOUNTABILITIES

  • Leads direct engagement with intermodal importers and exporters, driving a deeper understanding of the value proposition of the Prince Rupert Gateway with Canadian and US customers in order to drive container volume while product diversification.
  • Involves in all stages of planning, preparation and execution of marketing tactics focused on direct customer engagement. This may present itself through webinars, customer outreach, event attendance and participation throughout North America.  
  • Executes PRPA’s Marketing Strategy broadening awareness of the Prince Rupert value proposition, current and expected supply chain performance with the goal of driving business through the Prince Rupert Gateway. This position will enable product diversification and support the future growth of the intermodal industry in Prince Rupert.
  • Supports improved strategies for new business development, including prospecting, cold calling, and sales pipeline management. Stewards customer relationship management from initial engagement to follow-up, handles shipper inquiries, requests, and facilitates introductions through our supply chain partners.
  • Proactively addresses any potential service issues with the Manager, Trade Development, and operational partners to ensure that Gateway users are experiencing a high degree of satisfaction. 
  • Responsible for identifying and pursuing opportunities for growth with new and existing customers. The position asks gateway users pertinent questions to develop an understanding of their supply chains and stay abreast of competitive developments in the customers’ markets.   
  • Represents the Port at various meetings, conferences, seminars and other functions, providing management with a record of the proceedings, outcomes and opportunities.
  • Performs other related duties as required.

JOB SPECIFICATIONS

Formal Education

  • Bachelor’s degree, preferably in Business Administration or Commerce with an emphasis on marketing.

Related Experience

  • 3 to 5 years’ of related experience.
  • Experience in managing a portfolio of customer relationships.
  • Supply chain, sales and/or business development experience is considered an asset.

Other Requirements

  • Strong spoken and written communication skills.
  • Strong relationship-building skills. Able to establish and maintain effective working relationships with all levels of employees and external parties, notably intermodal shippers.
  • Excellent customer service skills.
  • Superior judgment and tact in dealing with sensitive issues and confidential information
  • Demonstrated ability to manage multiple projects concurrently and to effectively handle changing priorities.
  • Enthusiastic and self-motivated. Works well individually as well as in a team environment.
  • Proficient in MS Office, especially Microsoft Word, Excel, and PowerPoint
  • Able to obtain security clearance under Transport Canada’s Security Clearance Program.
  • Possess valid Class 5 Drivers License.

The starting base salary range for this role is $86,755 – 108,444

Equity, Diversity, Inclusion and Belonging are at the heart of PRPA’s culture and play a vital role in our growth strategy. We are committed to ensuring that everyone feels a sense of belonging and can contribute to their maximum potential. Our differences are the reason great things happen here. If you are an applicant in need of accommodations or special assistance throughout the interview process, please submit a request by email to careers@rupertport.com.

Individuals of Indigenous descent are strongly encouraged to apply.