Skip to content
mimi

Business Data Scientist II/III/Sr

100 Williams WPC-I, LLC.

Pittsburgh · Hybrid Full-time Mid Level 2w ago

About the role

Equal Opportunity Statement

Williams is committed to creating a diverse and inclusive environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity and expression, national origin, age, marital status, disability, veteran status, genetic information or any other basis protected under applicable discrimination law.

About the Role

Do something that means something at Williams. This isn’t just a job – it’s an opportunity to explore and discover your passion with coworkers who become friends and mentors who push you to be your best self in and out of the office. At Williams, we make clean energy happen. And you can too, so bring your energy to ours!

As a Business Data Scientist and member of the Commercial Technology team, you will work with our Gathering & Processing organization and play a key role in evolving our internal forecasting and commercial analytics platform, Unify. This position plays an important role in evolving our core system powering commercial analytics such as volume forecasting, allocation modeling, commodity optimization, imbalance management, and customer impact analysis. As technology continues to advance rapidly, Unify is uniquely positioned to leverage advanced analytics and AI‑driven insights, enabling the business to unlock deeper intelligence and drive business outcomes. It’s an exciting time to join Commercial Technology and help shape the future of data‑driven decision making. Your work will challenge you, and with our values to guide you, you’ll quickly learn and grow with us.

Responsibilities / Expectations

  • Develop, implement, and support business intelligence reporting, sophisticated analytical models, and data architecture to ensure availability and model support.
  • Create scalable, efficient, and automated processes for large‑scale data analyses for model development, validation, and implementation.
  • Enhance user interfaces and data visualization tools to improve the effectiveness of data analyses.
  • Train users to transform data into actionable information for critical business decisions and explore available data to identify patterns, anomalies, and trends.
  • Develop descriptive, predictive, and/or prescriptive statistical models to address business problems.
  • Work with large data sets in a hybrid cloud, using machine learning (ML) and artificial intelligence (AI) methods to help define requirements and set expectations.
  • Perform other duties as assigned.

Education / Years of Experience

Required

  • Bachelor’s Degree in Information Technology, Engineering, Construction Science, Business, and five (5) years of related experience supporting database development and data analytics; and/or natural gas industry experience.

Preferred

  • Master’s Degree in Business Administration, Data Science, Information Technology, and ten (10) years of work experience in data science and/or business intelligence development and/or natural gas fundamentals modeling.

Other Requirements

  • Demonstrates outstanding organizational/interpersonal skills and safety as the utmost priority.
  • Proficiency in Microsoft Office Applications.
  • Basic knowledge of databases (SQL, Oracle, Cube) and multi‑dimensional database structures.
  • Experience with business intelligence tools, reports, and dashboards.

Preferred

  • Proficiency in Azure analytics platforms (e.g., Synapse, Databricks, Data Factory).
  • Experience in project management, engineering, project controls, or construction sequencing.
  • Proficiency in writing DAX measures and queries.
  • Familiarity with pipelines, compression, and processing.

About Pittsburgh

Pittsburgh is a city full of adventure. If you love a good ball game or the great outdoors such as visiting Point State Park in Pittsburgh’s “Golden Triangle” to see the Allegheny River, Monongahela River, and Ohio River converge, then Pittsburgh has you covered! The city is also known for its “Only in Pittsburgh” experiences and its unique and vibrant 90 neighborhoods that create the perfect places to live, hang out, and explore.

  • Convenient, affordable place to live and work – cost of living 7 % lower than the national average.
  • Distinct local accent (“Pittsburghese”) and terms like “yinzer.”

Learn more:

Why Choose Williams?

We are committed to providing our employees with competitive compensation and benefits as part of your Total Rewards package to help protect your current and future physical, emotional, and financial health.

