Demo

BI Analyst & Data Solutions Lead

Texas Reliability Entity
Austin, TX Full Time
POSTED ON 4/12/2025
AVAILABLE BEFORE 5/10/2025

Business Intelligence (BI) & Data Solutions Lead

Texas Reliability Entity, Inc. (Texas RE) is hiring! We are seeking BI Analyst & Data Solutions Lead to join our Information Technology Team. Here, you will be responsible for designing, implementing, and maintaining Texas RE's data warehouse by integrating structured and semi-structured data sources to support business intelligence and predictive analytics initiatives.

Who We Are

At Texas RE, we affect the lives of millions of people by ensuring effective and efficient reduction of risks to the reliability and security of the Bulk Power System within the ERCOT Interconnection. The ERCOT Interconnection is located within the State of Texas and includes approximately 90% of Texas's electric load and 75% of its land area. Texas RE's teams support this mission while enjoying a flexible work environment, open collaboration, and a culture that values diversity, equity, and inclusion. Considered candidates will be required to reside in the Austin-metro area or be able to reliably commute to the office within a reasonable amount of time.

The ideal candidate will have the following attributes :

  • Bachelor's degree in Business, Computer Science, Engineering, Statistics, or a related field
  • 3 years of experience using Microsoft Power BI or an equivalent reporting / visualization tool.
  • Experience designing and managing a data warehouse or similar structured data environment.
  • Strong SQL skills for data extraction, transformation, and analysis.
  • Experience working with ETL processes and data integration methodologies.

Summary of Responsibilities

The Business Intelligence (BI) & Data Solutions Lead is responsible for designing, implementing, and maintaining Texas RE's data warehouse by integrating structured and semi-structured data sources to support business intelligence and predictive analytics initiatives. This role will lead the selection of data warehousing and ETL solutions, ensuring a scalable and maintainable platform that meets the organization's needs.

The successful candidate will work closely with internal stakeholders to develop reporting and visualization capabilities using tools such as Microsoft Power BI, ensuring that Texas RE employees can effectively analyze and utilize data for decision-making. Additionally, they will provide guidance and training to business users on BI tools and data best practices.

This position reports to the Director, IT Infrastructure & Cyber & Physical Security. This position does not have direct reports.

