Expert Analyst Data Management (Epic ODBA Cert Req'd)

JOB SUMMARY

Responsible for the efficient and effective management of data assets as well as designing and implementing data management strategy and processes related to acquiring, organizing, storing, integrating, and maintaining data within an organization. Establishes data management strategy, data governance policies, procedures, and practices to ensure the effective and efficient use of data throughout its lifecycle. Oversees implementation of data management tools and technologies. Collaborates with stakeholders to understand data requirements.

ESSENTIAL FUNCTIONS

• Design enterprise-level database architecture and standards.
• Develop strategies for scalability, security, and high availability.
• Plan and lead database modernization and migration projects.
• Establish data governance frameworks and policies.
• Ensure compliance with regulatory and organizational standards.
• Analyze and optimize database performance across platforms.
• Plan for future capacity and resource requirements.
• Implement automation for provisioning and maintenance.
• Evaluate emerging technologies and integrate best practices.
• Work with cross-functional teams on architecture decisions.
• Mentor DBAs and developers on database best practices.
• Maintain architecture diagrams, SOPs, and compliance documentation.

ADDITIONAL RESPONSIBILITIES

• ORGANIZATIONAL IMPACT: Works to achieve operational targets with major impact on the job area results. Contributes to the development of goals for the job area and planning efforts (budgets, operational plans, etc.). May manage large technical projects or processes that span outside of immediate job area.
• INNOVATION & COMPLEXITY: Demonstrates innovative influence in supporting business objectives and mission. Responsible for making moderate to significant improvements of technical processes, systems or products to enhance performance of the job area. Problems and issues faced are numerous and undefined, and require detailed information gathering, analysis and investigation to understand the problem. Problems are difficult and moderately complex. Problems typically are within team/job area specific processes. Problems are typically solved through drawing from prior experience and analysis of issues.
• COMMUNICATION & INFLUENCE: Communicates with parties within and outside of own job area. Typically has responsibility for communicating with parties external to IS&T and Jefferson, which may include customers or vendors. Works to influence parties within and outside of the job area at an operational level regarding policies, procedures and practices.

QUALIFICATIONS

Education - Required

• High School Diploma/GED

Education - Preferred

• Bachelor’s Degree Computer Science, Information Systems, or related field. or
• Master’s Degree Computer Science, Information Systems, or related field.

Experience - Required

• 7 years related work experience

Knowledge, Skills and Abilities - Required

• Proficiency in relational and cloud database platforms, including Microsoft SQL Server, Oracle, PostgreSQL, MySQL, Azure SQL Database, AWS RDS, and Google Cloud SQL.
• Strong expertise in data modeling and architecture (ER modeling, normalization, schema design) and performance tuning techniques such as query optimization, indexing, and partitioning.
• In-depth knowledge of high availability and disaster recovery strategies (clustering, replication, AlwaysOn) and security practices including encryption, auditing, and role-based access control.
• Experience with automation and scripting using PowerShell, Python, T-SQL, and PL/SQL, as well as infrastructure-as-code tools like Terraform and Ansible for database provisioning.
• Familiarity with monitoring tools (SQL Profiler, Oracle Enterprise Manager, SolarWinds DPA) and compliance standards such as GDPR, HIPAA, and SOX.

VALUES AND HABITS

Put People First​

• Put People First: Create a safe environment where all colleagues feel supported and motivated to be their best at work.
• Build relationships: Build belonging, empathy, and collaboration.
• Engage with grace: Assume positive intent and share your perspective thoughtfully.
• Create moments: Affirm and acknowledge the contributions and efforts of others. ​

Do What's Right​

• Do What’s Right: Focus on how we work most effectively to get the best results.
• Prioritize What Matters: Clarify what’s most critical and why.​
• Align on Expectations: Translate priorities into agreed upon accountabilities and outcomes.
• Act with integrity: Behave ethically and honestly in all interactions and business practices.

Pursue Excellence​

• Pursue Excellence: Focus on learning and growth. ​
• Look and Listen: Explore new ways of working and stay curious by learning from others.
• Innovate with Intent: Try new ideas that support organizational priorities.
• Value Lessons Learned: Acknowledge progress and insights that come from striving to improve.