Competitive Compensation & Benefits

  • Annual incentive program
  • Hybrid work model – one work‑from‑home day each week for most office‑based roles
  • Flexible work schedule for most field‑based roles
  • 401(k) with company matching contribution and a fixed annual company contribution
  • Comprehensive medical, dental, and vision benefits
  • Generous company‑paid life insurance and disability benefits
  • Consumer‑driven health plan option with potential generous company contribution to a Health Savings Account
  • Healthcare and Dependent Care Flexible Spending Accounts
  • Paid time off, including floating and company holidays
  • Employee stock purchase plan
  • Robust employee learning and development
  • High internal mobility (we promote from within)
  • Parental leave (up to 6 weeks for each parent)
  • Fertility coverage and adoption benefits
  • Domestic partner benefits
  • Educational reimbursement
  • Non‑profit donation matching contributions and time off to volunteer
  • Employee resource groups
  • Employee assistance programs
  • Technology to make our work more productive and collaborative
  • Regular employee engagement surveys and feedback processes

Williams has a long history of making a significant difference in the communities where we live and work, and we strive to cultivate an environment of employee inclusion, innovation, and passion that values all voices and opinions. Together, we make clean energy happen.

Eligibility & Additional Information

Eligibility and benefits are governed by the terms of the applicable plan or program document which can be amended or terminated at any time. For more information, please visit Total Rewards | Williams Companies.

Education Requirements

  • Bachelors (Required)

Skill Requirements

Competency Requirements

  • Action oriented (3 – Meets Expectations)
  • Collaborates (3 – Meets Expectations)
  • Communicates effectively (3 – Meets Expectations)
  • Customer focus (3 – Meets Expectations)
  • Drives results (3 – Meets Expectations)
  • Ensures accountability (3 – Meets Expectations)
  • Instills trust (3 – Meets Expectations)

Talent Network

Don’t see your perfect role right now? Click Get Started below to join our talent network and be considered for future openings.

Why Williams?

Looking to apply your passion and skills to the innovative and vital work that helps fuel the clean energy economy? As the world demands reliable, low‑cost, low‑carbon energy, Williams will be there. We currently handle one‑third of the natural gas in the United States that is used every day to heat homes, cook food, and generate electricity.

We don’t offer jobs; we offer career opportunities that include:

  • Competitive compensation and inclusive benefits
  • Growth and development opportunities
  • An inclusive culture where you can be yourself
  • Opportunities to get involved in the community where you work and live
  • Flexible work arrangements for many positions, including hybrid schedules

We’re proud of our innovative people who want to make the world a better place and invite you to explore how you can help us make clean energy happen.

Apply now!
Learn About Williams.

Requirements

  • Proficiency in Microsoft Office Applications
  • Basic knowledge of databases (SQL, Oracle, Cube) and multi-dimensional database structures
  • Experience with business intelligence tools, reports, and dashboards

Responsibilities

  • Develops, implements, and supports business intelligence reporting, sophisticated analytical models and data architecture to ensure availability and model support
  • Creates scalable, efficient, and automated processes for large scale data analyses for model development, validation, and implementation
  • Enhances user interfaces and data visualization tools to improve the effectiveness of data analyses
  • Trains users to transform data into actionable information for critical business decisions and explores available data to identify patterns, anomalies, and trends
  • Develops descriptive, predictive and/or prescriptive statistical models to address business problems
  • Works with large data sets in a hybrid cloud, using machine learning (ML) and artificial intelligence (AI) methods to help define requirements and set expectations

Benefits

health insurancedental insurancevision insurancelife insurancedisability insuranceHealth Savings AccountHealthcare Flexible Spending AccountsDependent Care Flexible Spending Accountspaid time offfloating holidayscompany holidays401(k) with company matching contributionfixed annual company contributionemployee stock purchase planparental leavefertility coverageadoption benefitsdomestic partner benefitseducational reimbursementnon-profit donation matchingtime off to volunteeremployee resource groupsemployee assistance programs

Skills

AIAzure DatabricksAzure Data FactoryAzure SynapseCubeDAXData visualizationMLOracleSQL

Don't send a generic resume

Paste this job description into Mimi and get a resume tailored to exactly what the hiring team is looking for.

Get started free