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.