BI Data Engineer

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Full Time Professional Chasewood, Houston, TX, US

30+ days ago Requisition

Job Title – Business Intelligence (BI) Data Engineer

Department – Information Technology

Reports to – Director IT Infrastructure & Ops

Location – Houston, TX (In-Person)

The Business Intelligence (BI) Data Engineer will be responsible for designing, building, and maintaining the data infrastructure, pipelines, and analytics solutions that drive data-informed decision making across the organization. This role bridges data engineering and business intelligence, ensuring data is clean, reliable, and transformed into meaningful insights through platforms like Microsoft Fabric, Power BI, SQL Server, and Snowflake. This role requires the ability to solve complex data challenges, experience across cloud and on-premises platforms, and the ability to turn raw data into trusted, actionable intelligence for business stakeholders.

• 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
• Business Intelligence & Analytics
  • 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
• Data Governance & Quality
  • 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
• Core Database Administration (DBA) Skills
  • Backup, Recovery & High Availability
    • 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
  • Performance Monitoring & Tuning
    • 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
  • Security & Compliance
    • 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
  • Maintenance & Automation
    • Set up and monitor database maintenance plans (index rebuilds, integrity checks)
    • Automate housekeeping tasks via SQL Agent, Power Shell, or Fabric pipelines
  • Capacity Planning & Storage Management
    • Forecast storage growth and manage file groups/partitions
    • Understand I/O characteristics and underlying hardware/cloud configurations
• Advanced/Strategic DBA Skills
  • 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
• Cloud DBA/Modern Data Platform Skills (for hybrid or cloud environments)
  • 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…