The push for digital transformation in the energy sector has made automation expertise more valuable than ever. Companies are hunting Business Analysts who can bridge the gap between process insight and tech‑driven solutions. This contract role in New York offers a fast‑paced environment to showcase your VBA, Power Automate, and C# skills while shaping critical commodity operations.

Job Summary

We are seeking a hands‑on Business Analyst to own the end‑to‑end automation lifecycle for commodity operations. You will translate business needs into technical designs, build solutions using Excel VBA, Power Automate, and C#, and ensure smooth deployment through testing and stakeholder collaboration.

Top 3 Critical Skills Table

Skill	Why it's critical	Mastery Level
Excel VBA	Automates repetitive data tasks and integrates with existing spreadsheets	Senior
Power Automate (RPA)	Enables low‑code workflow automation across systems	Mid
C# Development	Provides custom logic and integration capabilities beyond low‑code tools	Mid

Interview Preparation

Describe a complete automation project you delivered from requirements gathering to deployment.
What the interviewer is looking for: Ability to manage full lifecycle, stakeholder communication, and measurable impact.
How do you decide when to use Power Automate versus a custom C# solution?
What the interviewer is looking for: Understanding of tool strengths, scalability, and maintenance considerations.
Walk me through how you design a data mapping document for a new workflow.
What the interviewer is looking for: Attention to detail, documentation standards, and data integrity awareness.
Explain a challenging functional testing scenario you encountered and how you resolved it.
What the interviewer is looking for: Problem‑solving skills, testing methodology, and UAT support experience.
What techniques do you use for web scraping and how do you handle anti‑scraping measures?
What the interviewer is looking for: Practical knowledge of data extraction, legal/ethical considerations, and robustness.

Resume Optimization

Business Analysis
Process Automation
Excel VBA
Power Automate
C# Development
Web Scraping
Data Extraction
Functional Testing
User Acceptance Testing (UAT)
Stakeholder Management

Application Strategy

When reaching out to the recruiter, send a concise email greeting, attach your updated resume, and explicitly highlight your top automation skills. Mention projects where you used Excel VBA, Power Automate, and C# to streamline processes, and align those achievements with the responsibilities listed in the job description.

Career Roadmap

Current Role	Typical Experience	Core Focus	Next Position
Business Analyst – Automation & Process Optimization	3‑4 years in automation‑focused BA roles	End‑to‑end workflow automation, stakeholder delivery	Senior Business Analyst – Automation (5‑7 years)
Senior Business Analyst – Automation	5‑7 years, leading multiple automation initiatives	Strategic automation planning, cross‑team leadership	Automation Lead / Process Optimization Manager (8‑10 years)
Automation Lead / Process Optimization Manager	8‑10 years, managing teams and large‑scale projects	Portfolio governance, technology roadmap	Director of Process Automation (10+ years)

Business Analyst – Automation & Process Optimization