Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Support wells data management by scripting, running queries, and maintaining dashboards.
- Company: Join a leading company in the upstream drilling and well construction industry.
- Benefits: Enjoy a flexible work environment with 60% office time and opportunities for growth.
- Why this job: Be part of a dynamic team that values innovation and technical expertise in data management.
- Qualifications: 5+ years experience with EDM, SQL scripting, and data management in drilling.
- Other info: Ideal for tech-savvy individuals eager to engage in theoretical discussions and drive integration.
The predicted salary is between 48000 - 72000 £ per year.
Location (Including Home Working Ratio): London/Aberdeen/Houston 60% Office
Travel Requirements: None
Duration: 12 months +
Summary:
- We are seeking a specialist with a deep understanding of the Landmarks EDM database to support our client’s wells data management activities.
- The role will have responsibility for scripting and running queries, bulk data uploads and building and maintaining PowerBI / Spotfire data quality dashboards.
- The candidate must have an in-depth, first-hand knowledge of the EDM, Compass, and OpenWells data structures and how data is entered on the front end and stored on the back end within Oracle.
- Expertise in creating and executing SQL scripts to access the EDM database is essential for this role.
Responsibilities:
- Build or modify existing SQL scripts to query and extract data from the EDM database. The scripts will be executed in DataAnalyzer to extract EDM and OpenWells data for use and analysis in other systems.
- Maintain and extend PowerBI data quality dashboard that measures, visualizes, and tracks EDM and OpenWells data quality.
- Undertake bulk imports and exports of EDM, Compass, and OpenWells data sets as required.
- Generate periodic EDM data quality reports indicating data quality across the regions.
- Maintain and update the definitive EDM data field mappings list for all required data sets.
- Document the processes, tools, and workflows in EDM data management.
- Advise on opportunities to integrate EDM (read and write) with other systems, both third-party and BP.
- Advise on the relationship between EDM and DWP and data management implications.
Requirements:
- A data management specialist with at least 5 years experience with Landmarks EDM, EDT, Compass, and OpenWells databases.
- Thorough understanding and experience in developing and running SQL scripts on the EDM Oracle database.
- Expert-level knowledge of Landmarks DataAnalyser and Landmark DSIS is an advantage.
- Demonstrable experience in data management within the upstream drilling and well construction industry.
- A good understanding of drilling and well construction workflows.
- Comfortable acting as a technical advisor and able to engage with colleagues and instigate theoretical discussions about what may be possible for other teams to plan for their own products.
Desirable Skills:
- Knowledge of data integration and analytics tools is an advantage.
- Knowledge of agile working practices (required) and product management (advantage).
Apply Now
#J-18808-Ljbffr
EDM - Specialist employer: E&P Consulting
Contact Detail:
E&P Consulting Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land EDM - Specialist
✨Tip Number 1
Make sure to familiarize yourself with the Landmarks EDM database and its data structures. Understanding how data is entered and stored will give you a significant edge during discussions and interviews.
✨Tip Number 2
Brush up on your SQL skills, especially in creating and executing scripts for the EDM Oracle database. Being able to demonstrate your technical expertise in this area can set you apart from other candidates.
✨Tip Number 3
Gain hands-on experience with PowerBI and Spotfire, as these tools are crucial for building and maintaining data quality dashboards. Having practical knowledge will help you discuss your capabilities confidently.
✨Tip Number 4
Network with professionals in the upstream drilling and well construction industry. Engaging in conversations about data management workflows can provide insights and potentially lead to referrals for the position.
We think you need these skills to ace EDM - Specialist
Some tips for your application 🫡
Understand the Role: Make sure you thoroughly understand the responsibilities and requirements of the EDM Specialist position. Familiarize yourself with the Landmarks EDM database, SQL scripting, and data management practices relevant to the role.
Tailor Your CV: Highlight your experience with EDM, Compass, and OpenWells databases in your CV. Emphasize your SQL scripting skills and any relevant projects that demonstrate your expertise in data management within the upstream drilling and well construction industry.
Craft a Strong Cover Letter: Write a cover letter that showcases your passion for data management and your understanding of the specific tools and processes mentioned in the job description. Mention how your background aligns with the company's needs and how you can contribute to their data quality initiatives.
Proofread Your Application: Before submitting your application, carefully proofread all documents for spelling and grammatical errors. Ensure that your application is clear, concise, and free of mistakes to make a strong impression.
How to prepare for a job interview at E&P Consulting
✨Showcase Your SQL Expertise
Be prepared to discuss your experience with SQL scripts in detail. Highlight specific examples of how you've built or modified scripts to extract data from databases, particularly the EDM database.
✨Demonstrate Your Knowledge of Data Structures
Make sure to articulate your understanding of the EDM, Compass, and OpenWells data structures. Discuss how data is entered and stored, and be ready to explain any relevant workflows you have managed.
✨Discuss Your Experience with Data Quality Dashboards
Talk about your experience maintaining and extending PowerBI or Spotfire dashboards. Provide examples of how you've tracked and visualized data quality, and any reports you've generated.
✨Engage in Technical Discussions
Prepare to engage in theoretical discussions about data management and integration opportunities. Show that you can think critically about how EDM can interact with other systems and contribute to broader data management strategies.
