Hybrid DBA & BI Analyst: SQL, Power BI & Data Governance

Hoosier-Energy; Bloomington (IN); Hybrid; USD 95,000 - 125,000; Full time

Job summary

Hoosier Energy is seeking a Database Administrator Business Analyst to administer and optimize enterprise SQL Server databases and to design, deploy, and support Power BI analytics solutions. The role also involves managing the Alation Data Catalog and supporting data governance initiatives.

The position combines database administration, analytics, and governance work in a hybrid remote environment, with collaboration across business units, developers, and data stewards.

Qualifications

• Bachelor’s degree in Information Technology, Informatics, Computer Science, Data Science, Data Analytics, or related field minimum.
• 5+ years of progressively responsible experience in database administration, BI, analytics, or related disciplines.
• Experience administering Microsoft SQL Server in production environments including performance tuning, backup and recovery, security, maintenance, and troubleshooting.
• Experience designing, developing, and supporting Power BI solutions including data modeling, DAX, Power Query, security, refresh, and performance optimization.
• Experience with ETL/ELT, data integration, SQL Server Integration Services, or related data technologies.
• Experience supporting a data catalog or metadata-management platform; Alation experience is preferred.
• Experience working with Data Owners, Data Stewards, and data governance initiatives is preferred.

Responsibilities

• Administer, monitor, maintain, secure, and optimize Microsoft SQL Server databases.
• Plan and execute database installations, configurations, upgrades, migrations, and patching.
• Implement and maintain backup, restore, high-availability, disaster-recovery, replication, and failover capabilities.
• Monitor database health, storage, capacity, availability, and performance; proactively resolve risks.
• Design and maintain database structures, standards, access methods, and automation.
• Provide Tier 2/3 support for SQL Server-based business applications and enterprise systems.
• Develop Power BI dashboards, reports, datasets, and data models; implement security and governance.

Skills

SQL Server

T-SQL

Database architecture

Indexing

Execution plans

Security

Backup and recovery

High availability

Power BI

Education

Bachelor’s degree in IT/CS/Data Analytics or related field

Tools

Power BI

Alation

SSMS (SQL Server Management Studio)

Power Query

DAX

Job description

Hoosier Energy is seeking a Database Administrator Business Analyst to administer and optimize enterprise SQL Server databases and to design, deploy, and support Power BI analytics solutions. The role also involves managing the Alation Data Catalog and supporting data governance initiatives.

The position combines database administration, analytics, and governance work in a hybrid remote environment, with collaboration across business units, developers, and data stewards.