Ensure extract, transform and loading jobs are run as scheduled
Maintain issues log and compile delta reporting for ETL gaps and discrepancies to EPCs, IM Leads, Discipline or Business Leads.
Run extracts from AVEVA for additional KPI/reporting requirements not addressed in AVEVA AIM
Prepare data extracts from EPCs, EDTs, and other systems to support and automate consistent loading of other tools or applications such as SAP, HSC, etc.
Provide oversight of handover of latest drawings and comparing with dataset delivered by projects and MOCS
Recommend solutions for AVEVA AIM integrations with other Projects, Ops or Maintenance software/systems
Providing “Tier 1” support and troubleshooting for AVEVA AIM including PowerBI reporting and will escalate to IT team or AVEVA AIM Product Owners/Consultants as needed.
Author AVEVA AIM training content for new and 'Power' users and maintain the content within the SharePoint site dedicated to specified workflow.
Provide KPIs and generate QA reports for Asset or project documents and data in AVEVA AIM
Maintain, prioritize and respond to user feedback, change requests and enhancements.
Provide feedback on usability, features, performance, etc. to different business processes within the Company.
Propose improvements to AIM Steer Co to improve navigation, searching, accessing asset information.
Work Experience
Experience of Engineering business processes, and risks/opportunities across the engineering life-cycle.
Familiarity with IM data and document management work processes in projects and operations.
Understanding of industry standards and practices,
Knowledge of Aconex, EDT and AVEVA AIM Load processes and tools (Gateways)
Experience in Oil & Gas
Min 4-5 years experience with Data control, Engineering Data Warehouse on Asset.
Experience in data analytics.
Understanding of database/data structures and methodologies.
Working experience with IM tools to support ETL (e.g.. SQL, C+, APIs)
Proficient in metrics reporting (e..g.PowerBI)
Familiar with cross discipline engineering data terminology and requirements.
ability to plan, implement, test, document and troubleshoot system integrations or upgrades.