Data Warehouse Engineer - Contract
CPG Connect
Mississauga, ON
17d ago

Arterra Wines Canada is Canada’s leading producer and marketerof wine and wine related products, with operations in British Columbia, Ontarioand Quebec.

The company’s portfolio includes great brands like Jackson Triggs,Inniskillin, Ruffino, Robert Mondavi and Meomi.We offer a wide range of exciting career opportunities in sales,marketing, operations, production, finance and administration.

As a part of theArterra team, employees are encouraged to improve their skills and performancethroughout their careers through various professional and educational developmentprograms.

Arterra provides a robust onboarding program in addition to ongoingtraining initiatives to help employees integrate into the organization quicklyand maximize their growth potential.


The Data Warehouse Engineer is responsible for supportingdata integrations between our transactional applications as well as with our BIplatform and EDW.

This individual isexpected to perform L2 and L3 support tasks, to create and maintain integrationdesign documents, perform development and testing tasks, as well as demonstratean above average knowledge of standard RDBMS technologies, and familiarity withnewer NoSQL, distributed and cloud-

based database solutions. The Data Warehouse Engineer is a member of across-functional BI / Analytics team comprised of analytical and technical teammembers.

Functional &Technical

  • Triage, investigate, and resolve support tickets related toapplications and BI integrations
  • Administration of the ODI environment (topology, security,models)
  • Develop efficient, supportable ETL flows in support ofbusiness projects
  • Tune and optimize ODI and Data Warehouse to support businessusers and BI Applications
  • Implement necessary processes and tools to ensure processmaturity and best practices are followed
  • Lead design discussions and decisions as it relates tobusiness intelligence and database solutions and drive decisions through tocompletion
  • Develop and maintain logical and physical data models
  • Create data integration processes to coalesce disparate datasets into a cohesive data model in support of BI and analytical requirements
  • Design and develop scalable solutions targeted for broaddeployment across a division or the entire enterprise.
  • Create rapid prototypes with cross-functional team membersto prove out capabilities
  • Work closely with the business and technical teams tounderstand, document, design and code development objects
  • Custr &Stakeholder

  • Liases with cross-functional IT team members throughout theresolution of support tickets
  • Liaises with Project Manager / Solution manager (internal orexternal) throughout the solution development lifecycle.
  • Provide support for end user training and UAT when required
  • Strong customer focus
  • Effective and clear communication skills with customers
  • OperationalExcellence

  • Ensure deliverables are within business / audit controlrequirements
  • Take ownership of a problem and stay with it through toresolution, including all necessary coordination with other teams
  • Coordinate the work of other run support resources andensure timeliness and quality
  • Adheres to, and continues to evolve, appropriate technicaldevelopment standards
  • Participates in tier 3 application support activitiesincluding incident management and supports the assessment and delivery ofapplication upgrades and patches
  • Ability to work on multiple projects concurrently withshifting priorities
  • Education

  • Completion of a diploma in Computer Science, or a relateddiscipline or a combination of education, training, and experience deemedequivalent
  • Experience

  • Minimum 5 years of related work experience with a backgroundin RDBMS or Big Data technologies, such as Azure SQL or adoop (Oracle stronglypreferred)
  • Minimum 5 years of experience in ETL technologies andlanguages, such as Oracle Data Integrator or Informatica
  • Minimum 5 years working on BI / DW Projects
  • ETL architecture design experience within data warehousingenvironments governed by applying appropriate methodologies and ETL standardsis desired
  • Experience creating integration and data warehouse technicalspecifications is required
  • Conceptual, logical and physical data modeling through useof data modeling tools is a plus
  • Experience working with JD Edwards data structures isstrongly desired
  • Experience in the beverage alcohol or consumer packagedgoods industry helpful
  • Experience with traditional BI platforms, such as Power BI,Spotfire, or Microstrategy, is an asset
  • Certifications &Designations

  • ITIL Foundations, an asset
  • Current project management certification from a recognizedinstitute (e.g. Project Management Professional (PMP) or PRINCE2), an asset
  • Leadership,Competencies, & Specialized Skills


  • Knowledge and experience building solutions with top tier orbig data and technologies, such as Oracle, Azure SQL, Hadoop
  • Proficiency in core Microsoft Office applications
  • Knowledge of the principles and practices of systemsdevelopment and the systems development life cycle (SDLC) process, with theability to promote a coherent corporate approach to enterprise applicationdelivery using a multi-tiered architecture
  • Knowledge of operating systems, middleware, and othertechnologies for building and maintaining multi-tiered enterprise businesssolutions
  • Experience with working at the senior level and withdiverse, distributed teams
  • Experience with multiple, industry standard, structured, andagile methodologies
  • Leadership, problem solving, interpersonal, andoral / written / presentation skills to lead the analysis, design, and developmentof enterprise business solutions across multiple platforms
  • Ability to work with key staff in remote locations usingcollaboration technology (IM, Live Meeting) is require
  • Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Application form