Business Intelligence (BI) Data Engineer

Job Title – Business Intelligence (BI) Data Engineer (Snowflake, Spotfire – Oil & Gas)

Department – Information Technology

Reports to – Director, Business Intelligence

Location – Houston, TX (In-Person)

Job Summary

We are seeking an experienced Business Intelligence (BI) Data Engineer with deep expertise in Snowflake and TIBCO Spotfire, and proven experience in the Oil & Gas industry, to support and evolve our enterprise analytics platform. The BI Data Engineer will be responsible for designing and maintaining Snowflake data models, supporting and optimizing Spotfire dashboards, and centralizing business logic into governed semantic structures. The ideal candidate understands upstream/midstream/downstream data domains, operational KPIs, and the performance and reliability expectations of industrial environments. This position will play a critical role in migrating semantic logic from Spotfire into Snowflake and ensuring scalable, governed analytics across the organization.

Key Areas of Responsibility

- Snowflake Data Engineering

- Design, build, and maintain dimensional data models (fact/dimension structures) in Snowflake

- Develop and optimize SQL transformations and governed analytic views

- Centralize KPI logic and business rules within Snowflake

- Monitor and optimize warehouse performance and credit usage

- Implement RBAC and security controls aligned with compliance requirements

- Maintain data lineage documentation and data governance standards

- Spotfire Support & Optimization

- Support and maintain enterprise Spotfire dashboards and reports

- Troubleshoot performance and data connectivity issues

- Extract and translate business logic embedded in Spotfire into Snowflake SQL

- Ensure Spotfire connects only to governed semantic views

- Optimize query performance for in-database analytics

- Oil & Gas Data Domain Expertise

- Work with operational, financial, and production datasets

- Understand and model industry KPIs (e.g., production volumes, job performance, cost per stage, margin analysis, utilization, etc.)

- Collaborate with operations, engineering, and finance teams to translate business requirements into scalable data structures

- Ensure data models reflect real-world field and operational processes

- Migration & Architecture

- Partner with BI Analysts and external BI developers to migrate semantic logic from Spotfire to Snowflake

- Standardize naming conventions and modeling best practices

- Improve scalability, reliability, and performance of the analytics platform

- Support long-term enterprise data strategy initiatives

- Support and uphold HS&E policies and procedures of NCS and the customer

- Align individual goals with NCS corporate goals, while adhering to the NCS Promise

- Participate in your Personal Development for Success (PDS)

- Other duties, relevant to the position, shall be assigned as required

Knowledge, Skills and Abilities

- Bachelor’s degree in Computer Science, Engineering, Information Technology, or related field (or equivalent experience)

- 5+ years of experience in BI or data engineering roles

- Strong hands-on experience with Snowflake (data modeling, SQL optimization, warehouse management)

- Advanced experience supporting TIBCO Spotfire dashboards in production environments

- Experience working in the Oil & Gas industry (mandatory)

- Strong SQL skills (joins, CTEs, window functions, performance tuning)

- Experience designing dimensional data models

- Experience working with large operational datasets

- Experience migrating semantic logic from BI tools into centralized data warehouse environments

- Experience in SOX or regulated environments

- Familiarity with orchestration tools (Airflow, Azure Data Factory, or similar)

- Experience optimizing Snowflake compute costs

- Experience collaborating with outsourced or cross-functional BI teams

- The ideal candidate:

- Understands both Snowflake architecture and Spotfire consumption patterns

- Has real-world Oil & Gas industry experience

- Thinks in terms of scalable, governed enterprise data models

- Can support operational dashboards while strengthening backend architecture

- Balances technical depth with business awareness

Additional Information

- FLSA Status: Exempt

- Employment Classification: Full-time, Regular

- Work schedule: 5 days on, 2 days off; Monday to Friday 8:00am – 5:00pm, on-call 24/7 for support

- Travel: 15-20% domestic travel required; some international travel may be required

- Target Discretionary Bonus: Eligible

- Special Equipment: Laptop

- Criminal background check required for all positions

- Safety sensitive positions will require additional pre-employment testing

Core Competencies

- Enterprise Data Architecture

- Oil & Gas Domain Expertise

- Performance Optimization

- Governance & Compliance Awareness

- Analytical Problem Solving

- Cross-Functional Collaboration

- Accountability & Continuous Improvement