Lead Database Administrator - Enterprise Data & Analytics

$82,821 - $82,821/Yr

University of Iowa - Iowa City, IA

Full-time - Mid Level

Remote - Iowa City, IA

Educational Services

About the position

The Lead Database Administrator for Enterprise Data & Analytics is responsible for developing, administering, and controlling institutional data resources to ensure their availability, performance, integrity, and security. This role involves continuous support through the enhancement of existing data structures, managing SSIS ETL processes, and collaborating with analytics teams to migrate content to Power BI. The position also includes establishing best practices for analytics development and providing support for Power BI tools.

Responsibilities

• Develop and maintain databases and analytical content associated with organizational initiatives.
• Develop processes that automate data collection, data integration, and reporting efforts.
• Execute Power BI administrative tasks to support infrastructure growth, including managing workspaces and securing resources.
• Offer best practice guidance and documentation for Power BI development to both internal and external developers.
• Conduct QA checks of Power BI content before deploying it into production workspaces.
• Monitor Power BI capacity activity and address issues such as slow report performance and resource allocation.
• Support development teams with Power BI issues by troubleshooting and engaging with the tool vendor when necessary.
• Work with analytics teams to develop and implement dataflows and semantic models.
• Maintain clear and complete documentation for all analytical processes and procedures.
• Provide data management support to ensure data quality, consistency, and accuracy.
• Adapt and learn new methodologies or tools based on project requirements.
• Participate in upgrade-related validations as needed for source systems.
• Participate in off hours support for business initiatives as needed.

Requirements

• Bachelor's in Computer Science, Engineering or MIS or an equivalent combination of education and experience.
• Typically, 5 years of experience working directly with relational database systems using SQL and SQL procedural languages.
• Thorough understanding of relational database design fundamentals and ability to write and interpret complex SQL DML and DDL statements.
• Experience using statistical computer languages (R, Python, SQL, etc.) to manipulate data and draw insights from large data sets.
• Ability to interpret, modify and create complex custom database stored procedures and functions.
• Experience with interpreting query execution plans to identify opportunities for improved performance in a high-volume database environment.
• Extensive experience with Microsoft SQL Server.
• Proficiency in Power BI.
• Excellent communication skills, both written and oral, and strong interpersonal skills.

Nice-to-haves

• Cloud computing in Microsoft Azure including Power BI solution architecture and data lake storage techniques.
• Experience implementing source/version control in SSIS.
• Practical experience working with the Epic EHR and their Clarity and Caboodle analytic platforms.

Benefits

• 24 days paid vacation per year to start
• Paid sick leave