Database Administrator Business Analyst - Hybrid Remote

Hoosier Energy; Bloomington (IN); On-site; USD 120,000 - 150,000; Full time

Job summary

Hoosier Energy is seeking a data platforms engineer to administer and optimize enterprise SQL Server databases, while building and supporting Power BI reporting solutions. The role includes managing the Alation Data Catalog and supporting data governance, stewardship, and metadata management initiatives.

Candidate will collaborate with business units, application owners, and vendors to deliver secure, governed data services and scalable analytics capabilities across the organization.

Qualifications

• Experience administering Microsoft SQL Server databases and related backups/recovery.
• Proficiency designing and delivering Power BI reports, data models, and DAX measures.
• Familiarity with data governance, metadata management, and data lineage practices.

Responsibilities

• Administer, monitor, secure, and optimize SQL Server databases.
• Design, develop, and support Power BI dashboards and datasets.
• Administer the Alation Data Catalog and support data governance activities.
• Collaborate with data owners, developers, and business analysts to deliver reliable data services.
• Develop ETL/ELT processes and automate repetitive tasks to improve reliability.

Skills

SQL Server

Power BI

Alation Data Catalog

Data governance

T-SQL

Tools

Power BI Desktop

Alation

ETL/ELT tooling

Job description

Administers, supports, secures, and optimizes Hoosier Energy’s enterprise Microsoft SQL Server databases and database-driven applications. Designs, develops, and supports Power BI reporting and analytics solutions and administers the Alation Data Catalog in support of data governance, stewardship, metadata management, and data literacy. Partners with business units, application owners, developers, vendors, Data Owners, and Data Stewards to deliver reliable, secure, recoverable, and well-governed data services while identifying opportunities to improve business processes through data and technology solutions.

DUTIES AND RESPONSIBILITIES

Database Administration

• 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 and proactively resolve risks and bottlenecks.
• Perform query analysis, indexing, execution-plan review, statistics maintenance, and T-SQL performance tuning.
• Design and maintain database structures, standards, access methods, maintenance plans, SQL Server Agent jobs, alerts, and automation.
• Administer users, roles, permissions, encryption, auditing, and related security controls.
• Ensure data confidentiality, integrity, availability, recoverability, and compliance.
• Document database architecture, configurations, procedures, standards, and support runbooks.

Database Applications Support

• Provide Tier 2 and Tier 3 support for SQL Server-based business applications and enterprise systems.
• Troubleshoot database connectivity, data integrity, stored procedures, views, functions, triggers, jobs, permissions, integrations, and performance.
• Partner with application owners, developers, business analysts, infrastructure, Cybersecurity, and vendors to resolve production issues.
• Support application upgrades, testing, releases, integrations, deployments, and migrations across development, test, and production.
• Review, optimize, test, debug, and document application-specific database logic and interfaces.
• Develop monitoring and automation to identify and address database and application issues proactively.
• Follow change, incident, problem, and documentation practices and participate in after-hours maintenance or support when required.

Business Analysis, Analytics, and Power BI

• Work with business units to analyze processes, document requirements, identify data needs, and recommend technology or process improvements.
• Design, develop, deploy, administer, and support Power BI dashboards, reports, paginated reports, semantic models, and datasets.
• Develop and optimize Power BI data models, DAX measures, calculated columns, and Power Query transformations to deliver secure, high-performing, user-friendly, and well-governed analytics solutions.
• Implement and maintain row-level security, role-based access, workspace governance, refresh schedules, gateways, deployment processes, and monitoring.
• Develop and support ETL/ELT and data integration processes using SQL Server Integration Services, SQL Server Agent, Power Query, and other approved technologies.
• Collaborate with stakeholders to translate requirements into scalable reporting and analytics solutions.
• Optimize reliability, performance, usability, and adoption across source databases, integrations, semantic models, and reports.
• Promote reusable standards and best practices for analytics, data modeling, reporting, and self-service business intelligence.

Alation Data Catalog and Data Governance

• Administer and support the Alation Data Catalog, including configuration, user access, onboarding, metadata management, maintenance, upgrades, and issue resolution.
• Connect and catalog data assets from SQL Server, Power BI, and other approved enterprise sources.
• Maintain technical and business metadata, glossaries, stewardship assignments, classifications, usage information, and lineage.
• Collaborate with Data Owners, Data St ...