Essential Job Duties

  • Lead the development and implementation of Texas RE's data warehouse, integrating data from multiple sources.
  • Evaluate and recommend ETL solutions, determining whether to build or buy components of the data pipeline.
  • Develop and maintain business intelligence solutions using tools like Microsoft Power BI, providing dashboards, reports, and real-time analytics for internal and external stakeholders.
  • Work with business units to identify key data sources and define data models for predictive analysis and strategic decision-making.
  • Establish processes to ensure data reliability, accuracy, and consistency across all sources.
  • Document data management, transformation, and analysis best practices to support ongoing data initiatives.
  • Participate and support Texas RE committees, ERO activities, and industry working groups / task forces.
  • Provide training and guidance to employees on BI tool usage, with future training on SQL querying as needed.
  • Collaborate with IT leadership and business units to align data strategy with organizational goals.
  • Provide ongoing development and maintenance of data stores and / or warehouses to ensure scalability, security, and availability.
  • Ensure that data security and governance practices align with Texas RE's security policies.
  • Create and maintain technical documentation, including system configurations, data mappings, and training materials.
  • Participate and support Texas RE committees, regional activities, and industry working groups / task forces.
  • Perform other tasks and activities as assigned.
  • Education

  • Bachelor's degree in Business, Computer Science, Engineering, Statistics, or a related field; or six (6) years of related work experience or certifications in addition to minimum work experience requirement.
  • Required Experience

  • 3 years of experience using Microsoft Power BI or an equivalent reporting / visualization tool.
  • Experience designing and managing a data warehouse or similar structured data environment.
  • Strong SQL skills for data extraction, transformation, and analysis.
  • Experience working with ETL processes and data integration methodologies.
  • Ability to assess, recommend, and implement BI and data warehouse solutions
  • Strong analytical and problem-solving skills, with the ability to translate business needs into structured data solutions.
  • Excellent written and verbal communication skills , with the ability to explain data concepts to non-technical stakeholders.
  • Experience providing training and supportto employees on BI tools.
  • Preferred Experience

  • Experience with data warehouses (e.g., Azure Synapse, Snowflake, AWS Redshift).
  • Experience with ETL tools (e.g., SSIS, Fivetran, Matillion).
  • Familiarity with API-based data integrations.
  • Knowledge of data governance and security best practices.
  • Job Competencies / Skills

  • Strong communication skills to work with both technical and non-technical stakeholders.
  • Ability to identify business opportunities through data analysis.
  • High attention to detail and data accuracy.
  • Self-motivated and proactive, capable of leading a data warehousing initiative in a small organization.
  • Comfortable balancing strategic decision-making with hands-on implementation.
  • Company Highlights and Benefits

    Employees work a hybrid work schedule consisting of at least two days in the office with the option of working three days remotely. Additional in-office work may be required depending on project scopes. Additionally, employees have the option to take advantage of Flexible Friday, where employees may shift working hours to earlier in the week instead of on Friday afternoon.

    Texas RE pays 100% of employee-only coverage for medical, dental, vision, life and ADD, short-term and long-term disability, and long-term care insurance, as well as the employee assistance program. Additional benefits are offered at a minimal cost to the employee such as dependent medical, dental, voluntary life and ADD for employees, spouses, and children, additional long-term care coverage for family members, legal services and identity protection.

    Texas RE provides a generous 401(k) or Roth 401(k) savings plan for employees, contributing 10% of an employee's compensation towards the retirement plan with full vesting after three (3) years. Additionally, Texas RE will match 75%, up to 6%, of employee contributions, with vesting at 20% per year and full vesting at five (5) years of employment.

    Additional Information for Applicants

  • Background checks (including criminal history and drug screening, education and employment verification) will be conducted prior to employment.
  • Certain positions require travel outside the U.S.; valid passport necessary for those positions.
  • Texas RE has restrictions on employee and employee's household members' employment and financial relationships with NERC registered entities. Additional details furnished upon request.
  • Texas RE is committed to attracting top talent from a diverse candidate pool. During the interview process, candidates will meet with a cross-section of Texas RE employees who bring a broad set of perspectives to the discussion. Our inclusive, friendly work environment encourages employees to collaborate across and outside of our organization, while also offering opportunities for personal growth. Our team of professional, technical, and administrative staff derives its collective strength from our varied backgrounds.

    Texas RE is an equal employment opportunity employer and prohibits discrimination against employees or job applicants on the basis of race, color, sex (including sexual orientation, gender identity / transgender status, and pregnancy), religion, national origin, age (40 or older), disability, veteran status, marital status, genetic information, or other status protected by law.

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a BI Analyst & Data Solutions Lead?

    Sign up to receive alerts about other jobs on the BI Analyst & Data Solutions Lead career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $101,449 - $132,468
    Income Estimation: 
    $124,087 - $161,899
    Income Estimation: 
    $202,391 - $284,225
    Income Estimation: 
    $241,759 - $371,362
    Income Estimation: 
    $64,949 - $84,690
    Income Estimation: 
    $81,298 - $105,685
    Income Estimation: 
    $81,298 - $105,685
    Income Estimation: 
    $101,449 - $132,468
    Income Estimation: 
    $101,449 - $132,468
    Income Estimation: 
    $124,087 - $161,899
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Texas Reliability Entity

    Texas Reliability Entity
    Hired Organization Address Austin, TX Full Time
    CIP Cyber & Physical Security Analyst (Auditor) Texas Reliability Entity, Inc. (Texas RE) is hiring! We are seeking a CI...

    Not the job you're looking for? Here are some other BI Analyst & Data Solutions Lead jobs in the Austin, TX area that may be a better fit.

    Luna Data Solutions, Inc. | PeopleSoft Business Analyst

    Luna Data Solutions, Inc., Austin, TX

    Data Analyst/Report Writer

    COGENT DATA SOLUTIONS LLC, Austin, TX

    AI Assistant is available now!

    Feel free to start your new journey!