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.
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
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
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
Completion of a diploma in Computer Science, or a relateddiscipline or a combination of education, training, and experience deemedequivalent
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
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