Studies Delivery Analyst

HSB Solomon Associates LLC (Solomon), a subsidiary of Hartford Steam Boiler and MunichRe, is seeking candidates for a Studies Delivery Analyst position to work in a dynamic, fast-paced business environment. Solomon is the leading performance improvement company for the global energy industry, serving clients in nearly 80 countries, with global headquarters in Dallas and regional offices in Houston, London, and Manama. Solomon provides data-driven, strategic insight across the energy industry, leading to greater efficiency, reliability, and profitability.

Basic Function 

The Studies Delivery Analyst will provide efficient handling and processing of large amounts of confidential client data and prepare customer reports. This position contributes to the improvement of study processes, study design, methodology implementations, and data management for benchmarking and other studies. This role will also process and provide information related to operating costs, production efficiency, and technical data for custom consulting studies. The Study Data Analyst analyzes operational performance, calculates performance gaps and improvement opportunities, and contributes to study process and methodology improvement initiatives.

Responsibilities 

Study Deliverables Production & Development

• Updates electronic input forms, builds data checking tools for data quality, automates data processing of benchmarking and performance data.

• Builds new calculations into spreadsheets, SQL databases, business intelligence tools, and Business Rule Engines (Decisions, Boomi, etc.).

• Automates production of client presentations and analysis.

• Builds, implements, and supports new Business Intelligence (BI) tools including PowerBI, Tableau, or other tools to be determined.

Study Data Flow & Progression

• Manages client data through complete production cycle including data receipt, data extraction, transformation, and loading (ETL).

• Provides metric calculation, peer group creation, calculation updates, and client deliverables production (data reports and presentation).

• Process Automation Improvements

• Automates and improves data production through SQL, Python, R, Visual Basics for Application (VBA), and other tools.

• Implements new processes in new ETL, BI, and presentation tools.

Quality of Client Deliverables

• Responsible for quality and confidentiality of client deliverables.

• Ensures the correct data is going out to the correct client and the data is presented in a professional manner.

Maintaining Process Documentation

• Maintains documentation on current processes and develops new documentation as we upgrade and improve tools we use.

Resolve Data Flow Issues

• Troubleshoots and fixes data quality issues, ETL issues between systems, and production issues.

• Manages and maintains production queues.

Education

Required:

• Bachelor’s degree in Science/Engineering

Work Experience 

Required:

• Minimum 3 years of experience in data analysis and processing

• Experience extracting and transforming data from Oracle, SQL, Microsoft® Access, or other data systems

• Data processing tools (VBA, Python, Excel, BI Tools, etc.)

      Preferred:

• Industry experience in Energy or Refining/Chemical sector

• Understanding of financial accounting systems

Knowledge & Skills 

Required:

• Excellent interpersonal and communication skills including excellent verbal, written, and listening skills

• Excellent people skills with the ability to successfully collaborate in a global, multi-disciplinary, diverse, matrixed, and dynamic team environment

• Delivery of high-quality work product using Solomon documentation standards as appropriate

• Effectively and efficiently navigate workflows and processes to accomplish work and recommend improvements

• Proven track record of continuous improvement and creating new and better ways for the organization to be successful

• Data Analytics Tools—Proficiency with data analytics and tools such as Python, Excel, VBA, BI tools, etc.

• Detail Oriented—Reviews work quality and anomalies in results

• Workload Planning—Demonstrates ability to self-manage, set schedules, and prioritize work appropriately

• Industry Knowledge—Strong understanding of the oil, gas, energy industry segment supported with a general understanding of accounting, timekeeping, and business data tracking

• Strong analytical and problem-solving skills with the ability to break down complex problems, derive insights from data, and provide actionable recommendations

• Effectively and efficiently navigate workflows and processes to accomplish work

• Strong independent work ethic while also making a positive contribution to an existing, highly collaborative work environment

• Ability to make sound and timely decisions that considers all relevant factors, criteria, risks, and implications

• Interpersonal Skills—Demonstrated ability to develop and grow strong work relationships

• Microsoft Office Products—Proficient in Microsoft Office products such as Word, Excel®, and PowerPoint®

All applicants, including applicants holding a valid CPT/OPT visa, who will require employer sponsorship of a visa now or in the future will not be considered for this position.

At HSB Solomon Associates LLC, a subsidiary of The Hartford Steam Boiler and of Munich Re, we see Diversity and Inclusion as a solution to the challenges and opportunities all around us. Our goal is to foster an inclusive culture and build a workforce that reflects the customers we serve and the communities in which we live and work. We strive to provide a workplace where all of our colleagues feel respected, valued and empowered to achieve their very best every day. We recruit and develop talent with a focus on providing our customers the most innovative products and services.

We are an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. The work environment characteristics, and any physical and mental requirements described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

This job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee. Other duties, responsibilities, and activities may change or be assigned at any time with or without notice.