Business Analyst – Automation & Process Optimization
Not Disclosed
Location: New York, NY
Job Type: Contract
Salary: $40–45/Hr (C2C)
Duration: Not Specified
Experience: 3-4 years, automation BA
Job Description & Details
"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\u2011driven solutions. This contract role in New York offers a fast\u2011paced environment to showcase your VBA, Power Automate, and C# skills while shaping critical commodity operations.\n\n# Job Summary\nWe are seeking a hands\u2011on Business Analyst to own the end\u2011to\u2011end 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.\n\n# Top 3 Critical Skills Table\n| Skill | Why it's critical | Mastery Level |\n|-------|-------------------|--------------|\n| Excel VBA | Automates repetitive data tasks and integrates with existing spreadsheets | Senior |\n| Power Automate (RPA) | Enables low\u2011code workflow automation across systems | Mid |\n| C# Development | Provides custom logic and integration capabilities beyond low\u2011code tools | Mid |\n\n# Interview Preparation\n1. **Describe a complete automation project you delivered from requirements gathering to deployment.**\n *What the interviewer is looking for:* Ability to manage full lifecycle, stakeholder communication, and measurable impact.\n2. **How do you decide when to use Power Automate versus a custom C# solution?**\n *What the interviewer is looking for:* Understanding of tool strengths, scalability, and maintenance considerations.\n3. **Walk me through how you design a data mapping document for a new workflow.**\n *What the interviewer is looking for:* Attention to detail, documentation standards, and data integrity awareness.\n4. **Explain a challenging functional testing scenario you encountered and how you resolved it.**\n *What the interviewer is looking for:* Problem\u2011solving skills, testing methodology, and UAT support experience.\n5. **What techniques do you use for web scraping and how do you handle anti\u2011scraping measures?**\n *What the interviewer is looking for:* Practical knowledge of data extraction, legal/ethical considerations, and robustness.\n\n# Resume Optimization\n- Business Analysis\n- Process Automation\n- Excel VBA\n- Power Automate\n- C# Development\n- Web Scraping\n- Data Extraction\n- Functional Testing\n- User Acceptance Testing (UAT)\n- Stakeholder Management\n\n# Application Strategy\nWhen 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.\n\n# Career Roadmap\n| Current Role | Typical Experience | Core Focus | Next Position |\n|--------------|-------------------|-----------|---------------|\n| Business Analyst \u2013 Automation & Process Optimization | 3\u20114 years in automation\u2011focused BA roles | End\u2011to\u2011end workflow automation, stakeholder delivery | Senior Business Analyst \u2013 Automation (5\u20117 years) |\n| Senior Business Analyst \u2013 Automation | 5\u20117 years, leading multiple automation initiatives | Strategic automation planning, cross\u2011team leadership | Automation Lead / Process Optimization Manager (8\u201110 years) |\n| Automation Lead / Process Optimization Manager | 8\u201110 years, managing teams and large\u2011scale projects | Portfolio governance, technology roadmap | Director of Process Automation (10+ years) |"