Business Intelligence (BI) Data Engineer
About The Position
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.
Requirements
- 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
- 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
Responsibilities
- 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
- 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
- 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
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
