Data Integration Analyst (Hybrid Opportunity)
in Saint John, NB

Saint John, NB
Full-time - Permanent
Save for Later
Competition Number: R118541
Company Website:
Job Title
Data Integration Analyst (Hybrid Opportunity)
Who are we?
Founded in 1924, Irving Oil is a family-owned international refining and marketing company with a history of long-term partnerships and relationships. With operations throughout Eastern Canada, New England and Ireland we focus on delivering quality products and exceptional service to our customers and our communities. Every day, we strive to put our good energy in action to bring families together, support the environment and local wildlife, and to create learning opportunities that empower the next generation.
Here's what you can expect from us:
When you're a part of our team, you'll see how we bring good energy to all that we do. At Irving Oil, we strive for a work environment where each of us feels we belong, can bring our whole selves to work, and where we treat our fellow employees with kindness and respect. Together, we will support our corporate strategy, high standards and the communities where we live and work. Our collaborative approach, safety-first culture and commitment to building resilient teams helps reinforce our internal brand position where People Matter. That's why we're dedicated to investing in our employees' potential, so that they can reach their career goals.
Job Description
What you can expect in a typical day
The Data Integration Analyst works collaboratively with business stakeholders, vendors, and other members of IT to define, build, test and support the implementation of IT solutions related to our data integration and data analytics platforms. This role is responsible for identifying business requirements, understanding issues, propose recommended solutions and participate in projects to implement them. This role requires excellent communication with stakeholders and our vendors to ensure alignment, resolve issues, optimize existing solutions, and/or scoping future enhancements. This role also works with and mentors junior Data Integration Analysts as they develop their skills and experience. Please note that this position will require shift flexibility and rotational on-call work.
What we offer:
  • Competitive salary, bonus, and pension plan
  • Flexible benefits, including a Health Spending Account
  • Hybrid Work Opportunity - flexible work model that supports a blend of in-office and remote
  • Wellness support, including annual wellness allowance and paid personal care days
  • Paid vacation and vacation purchasing
  • Personal and professional development opportunities
  • Named one of Canada's Top 100 Employers for six consecutive years

Your roles and responsibilities:
  • Leverage existing and potential relationships to facilitate solutions.
  • Provide constructive and well thought out feedback within team, both horizontally and vertically within an organization.
  • Problem solve and troubleshoot moderate to complex data and/or software issues in a timely manner.
  • Collaborate with stakeholders at any level to identify incident requirements, understand issues, review possible solutions and present recommendations.
  • Support the development of project plans, gathering requirements and creating broad scopes. Participate in projects to implement new solutions or enhancements.
  • Evaluate the approach to deal with issues, either undertaking to resolve or by escalating issues with other IT team members and vendors.
  • Support less experienced Data Integration Analysts by providing guidance and mentoring them.
  • Adhere to all service management best practices on an individual level.
  • Create and provide ongoing maintenance of support documentation as required.
  • Monitor, analyze, and troubleshoot most complex data solutions for potential issues and keep them running reliably.
  • Support application patches, upgrades, and installation when required.
  • Communicate the value of a process centric approach to solving problems and taking advantage of opportunities.
  • Work closely with business subject matter experts to understand challenges faced that could have a portion of the solution based on technology.

Professional skills
  • Ability to mentor junior members of the team
  • Proven troubleshooting skills
  • Ability to multi-task and shift priorities as required
  • Able to set priorities based on business and stakeholder
  • Proven time management and organizational skills
  • Demonstrated interpersonal communication skills
  • Aptitude to embrace ongoing change in technology
  • Sense of urgency in completing tasks as assigned
  • Comfortable working with senior leadership as stakeholders.
  • Ability to bring existing skills and experience to any improve any business problem.
  • The ability to be prepared and ask intelligent and compelling questions when in any meeting.
  • Comfortable working in a team environment and able to take responsibility individually.
  • A desire to improve processes. Inefficiencies bother you.
  • An interest in learning about new areas of the business.
  • Prior experience understanding and managing the lifecycle of technology solutions.
  • An understanding of why processes that are fit-for-purpose, improve the outcome and are worth the effort to follow.

  • Travel is not a requirement for this role.

Education and experience
  • Undergraduate Degree or College diploma in related field
  • Minimum of 3 Years in enterprise-level application development and integration
  • Technically fluent in programming languages, including Java, SQL, DOS/Shell Scripting
  • Hands-on experience with integration tools such as Talend, Informatica, WBIMB, Mulesoft, TIBCO, WSO2
  • Knowledge of Service-Oriented Architecture, Enterprise Service Bus, and Enterprise Integration Patterns
  • Knowledge of relational database design and management techniques
  • Competency with XML and JSON constructs
  • Confidence and experience with API protocols and schemas such as SOAP and REST
  • Experience with securing integration scenarios using appropriate authentication, authorization, non-repudiation, and data encryption methods
  • Strong knowledge of system and software quality assurance best practices and methodologies
  • Knowledge of network protocols and standards
  • Knowledge of Master Data Management an asset
  • Experience with designing, building, installing, configuring, and supporting data warehouses an asset

Please note that this position will require shift flexibility and rotational on-call work.
Irving Oil supports a diverse and inclusive work environment and welcomes applications from all qualified applicants.
Job Requirements - Work Experience
Information Technology
Job Requirements - Education
Diploma / Certification: Information Technology
Saint John, NB
Save for Later