- Oracle DWH, PL/SQL, DBA
- Provide off-hours support,Act as business analyst on various projects
Sobre nuestro cliente
With over 200 brands sold in 180 countries, the companya is a global leader in premium drinks, across spirits and beer, a business built on the principles and foundations laid by the giants of the industry.
Descripción
- Design, build and maintain North American Oracle Data Warehouse
- Develop shell scripts and PL/SQL routines for major projects in North America
- Improve data consistency by moving more downstream systems to consistent data sources.
- Act as business analyst on various projects, write technical specifications and code.
- Heavy focus on NAM 3rd party data (VIP, NABCA, TDLINX, ACD, BRI) sets as well as SAP.
- Coordinate and support less experienced Data Engineers through development cycles and ensure standard methodologies are shared
- Seek out and provide the business with the most efficient and effective solutions for finding business critical information
- Work with infrastructure teams on server sizing, patching, issue resolution, security, etc.
- Work with DBA teams on any future improvements, upgrades and issues.
- Serve as SME for projects which include North American Data (i.e., CPD, Voyager, etc.)
- Provide analysis and development expertise as required by larger products such as Voyager and CPD.
- Lead data acquisition tasks such as those related to brand acquisitions (Loyal 9, Lone River, Davos, Mr. Black, etc.).
- Lead, design, develop and maintain data integration projects with downstream systems.
- Provide off-hours support
- Monitor batch processing to ensure that SLAs as met.
- Tune processes to ensure processing efficiency.
- Serve as main contact for external vendors (e.g., VIP, NABCA, Nielsen, etc.).
- Work directly with external vendors on strategic direction and issues.
- Serve as main contact for Anaplan COE with North American Data Warehouse projects/issues.
- Serve as main contact for the business on issues and future requirements with respect to the North American Data Warehouse.
Perfil buscado
- Bachelor's degree in Business, Information Technology, or related field
- Minimum 5 years' experience in the following areas:
o Core Programming Languages:
§ Oracle PL/SQL
§ Linux shell scripting
o Core Applications & Skills:
o Oracle
o SAP BODS
- Data Modeling - Kimball
- SAP
- Azure environment
Qué Ofrecemos
Competitive Salary and benefits above the law