Senior Business Analyst — Data Migration & Analytics (Oil & Gas)

About the Program

You will join the Solutioning Core of a flagship engagement: an enterprise-wide data migration to Databricks on Azure for a leading North American upstream oil & gas operator

The Role

As the Senior Business Analyst in the Solutioning Core, you are the requirements backbone of the program. You will elicit, structure and manage business requirements from asset and corporate teams across two basins, convert them into user stories, acceptance criteria and solution prompts that digital and data teams execute from, and maintain end-to-end traceability from intake through migrated, validated, adopted data. You are the answer to “what did the business mean?” — before an engineer has to ask. You will work shoulder-to-shoulder with a Databricks Solution Architect and the upstream Industry SME, who leads the Solutioning Core as our on-site team lead, as one unit with a shared backlog.

Key Responsibilities

• Plan and facilitate structured requirements workshops per data domain (production, drilling & completions, land, finance, reserves/planning) with business owners and SMEs
• Translate business needs into clear user stories, functional specifications, data requirements and acceptance criteria consumable by data engineers and platform teams — including well-formed solution prompts for GenAI-assisted development tooling
• Own and groom the single program requirements backlog; enforce traceability from requirement to pipeline to validated dataset to UAT sign-off
• Run two-way clarification: resolve ambiguity for engineers in hours, and replay technical constraints back to the business in plain language
• Design UAT scenarios with business owners per migration wave; coordinate execution, defect triage and sign-off
• Produce requirement-health reporting (coverage, churn, blocked items, decisions needed) for the joint program board
• Support the Industry SME and Solution Architect in wave planning by quantifying requirement volume and readiness per domain
• Champion documentation standards so requirements remain a durable asset for the client after each wave

Required Qualifications & Experience

• 5+ years as a Business Analyst on data platform, data migration, EDW/BI or large ERP-adjacent programs
• Demonstrated experience writing requirements for data products: source-to-target mappings, data quality rules, reconciliation criteria, semantic/reporting definitions
• Hands-on familiarity with modern data stacks ideally Databricks (Unity Catalog, Delta Lake concepts), Azure data services and Power BI: sufficient to write implementable stories
• Strong workshop facilitation and stakeholder management from manager through VP level; excellent written English
• Experience with agile delivery and backlog tooling (Azure DevOps or Jira) including traceability practices
• Energy industry exposure — upstream oil & gas strongly preferred; demonstrated ability to rapidly learn upstream data concepts is mandatory

Preferred / Differentiating Qualifications

• Direct upstream O&G experience with sub-surface, land management, D&C systems (production allocation platforms, land/DOI systems, WellView-class applications)
• Experience on a lakehouse or EDW to cloud migration specifically; exposure to GenAI-assisted requirements or code-conversion workflows
• Consulting experience representing a services firm on a client site; experience working with nearshore/offshore delivery teams

Education & Certifications

• Bachelor’s degree in Business, Engineering, Computer Science, MIS or related field (or equivalent experience)
• CBAP, CCBA, PMI-PBA, Agile BA or equivalent certification preferred; SAFe or scaled-agile experience a plus
• Databricks Fundamentals or Azure data certifications (DP-900/DP-203) are a differentiator