Data Platform Engineer: DBA, BI & Governance

Indiana Electric Cooperatives

Bloomington (IN)

Hybrid

USD 120,000 - 150,000

Full time

8 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Hoosier Energy is seeking a Database Administrator/Business Analyst to manage enterprise SQL Server databases, build Power BI dashboards, and maintain the Alation Data Catalog. The role supports governance, metadata management, and data literacy across business units.

Hybrid remote work is available with occasional after-hours maintenance. The candidate will collaborate with Data Owners, Stewards, and IT teams to ensure secure, reliable data services and to identify opportunities to improve

Qualifications

Bachelor’s degree in IT, Informatics, Computer Science, Data Science, Data Analytics, or a related field.
5+ 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 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 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.
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.
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.
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.
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.