Commercial Operator SQL/VBA Automation Houston TX

Profile

136441BR

Job Title:

Commercial Operator (SQL/VBA Automation) – Houston, TX

No. of Positions:

1

Job Description:

What’s the role?

The Natural Gas Commercial Operator is part of the Commercial North America Gas Operations Team responsible for the day-to-day operational management of Shell Energy Americas (SEAm) gas activities in the South markets while also maintaining the dashboards and reporting across the South desk through SQL and VBA automation. This person will also provide scheduling and operations support to various business desks across North America.

The primary purpose is to carryout daily natural gas scheduling and operational duties for SEAm which includes but is not limited to the following accountabilities:

Build and Maintain Monthly dashboard for Operations using the knowledge of SQL, SQL Server, SSIS and Spotfire.

Update Monthly, Quarterly leadership presentation decks with highlights, metrics for post deal execution to cash activities.

Create queries to pull data from Endur for adhoc data needs of Operations leadership; Maintain existing Spotfire reports for Operations metrics.

Coordinate the daily product movement for SEAm and agency customers including equity gas production, purchases, sales, transportation, storage on both interstate and intrastate pipelines via electronic bulletin boards while ensuring contract obligations and regulatory requirements are met.

Report physical pipeline positions to SEAm trading groups.

Schedule accurate nominations meeting all deadlines throughout the day.

Optimization of transport and delivery requirements to monetize value for the trade desk through accurate timely nominations (1-shot noms), segmentation and meter bounces.

Monitor and report pipeline operational information providing short term opportunities to trading due to pipeline constraints and operations.

Schedule energy retailer customers from various upstream and downstream receipt and delivery meters.

Strict compliance with FERC Shipper Must Hold Title, Dodd Frank Bookout requirements and understanding of the buy/sell capacity release rules.

Maintains a thorough understanding of all contractual, license and regulatory requirements.

Know and understand of the various balancing mechanisms in use across North America regarding imbalance tolerances and the financial cash out risks for shippers and traders.

Understand how a pipeline calculates and uses cash out indices.

Knowledge in a pipeline’s tariff general terms and conditions.

Input operational information daily into SEAm internal gas management system (Endur) for accurate P&L and a clean hand off at month end.

Highly proficient in the knowledge and use of SEAm internal gas management system to troubleshoot issues from deal entry to invoicing.

Foster and maintain strong working relationships with teammates.

Build and maintain trusted partnerships with both internal and external stakeholders.

Train and Provide back up support to other schedulers within own team and across NA teams.

Perform monthly close activities on top 10 pipelines to ensure timely and accurate reporting.

Work with limited supervision to troubleshoot, resolve problems.

Focal Point for elevated issue resolution in absence of supervisor.

Auto req ID:

136441BR

Skillpool:

Trading Operations

Country of Work Location:

United States

Employment Type:

Full Time

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.

Disclaimer:

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 Royal Dutch/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.

Work Location:

Houston - One Thousand Main

Requirements:

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.

Bachelor’s degree required.

Minimum 3 years of experience in coding SQL and VBA is a must.

Natural gas scheduling experience desired

Commercial mindset and ability to work effectively with trade desk in operational decisions.

Proven track record of performance and delivery.

Self-starter and ability to effectively multi-task.

Ability to work under pressure, prioritize, and meet strict time sensitive deadlines.

Very strong attention to detail.

Effective communicator, with highly developed interpersonal skills.

Strong Team Player.

Ability to adapt quickly to changing internal and external requirements.

City, State (if applicable):

Houston, TX

Company info

Shell .
Website : https://www.shell.com