Senior Data Services Specialist
Irving Oil
Saint John, NB
Who are we?

Founded in 1924, Irving Oil is a family-owned company with operations throughout Eastern Canada, New England and Ireland with a focus on providing exceptional service and high-quality products to our customers. 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 our business and our employees. Together, we will support our corporate strategy, high standards and the communities where we live and work. Our collaborative approach, commitment to diversity and inclusion along with our safety-first culture helps reinforce our internal brand position where People Matter. That's why we're dedicated to the development of our employees, so that they can reach their career goals.

What you can expect in a typical day

As a Senior Data Services Specialist on our Data and Integration Services team, you will work collaboratively with various users, customers and technical teams to meet commitments to internal and external stakeholders primarily through the development and deployment of data services solutions which include data integration, data quality, data warehousing, data access, data science, master data management, and data analytics solutions. Applying development best-practices, you will design, build, test and deploy solutions which directly contribute to growth initiatives and operational enhancements. You have a strong customer mindset, great analytical skills, and always focus on delivering quality products. Working proactively with your stakeholders, you will ensure that appropriate level of support is always given and that problems are resolved in a timely manner.

What you’ll need to succeed

Strong prioritization skills.
Able to work effectively on concurrent projects.
Good analytical skills in defining requirements to determine appropriate solution designs considering capabilities, limitations, and design trade-offs.
Ability to communicate technical requirements to non-technical stakeholders and translate functional requirements into technical specifications.
Good understanding of data structures, data modeling, and database schema
Experience coding in various programming languages including Java and C#
Experience coding complex SQL queries
Aptitude to learn new software technologies
Experience working in a team-oriented, collaborative environment
Familiarity with agile project management tools and methods

What you will do

Lead the development of integration solutions for merging existing and new platforms with enterprise systems and applications, while understanding the impact on the broader enterprise.
Be a subject matter expert in designing, coding, testing, and documenting all new or modified data services solutions.
Lead the process and collaborate with Project Managers and Architects to meet the needs of the business.
Conduct research and make recommendations on data services products, trends, and standards.
Make recommendations for areas of continuous improvement of existing solutions.
Lead the evaluation and selection of database / data warehouse components, including hardware, relational database management systems, Extract, Transform, and Load (ETL) software, metadata management tools, database design solutions, and big data technologies.
Develop the semantic layer, metadata, and report definitions for analytics solutions.
Lead in the design of databases and data warehouses to ensure interoperability with data services solutions.
Provide Tier 2 support and ticket resolution including rotational on-call work
Coach and mentor other team members as a subject matter expert in data services solutions.
Work within an Agile team environment, but capable of operating with minimal management supervision.
Follow change management processes for sandbox testing, promotion to production, and operational controls.
Document business requirements, specifications, process flows, application designs, application configuration, testing, and release management.


Travel is not a requirement for this position.

Education and experience

Post-secondary education in computer science, information systems, computer engineering, or equivalent experience.
5+ years of proven experience in business analysis, software development life cycle, and solutions testing.
3+ Experience developing application and data integration solutions using Talend or similar technology
Experience working with master data management solutions an asset
Experience working with big data pipelines, architecture and data sets an asset
Solid experience working with Cognos Analytics

Specific Technologies:
Programming Languages : Java, C#, DOS Batch/Shell Scripting, Python, SOAP, REST, JSON
Operating Systems : Windows Server 2008/2012/2016, Centos 7, Oracle Linux
Databases: Oracle 10g/11g and greater, DB2 v9 or greater, MS SQL Server 2014 and greater
Software : Microsoft IIS, FTP Client (e.g. FileZilla), SSH Client (e.g. PuTTY), Database Client (e.g. TOAD, SQL Developer).
Integration Technologies : Extract-Transform-Load (e.g. Talend Data Integration, Cognos Data Manager, IBM Data Stage, etc.), Enterprise Service Bus (e.g. Talend ESB, IBM WBIMB, MuleSoft, etc.)
Data Analytics Technologies : Required- Cognos Analytics, Planning Analytics, SAS Analytics, SPSS, Tableau, Power BI

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

Bachelors: Information Technology


Saint John, NB