NCS Multistage · 3 months ago
BI Data Engineer
Chasewood, Houston, TX, US
Full-time
Onsite
Mid Level
3+ years expNCS Multistage is a company focused on data-driven decision making, and they are seeking a Business Intelligence (BI) Data Engineer to design, build, and maintain data infrastructure and analytics solutions. This role involves ensuring data quality and transforming raw data into actionable insights through various platforms.
Civil EngineeringMechanical Engineering
Responsibilities
Design and implement relational and dimensional databases, including schema design, indexing strategies, and performance tuning
Develop, maintain, and optimize ETL/ELT pipelines using Apache Airflow or Azure Data Factory (Fabric Data Factory)
Design scalable data models and pipelines for SQL Server and Snowflake
Deliver reporting and analytics solutions using Microsoft BI, including Fabric and Power BI
Ensure high availability, reliability, and performance of data processes
Build, maintain, and optimize dashboards and reports in Power BI and Fabric
Translate complex data sets into clear visualizations and metrics for business stakeholders
Partner with teams to identify KPIs and deliver actionable insights
Implement and monitor data validation, error handling, and performance tuning strategies
Contribute to best practices in data security, compliance, and governance
Work closely with data scientists, analysts, and business units to support cross-functional analytics initiatives
Participate in architectural discussions to improve scalability and efficiency of data solutions
Design and implement backup and restore strategies (full, differential, transaction log backups)
Knowledge of disaster recovery planning and RPO/RTO requirements
Experience with high availability solutions: SQL Server: Always On Availability Groups, Failover Clustering
Snowflake: Time Travel, Fail-safe
Ability to test and document recovery processes
Diagnose slow queries, deadlocks, and bottlenecks
Use tools like SQL Profiler, Extended Events, DMVs, Query Store, or Performance Monitor
Tune indexes, statistics, and query plans
Optimize ETL job performance and concurrency
Implement role-based access control (RBAC), encryption at rest/in transit, and auditing
Understand GDPR, SOC2, HIPAA, or other compliance frameworks
Manage user provisioning, privilege management, and data masking
Set up and monitor database maintenance plans (index rebuilds, integrity checks)
Automate housekeeping tasks via SQL Agent, PowerShell, or Fabric pipelines
Forecast storage growth and manage file groups/partitions
Understand I/O characteristics and underlying hardware/cloud configurations
Capacity and scalability planning for BI workloads
Data lifecycle management and archiving strategies
Collaboration with data architects to align database design with business goals
Documentation and governance of data assets and metadata
Snowflake Administration: Roles, warehouses, resource monitors, credit usage optimization
Azure SQL/Synapse/Fabric Data Warehouse administration
Familiarity with IAM, networking, and cost control in cloud data platforms
Experience with infrastructure as code (IaC) tools for database provisioning (e.g., Terraform, ARM templates)
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
Qualification
Required
Bachelor's degree in Computer Science, Information Technology, or equivalent experience
3+ years of experience in BI development, data engineering, or similar roles
Strong proficiency in SQL Server (database design, query optimization, stored procedures, performance tuning)
Hands-on experience with Snowflake (warehousing, schema design, data sharing, performance optimization)
Practical knowledge of Apache Airflow or Azure Data Factory (Fabric Data Factory) for orchestration and workflow management
Proficiency with the Microsoft BI stack, including Fabric and Power BI
Track record of building and maintaining well-designed databases, complex data pipelines, and reporting solutions
Strong analytical skills and ability to explain technical concepts clearly to business audiences
Experience with Python or other scripting languages for data manipulation
Knowledge of CI/CD practices for data pipeline deployment
Exposure to data governance frameworks and compliance standards
Familiarity with APIs and data integration tools
Understanding of AI-powered BI tools, including how to prepare and connect datasets for Microsoft Copilot in Power BI/Fabric
Awareness of how to design data models for AI-driven analytics and natural language queries
Benefits
Target Discretionary Bonus
Laptop
Company
NCS Multistage
NCS Multistage is an independent technology and services company specializing in multistage completions.
201-500 employees
H1B Sponsorship
NCS Multistage has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2022 (1)
2020 (1)
Funding
Current Stage
Public CompanyTotal Funding
unknownKey Investors
Sorenson Capital
2017-04-27IPO
2013-06-24Acquired
2011-01-01Private Equity
Leadership Team
Ryan Hummer
Chief Financial Officer
Robert Nipper
Board Member
Recent News
NCS Multistage Holdings, Inc.
2025-10-31
NCS Multistage Holdings, Inc.
2025-10-24
NCS Multistage Holdings, Inc.
2025-08-07
Company data provided by crunchbase