Reporting Analyst

The Role

What is the role

Reporting Analyst works within the Contracts and Confirmations team performing a key role in the daily monitoring and resolution of issues for trades interfacing from Shell’s Energy Trading Risk Management (ETRM) systems into ICE eConfirm as required by Dodd Frank Regulatory requirements. This will include performing daily reconciliation, root cause analysis and ensuring all trades are interfaced accurately and within specified timeframes. In addition to the above responsibilities, the Reporting Analyst generates daily reconciliation/ad-hoc reports and KPI’s, working closely with the Confirmations Team, to ensure all trades are confirmed and compliant under existing Sox Controls.

  • Liaise with Commercial, Risk Control, Compliance, IT and other functional groups and external parties to resolve issues and/or discrepancies
  • Understand regulatory reporting infrastructure in ETRMs and ICE across multiple markets
  • Remain informed about internal system changes and understand the subsequent impacts on ICE econfirm
  • Participate in efforts to maintain working interface with ETRM's and ICE eConfirm.
  • Perform ad-hoc data reconciliations
  • Monitor trade submission error logs, performing root cause analysis when necessary to ensure that trades are interfaced within specified timeframes
  • Navigate through multiple systems to identify and understand trade discrepancies
  • Prepare data to facilitate the execution of critical business activities
  • Develop and produce KPI’s and tracking reports
  • Working in eConfirm to resolve issues and discrepancies.
  • Ensure process and technical design documentation are monitored and up to date.

Special Challenges

The individual will need to be able to work in a fast-paced open environment, demonstrate proficiency in consistently following instructions, show ability to discover pattern breaks and other indicators of possible process errors, meet tight deadlines, handle a variety of ad hoc requests, identify opportunities for process improvements and efficiencies and have a high ability to troubleshoot. The individual will need to be able to work extended hours if unforeseen process overruns occur. Strong problem-solving and communication skills will be needed to facilitate solutions in such after-hours situations.

What we need from you

  • Must have legal authorization to work in the US on a full-time basis for anyone other than current employer.
  • Candidates should possess a Bachelor’s degree in Finance, Information Technology or related fields.
  • 3 or more years of relevant work experience.
  • Prior experience in an energy trading environment, financial commodities, audit or financial accounting in the energy industry would be an asset.
  • The qualified candidate must have advanced Excel, (Macros, formulas, VBA) and SQL skills.
  • Exposure to Spotfire, Power BI, Python and Azure a plus.
  • Breadth and depth of knowledge in IT systems structure.
  • Ability to work with and analyze large data sets to identify patterns but with the ability to understand the data and communicate insights and findings.
  • Strong technical, numeracy, analytical, problem solving and troubleshooting skills to recognize and solve problems quickly.
  • Championing system and process improvements with an aim towards elimination of manual data capture, improving reconciliation capabilities and continuing down the path of straight through processing.
  • Excellent customer service and interpersonal skills, a professional attitude, a high degree of accuracy, task oriented, meticulous and work well within a team environment where effective communication and team collaboration is the norm.
  • Strong communication skills, both written and verbal.
  • Ability to deliver on the responsibilities and think critically in the midst of ambiguity and uncertainty.
  • Capacity to adjust priorities and re-allocate time based on changing requirements and requests
  • Familiarity with natural gas and electricity financial markets or trading organization is preferred.
  • Understanding of energy trading concepts.
  • Commodity Trading system knowledge. (Open Link Endur & Nucleus preferred)
  • Experience working with ICE’s eConfirm and Trade Vault platforms preferred.
  • Familiarity with Dodd-Frank Act and Sox Controls preferred.

Company description

Shell is a global group of energy and petrochemical companies with about 84,000 employees across more than 70 countries. We aim to meet the world’s growing need for more and cleaner energy solutions in ways that are economically, environmentally, and socially responsible.  We have expertise in exploration, production, refining and marketing of oil and natural gas, and the manufacturing and marketing of chemicals.

As a global energy company operating in a challenging world, we set high standards of performance and ethical behaviors. We are judged by how we act and how we live up to our core values of honesty, integrity, and respect for people. Our Business Principles are based on these. They promote trust, openness, teamwork, and professionalism, as well as pride in what we do and how we conduct business.

Building on our core values, we aspire to sustain a diverse and inclusive culture where everyone feels respected and valued, from our employees to our customers and partners. A diverse workforce and an inclusive work environment are vital to our success, leading to greater innovation and better energy solutions.

An innovative place to work

There’s never been a more exciting time to work at Shell. Everyone here is helping solve one of the biggest challenges facing the world today: bringing the benefits of energy to everyone on the planet, whilst managing the risks of climate change.

Join us and you’ll add your talent and imagination to a business with the power to shape the future – whether by investing in renewables, exploring new ways to store energy, or developing technology that helps the world to use energy more efficiently.

An inclusive place to work

To power progress together, we need to attract and develop the brightest minds and make sure every voice is heard. Here are just some of the ways we’re nurturing an inclusive environment – one where you can express your ideas, extend your skills, and reach your potential.

  • We’re creating a space where people with disabilities can excel through transparent recruitment process, workplace adjustments and ongoing support in their roles. Feel free to let us know about your circumstances when you apply, and we’ll take it from there.
  • We’re closing the gender gap – whether that’s through action on equal pay or by enabling more women to reach senior roles in engineering and technology.
  • We’re striving to be a pioneer of an inclusive and diverse workplace, promoting equality for employees regardless of sexual orientation or gender identity.
  • We consider ourselves a flexible employer and want to support you finding the right balance. We encourage you to discuss this with us in your application.

A rewarding place to work

Combine our creative, collaborative environment and global operations with an impressive range of benefits and joining Shell becomes an inspired career choice.

We’re huge advocates for career development. We’ll encourage you to try new roles and experience new settings. By pushing people to reach their potential, we frequently help them find skills they never knew they had, or make career moves they never thought possible.

Please note: We occasionally amend or withdraw Shell jobs and reserve the right to do so at any time, including prior to the advertised closing date. Before applying, you are advised to read our data protection policy. This policy describes the processing that may be associated with your personal data and informs you that your personal data may be transferred to Shell/Shell Group companies around the world. The Shell Group and its approved recruitment consultants will never ask you for a fee to process or consider your application for a career with Shell. Anyone who demands such a fee is not an authorised Shell representative and you are strongly advised to refuse any such demand. Shell participates in E-Verify. All qualified applicants will receive consideration for employment without regard to race, color, sex, national origin, age, religion, disability, sexual orientation, gender identity, protected veteran status, citizenship, genetic information or other protected status under federal, state or local laws. Shell is an Equal Opportunity Employer - Minorities/Females/Veterans/Disability. As a US Federal Contractor, hiring selections are subject to periodic audit review and documentation of your selections should be maintained for a period of three calendar years. It is the policy of Shell in the U.S. (“Shell”) to provide equal opportunity to all individuals, employees and all qualified applicants for employment consistent with employment requirements and qualifications. Shell prohibits discrimination based on race, color, sex, national origin, age, religion, disability, sexual orientation, gender identity, veteran status, citizenship, genetic information, or other protected status under federal, state or local laws. All employees are expected to support this policy and contribute to an environment of equal opportunity. If you need an accommodation for a disability during the resourcing process, please speak with an HR representative.