Studies Delivery Analyst, UpstreamCompanyHSB SolomonLocationDallas , United StatesHSB 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 FUNCTIONThe 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.RESPONSIBILITIESStudy Deliverables Production & DevelopmentUpdates 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 & ProgressionManages 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 ImprovementsAutomates 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 DeliverablesResponsible 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 DocumentationMaintains documentation on current processes and develops new documentation as we upgrade and improve tools we use.Resolve Data Flow IssuesTroubleshoots and fixes data quality issues, ETL issues between systems, and production issues.Manages and maintains production queues.EDUCATIONRequired:Bachelor’s degree in Science/EngineeringWORK EXPERIENCERequired:Minimum 3 years of experience in data analysis and processingExperience extracting and transforming data from Oracle, SQL, Microsoft® Access, or other data systemsData processing tools (VBA, Python, Excel, BI Tools, etc.)Preferred:Industry experience in Energy or Upstream/Chemical sectorUnderstanding of financial accounting systemsKNOWLEDGE & SKILLSRequired:Excellent interpersonal and communication skills including excellent verbal, written, and listening skillsExcellent people skills with the ability to successfully collaborate in a global, multi-disciplinary, diverse, matrixed, and dynamic team environmentDelivery of high-quality work product using Solomon documentation standards as appropriateEffectively and efficiently navigate workflows and processes to accomplish work and recommend improvementsProven track record of continuous improvement and creating new and better ways for the organization to be successfulData Analytics Tools—Proficiency with data analytics and tools such as Python, Excel, VBA, BI tools, etc.Detail Oriented—Reviews work quality and anomalies in resultsWorkload Planning—Demonstrates ability to self-manage, set schedules, and prioritize work appropriatelyIndustry Knowledge—Strong understanding of the oil, gas, energy industry segment supported with a general understanding of accounting, timekeeping, and business data trackingStrong analytical and problem-solving skills with the ability to break down complex problems, derive insights from data, and provide actionable recommendationsEffectively and efficiently navigate workflows and processes to accomplish workStrong independent work ethic while also making a positive contribution to an existing, highly collaborative work environmentAbility to make sound and timely decisions that considers all relevant factors, criteria, risks, and implicationsInterpersonal Skills—Demonstrated ability to develop and grow strong work relationshipsMicrosoft Office Products—Proficient in Microsoft Office products such as Word, Excel®, and PowerPoint®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.