View all jobs

Senior Data Analyst - SAP HANA Oracle

Calgary, AB
Our Energy client has an immediate need for a Senior Data Analyst for a contract role till Aug/22.  The Senior Data Analyst will be part of a large, complex  Integration Data Management project that is accountable for capturing value through decommissioning applications, as well as implementing approved data warehouse architectures for legacy data archives and consolidated application and reporting. 
Responsibilities of the Senior Data Analyst:
  • Lead and participate in process reviews or development and updates to or creation of associated documentation working with stakeholders
  • Participate in standards and process creation, reviews, updates, development and documentation
  • Successfully engage, drive and facilitate multiple initiatives and deliverables simultaneously
  • Work independently with users to define data management concepts or workflows and under direction of project managers
  • Collaborate with project team members including subject matter experts to establish the technical vision and analyze trade-offs between usability and performance needs
  • Collaborate with project team members to progress the project forward as per project plan and scope outline
  • Manage and participate in Transition to Operations scope and activities for services and/or products built by the project team
  • Critically evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests from the underlying true needs
  • 12+ years in a Data Analyst role (or similar)
  • 5+ years’ Oil & Gas experience – Must Have
  • MUST HAVE: strong database skillset in Oracle or S/4 HANA/HANA Studio, along with Data Engineering / ETL
  • Merger experience  - an asset
  • Experience in working with functional SMEs to identify requirements to carve-out Master Data, Reference Data and Transactional Data for migration, archiving and storage
  • General understanding of standard object structures in major ERP systems used for Finance, Asset Management, Supply Chain modules
  • Experience in ensuring adherence with audit and compliance requirements for Data archival
  • Ability to work with SMEs for creating Data validation scripts used post-migration, for ensuring Data integrity
  • Ability to develop Data retrieval and validation routines for periodic use after archival (restore copies from backups and validate)
  • Design Data access processes based on reporting/audit and compliance requirements
  • Experience with working with Data encryption for Data at rest and Data in motion
  • Experience with on-prem and Cloud relational Databases/ design (e.g., SAP HANA, Oracle, Postgres, MSSQL, AWS, Azure) – Must Have
  • Experience data warehousing in SAP HANA
  • Experience in working with native ETL tools for ERP applications
  • Experience in Energy Components, Metrix, EnergyLink, CSLand, Siteview, Wellview application is a plus
  • Ability to define requirements for read-only versions of applications for archived Data access
  • Ability to develop / evaluate Data transformation scripts used for Data conversion/ migration
  • Ability to create requirements documentation, including context diagrams in Visio and as-built support documentation for Data maintenance
This position is located in downtown Calgary with some remote work possible.   If you are interested in this position and have the above-mentioned qualifications, please apply via our website at www.meritasrecruiting.com.
Powered by