WE OFFERLocation: Dallas or Houston Texas or UK location
Solomon, the leading performance improvement company for the global energy industry, is seeking candidates for a Data Analyst position to work in a dynamic, fast-paced business environment. This position will work closely with energy industry experts to design and conduct industry benchmarking studies. While these experts provide in-depth knowledge of the industry, these experts must be leveraged by partnering with a skilled data analyst capable of processing large amounts of benchmarking data through various automation tools. Provide efficient handling and meaningful analysis of large amounts of confidential client data and generate customer reporting. Perform data analysis and results interpretation. Contribute to the improvement of analysis methodologies and participate in the preparation of benchmarking and other studies by contributing to study design and report writing. In addition, assess and apply source information related to operating costs, production efficiency and technical data by analyzing operational performance, identifying performance gaps and improvement opportunities. Assist clients in data preparation, identify client best practices, and provide study results interpretation
Client data mapping and business rules development
Understands, maps and restates client data from raw formats to Solomon categories and characterization. Builds data collection rules to manage data transformation in support of benchmarking studies and data collection engines.
Data cleansing and quality
Reviews client data for missing data, out of range data and contradictory data across accounting, HR, plant/field production. Applies industry knowledge to identify and cleanse bad and inaccurate data. Works with client to clarify and correct the data in a timely fashion.
Initial data analysis for studies
Analyzes the client cleansed data using various data analysis tools (Excel, Tableau, Power BI, etc.) and industry knowledge to create notes for the consultants on the performance of the client’s assets and issues that they faced.
Data analysis for client engagements
Supports client consulting engagements by providing subject matter expertise and data analysis, identifying operational and business issues related to the engagement.
Data Analysis for projects and follow-on work
Creates custom peer groups for Special Data Requests (SDR), creates charts and tables to support projects and follow-up analysis from the benchmarking and consulting engagements
Data analysis for research/white papers
Uses data analysis tools and statistics to review Solomon’s client data from across multiple regions, assets and over time to support research for white papers. Provides appropriate datasets to consultants for deeper details and analysis by SME
- Bachelor of Science or Bachelor of Arts in Computer Science, Mathematics, Engineering, Finance or equivalent
- Engineering or Finance degree or MBA
- 4+ years experience of analysis work
- Familiar with accounting systems and other data systems used in the oil and gas sector
- Analysis work and background in energy or chemicals sector
- Statistical and data modeling
- Experience in cost accounting
- Advanced data and economics analysis
- Experience organizing structuring data for analysis in Tableau, PowerBI, Excel and other analytical tools
- Experienced extracting and transforming data from Oracle, SQL Server, MS Access, or other data systems
- Good understanding accounting, timekeeping, business data tracking
- Excellent writing and verbal skills working with both developers and non-technical personnel
- Proficiency in Microsoft Office products (particularly Excel and PowerPoint)
- Time management
- Detail oriented
- Strong understanding of the business segments supported