Data Analyst / Business Intelligence (BI) Support Specialist - Temporary - Hybrid Remote

Hoosier Energy; Bloomington (IN); On-site; USD 60,000 - 80,000; Full time

Job summary

Hoosier Energy is seeking a Data Analyst / Business Intelligence (BI) Support Specialist in Bloomington, IN. This temporary full-time position is responsible for the design, development, and support of BI solutions, ensuring data integrity and security across platforms.

The successful candidate will have a strong background in SQL Server, BI development, and analytics, and is expected to collaborate across teams to translate requirements into impactful BI solutions.

Flexibility for project deadlines and occasional travel may be required.

Qualifications

• Minimum of 3 years’ experience in Business Intelligence, Data Analytics, or Data Warehousing.
• Advanced proficiency in SQL Server, query optimization, and indexing.
• Experience designing and implementing ETL/ELT pipelines for structured and unstructured data.

Responsibilities

• Develop and maintain BI solutions using Microsoft Fabric, Power BI, and Azure Data Services.
• Design and implement data models, ETL/ELT pipelines, and visualization dashboards.
• Collaborate with business stakeholders to translate requirements into BI solutions.

Skills

Data modeling techniques

SQL proficiency (T-SQL)

Experience with Microsoft Fabric

Power BI development

Problem-solving skills

Education

Bachelor’s degree in Computer Science or related field

Tools

Azure Data Services

SQL Server (2019+)

Power Query (M language)

Job description

Position Overview

The Data Analyst / Business Intelligence (BI) Support Specialist - Temporary is responsible for the design, development, implementation, and support of enterprise Business Intelligence (BI) solutions. This position ensures data integrity, security, and performance across BI platforms and provides application support to business units.

Essential Duties And Responsibilities

• Develop and maintain BI solutions utilizing Microsoft Fabric, Power BI, and Azure Data Services.
• Design and implement data models, ETL/ELT pipelines, and visualization dashboards.
• Build and optimize Power BI reports, dashboards, and paginated reports.
• Manage Azure Synapse, Data Factory, Data Lake, and Fabric Data Warehouse for data processing and transformation.
• Write and optimize T‑SQL queries, stored procedures, and indexing in SQL Server (2019+).
• Provide Level 2/3 support for custom SQL‑driven applications, including troubleshooting and user support.
• Maintain the Alation data catalog, ensuring metadata accuracy and compliance with governance standards.
• Ensure data governance, security, and compliance, including role‑based access control (RBAC) and row‑level security (RLS).
• Collaborate with business stakeholders, developers, and analysts to translate requirements into BI solutions.
• Monitor BI system performance and implement improvements for reliability and availability.
• Work with IT Applications and IT Infrastructure teams to implement CI/CD pipelines for BI deployments.
• Mentor BI team members and promote best practices in analytics development.

Minimum Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or related field, or equivalent experience.
• Minimum of 3 years’ experience in Business Intelligence, Data Analytics, or Data Warehousing.
• Experience with Microsoft Fabric, Power BI, and Azure Data Services (Data Factory, Synapse, Data Lake, Dataverse).
• Advanced proficiency in SQL Server (T‑SQL, query optimization, indexing).
• Proficiency in DAX, Power Query (M language), and Power BI development.
• Experience with data modeling techniques (Star Schema, Snowflake) and performance optimization.
• Experience designing and implementing ETL/ELT pipelines for structured and unstructured data.
• Familiarity with RBAC, RLS, and compliance best practices.
• Strong analytical, problem‑solving, and communication skills.

Preferred Qualifications

• Experience with Azure SQL, DevOps for BI deployments, or Python for data preparation.
• Familiarity with ITIL and/or ITSM ticketing systems.
• Ability to present insights to non‑technical audiences.

Working Conditions

• Office environment, Bloomington, IN.
• Occasional travel may be required.
• Standard work hours with flexibility for project deadlines.

This full time position is temporary; however, it is expected to potentially have a duration of indefinite. The incumbent will be employed through Express Employment.

Hoosier Energy is an Equal Opportunity Employer and prohibits discrimination on the basis of race, color, religion, national origin, sex (including pregnancy and gender identity), sexual orientation, age, ancestry, genetic information, disability, veteran status or any other characteristic protected by federal, state or local laws.