Full-Time

BI Analyst 2

Posted on 6/22/2026

Adept Solutions

Adept Solutions

11-50 employees

Oil and gas hydrocarbon accounting software

No salary listed

New York, NY, USA

In Person

Category
Data & Analytics (1)
Required Skills
SQL
ETL
C#
Requirements
  • SSIS development experience (5 years minimum).
  • SQL development experience including in-depth knowledge of various SQL Server 2008 and SQL Server 2012 versions.
  • C# application development in SQL Server environment (5 years minimum).
  • Database development experience in SQL environment.
  • Strong SQL and Transact-SQL (T-SQL) is a must.
  • Candidate should have experience in full life cycle (SDLC) of Data Warehouse - design and implementation.
  • Ability to analyze business requirements and ensure all requirements are appropriately addressed by the proposed solution.
  • Must be analytical, solution-oriented, and possess excellent trouble shooting and time-management skills.
  • Experience with Data Extraction, Transformation and Loading using ETL tools like SSIS, In-depth knowledge of industry standard ETL and BI tools.
  • Possess the ability to work in a team environment and communicate effectively and implement complex business logic and functionality as instructed by the client.
Responsibilities
  • SSIS development experience (5 years minimum).
  • SQL development experience including in-depth knowledge of various SQL Server 2008 & 12 versions.
  • C# application development in SQL Server environment (5 years minimum).
  • Database development experience in SQL environment.
  • Strong SQL & TSQL is a must.
  • Candidate should have experience in full life cycle (SDLC) of Data Warehouse - design and implementation.
Desired Qualifications
  • Deep experience with C# and solid work experiences using T-SQL, SSRS, SSAS, MDX, query performance tunings, database development, implementation, and support of data warehouses, and underlying data models.

AXIS by Omnira Software provides hydrocarbon accounting software for oil and gas, serving upstream, midstream, terminals, and LNG operators. It covers core activities such as production allocation, gas accounting, tanker scheduling, and LNG cargo management to ensure complete accountability from wellhead to point of sale. The product focuses on data integrity, audit-ready workflows, and operational insight, enabling accurate and traceable production records for companies ranging from small independents to large multinationals. AXIS can be deployed on-premises or as a cloud-based SaaS solution. Originally developed by Adept Solutions in 2006 and now part of Omnira Software, AXIS has evolved through decades of real-world use across diverse operations worldwide.

Company Size

11-50

Company Stage

N/A

Total Funding

N/A

Headquarters

Aberdeen, United Kingdom

Founded

2006

Your Connections

People at Adept Solutions who can refer or advise you

Simplify Jobs

Simplify's Take

What believers are saying

  • Omnira can cross-sell Axis into its broader reserves, planning, and analytics suite.
  • The acquisition strengthens integrated decision-making across production, forecasting, planning, and reserves management.
  • Adept’s sticky workflows support recurring renewals and expansion within existing accounts.

What critics are saying

  • Omnira integration failures can disrupt production allocation and reporting for customers.
  • Cross-selling and bundling can accelerate churn as Omnira repositions Axis customers.
  • Legacy workflows face replacement pressure from newer cloud-native competitors during renewals.

What makes Adept Solutions unique

  • Axis provides auditable production, sales, and emissions statements for oil and gas operators.
  • Adept serves daily, business-critical hydrocarbon accounting workflows tied to contractual and regulatory obligations.
  • Its installed base spans small independents through multinational operators worldwide.

Help us improve and share your feedback! Did you find this helpful?

Benefits

Health Insurance

401(k) Retirement Plan

Remote Work Options

Flexible Work Hours

Paid Vacation

Paid Holidays

Sabbatical Leave

Hybrid Work Options

Professional Development Budget

Conference Attendance Budget

Wellness Program

Mental Health Support

Gym Membership

Phone/Internet Stipend

Home Office Stipend

Commuter Benefits

Adoption Assistance

Family Planning Benefits

Fertility Treatment Support

Company News

Global Fintech Series
May 7th, 2025
Omnira Acquires Adept Solutions for Axis

Omnira Software has acquired Adept Solutions, a leader in production accounting solutions for the oil and gas industry. Adept's Axis™ product is widely used for production allocation and reporting. This acquisition aims to enhance Omnira's offerings in production, forecasting, planning, and reserves management, supporting better decision-making. Richard Alderson, Managing Director at Adept, expressed enthusiasm about joining Omnira to continue innovation and expand their reach.

Man in Black Media
May 7th, 2025
CALGARY, AB, May 7, 2025 /PRNewswire/ - Omnira Software is pleased to announce the acquisition of Adept Solutions, the leader in comprehensive production accounting solutions for the oil and gas industry.

CALGARY, AB, may 7, 2025 /prnewswire/ - Omnira Software is pleased to announce the acquisition of Adept Solutions, the leader in comprehensive production accounting solutions for the oil and gas industry.

Adept Solutions
Jun 16th, 2021
Adept Solutions hires Peter Miller

Adept Solutions has appointed Peter Miller in a non-executive role as Adept Solutions target further growth in the European, Middle East and African markets.