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

Hoosier Energy Jobs•Bloomington, IN

51d•Hybrid

About The Position

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.

Requirements

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.

Nice To Haves

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.

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.