Pay Grade: M09
POSITION SUMMARYAdministers, 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 RESPONSIBILITIESDatabase 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 Stewards, subject matter experts, and stakeholders to document, certify, govern, and maintain data assets.
- Collect, validate, enrich, and monitor metadata to improve discoverability, usability, trust, and auditability.
- Develop processes and automation that improve metadata ingestion, quality, adoption, curation efficiency, and discoverability.
- Provide training and support for Alation, metadata practices, stewardship responsibilities, and effective catalog use.
- Support data governance standards, data quality, classification, security, retention, compliance, and responsible data usage.
- Participate as an active member of the Data Governance Committee and support governance initiatives, metrics, communications, and continuous improvement.
- Monitor catalog adoption and recommend improvements that increase data literacy and self-service analytics.
Collaboration and Continuous Improvement- Participate on project teams and coordinate database, application, analytics, and governance work.
- Keep current with Microsoft SQL Server, Power BI, Alation, database design, security, governance, and analytics practices.
- Exchange relevant information with member systems, vendors, consultants, peer utilities, and professional communities as appropriate.
JOB SPECIFICATIONSEducation:
- Bachelor's degree in Information Technology, Informatics, Computer Science, Data Science, Data Analytics, or a related field minimum. Equivalent relevant work experience may be considered.
Experience:
- 5 or more years of progressively responsible experience in database administration, business intelligence, analytics, application support, or related disciplines minimum.
- Demonstrated experience administering Microsoft SQL Server in production environments, including performance tuning, backup and recovery, security, maintenance, and troubleshooting.
- Experience supporting SQL Server-based enterprise applications.
- 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.
Skills and Abilities:
- Advanced knowledge of Microsoft SQL Server, T-SQL, database architecture, indexing, execution plans, security, backup and recovery, high availability, and performance optimization.
- Strong knowledge of Power BI, DAX, Power Query, dimensional data modeling, ETL/ELT, and data integration concepts.
- Working knowledge of Alation or comparable catalog technology, metadata management, glossaries, lineage, stewardship, data quality, and governance.
- Knowledge of PowerShell, scripting, automation, source control, and CI/CD practices is preferred.
- Ability to diagnose complex issues spanning databases, applications, infrastructure, integrations, and reporting platforms.
- Strong analytical, problem-solving, decision-making, organizational, documentation, communication, and project-management skills.
- Ability to translate complex technical and analytical findings into clear, actionable insights for business leaders and non-technical stakeholders.
- Ability to manage multiple priorities and work independently and collaboratively in a changing environment.
Working Conditions:
- Usual office conditions apply.
- Hybrid work may be available in accordance with policy and business needs.
- Occasional after-hours work may be required for maintenance, upgrades, incidents, or recovery.
- Occasional travel to other Hoosier Energy or member-system locations may be required.
