Journey Health Foundation Research Center for Health and Economic Analytics (JHC), Department of Data Analytics

Gary W. Rollins College of Business

University of Tennessee at Chattanooga

The IT & Data Manager will be responsible for the design, development, implementation, and maintenance of the JHC's Data Warehouse of social determinant of health and other related data. The Manager will also be responsible for day-to-day Data Base Administration function which is a critical role responsible for managing and maintaining the performance, security, and integrity of JHC database systems. The IT & Data Manager will also manage the information technology of the center and will be responsible for functions including acquiring, cleaning, and loading the data on a regular basis; supervise activities of students, provide access to data, design and generate reports, perform complex data analysis, and develop and maintain the center's website. The position will interface with University IT for managing the server and any other software.

Duties and Responsibilities:

Data Warehouse Strategy: Develop and implement a comprehensive data warehouse strategy aligned with the JHC objectives.

Infrastructure Design: Design and architect the data warehouse infrastructure, including data modeling, ETL processes, and data quality management.

Data Governance: Establish and enforce data governance policies and standards to maintain data integrity and quality.

Data Integration: Manage the integration of data from various sources including HIPPA compliant data acquired from partners.

Reporting and Analytics: Support the development of data-driven reports and analytics to enable informed decision-making.

Technology Evaluation: Research and evaluate new data warehouse technologies and tools to improve efficiency and capabilities.

Data Security: Implement robust data security measures to protect sensitive information.

Database Design and Implementation: Design and implement database to meet requirements of JHC; create and maintain data models, schema, and indexes; and ensure data consistency and integrity through proper normalization and data validation.

Database Administration: Perform routine database administration tasks, such as backups, restores, and performance tuning; monitor database performance and identify bottlenecks; implement optimization strategies to improve database efficiency; and manage user accounts and permissions to control access to database resources.

Data Security: Implement and enforce security measures to protect data in database from unauthorized access, breaches, and corruption; monitor security logs and respond to security incidents; and ensure compliance with data privacy regulations (e.g., HIPAA).

Disaster Recovery: Develop and maintain disaster recovery plans to ensure data availability in case of system failures or disasters; and test disaster recovery procedures regularly.

Technical Support: Provide technical support to database users and applications; and troubleshoot database-related issues and resolve problems.

Performance Optimization: Identify and optimize database performance bottlenecks; and tune database parameters and indexes to improve query performance.

Documentation: Create and maintain comprehensive documentation of database systems, procedures, and policies.

Develop and maintain JHC website; interface with University IT for managing server and any other software; consult with stakeholders to understand needs and develop tools to collect data or deliver reports with requested information; and make data available to sponsored research projects and community partners.

The ideal candidate will possess the following:

• Proven experience in designing and implementing data warehouse architectures.

• Strong understanding of data modeling, ETL processes, and data quality management.

• Proficiency in SQL and BI tools (e.g., Tableau, Power BI).

• Strong knowledge of database management systems (DBMS), such as Oracle, SQL Server, MySQL,

• Proficiency in SQL and scripting languages (e.g., Python, Perl).

• Performance Tuning: Knowledge of techniques to improve database performance, including indexing, query optimization, and hardware configuration.

• Backup and Recovery: Expertise in implementing and managing backup and recovery procedures to safeguard data.

• Security: Understanding of database security best practices, including access controls, encryption, and vulnerability management.

• Excellent analytical and problem-solving skills.

• Strong leadership and communication skills.

• Ability to work effectively in a fast-paced environment.

• Website development and maintenance skills.

Review of applications will begin on November 1, 2024 and continue until the position is filled. Applications received by this date will receive priority consideration.

Minimum qualifications: Bachelor's degree in Computer Science, Information Systems, or a related field and five years of experience in data management and administration, or an equivalent combination of education, training, and experience; data analytics and modeling experience; application development and report generation experience; and website management experience.

Preferred Qualifications: Master's degree; experience in working with census data, social determinants of health, and issues related to health and economic disparities; familiarity with census and health care data; and familiarity with GIS tools.

Application Procedures

Applicants should submit the following information within our online application system for consideration:

• Cover Letter / Letter of Interest

• CV

• A list of names, addresses, telephone numbers, and email addresses for three references

About the Journey Health Foundation Research Center

The Journey Health Foundation Research Center for Health and Economic Analytics (JHC) is a newly established center in Gary W. Rollins College of Business with a significant donation from Journey Health Foundation (https://www.journeyhealthfoundation.org/). The core mission of the Center is to acquire, collect, and curate data related to social determinants of health and economic disparities in the greater Chattanooga region. The Center partners with Journey Health Foundation, local governments, greater Chattanooga area organizations, and other entities and individuals to conduct and publish research related to health and economic disparities and evaluate various approaches to address them.

About the Rollins College of Business

The College of Business at the University of Tennessee at Chattanooga received the largest philanthropic gift in the history of UTC from Gary W. Rollins and Kathleen Rollins of Atlanta. The $40 million gift established the Rollins College of Business as the first named college at UTC. Mr. Rollins was a graduate of the business school and is vice chairman and CEO of Rollins, Inc. a NYSE corporation with holdings that include Orkin, the world's largest pest control company.

The mission of the Rollins College of Business is to provide quality educational programs that produce academically prepared and business-world ready graduates for a competitive global environment. The Rollins College of Business at UTC has a long-standing AACSB accreditation, and the Department of Accounting is separately accredited by AACSB. The Rollins College of Business has approximately 2,000 undergraduate students in accounting, business analytics, economics, entrepreneurship, finance, human resource management, marketing, and management, and 300 graduate students in the MBA, Master of Science in Data Analytics, and Master of Accountancy programs. The college also offers minors in business administration, economics, entrepreneurship, personal finance, promotion, and sales. The Rollins College of Business is organized into four Departments (Accounting, Finance and Economics, Management, and Marketing and Entrepreneurship) with 65 full-time faculty. The Decosimo Success Center in the RCOB provides outstanding support to students in the areas of academic advisement, experiential learning, and career development.

About the University of Tennessee at Chattanooga

The University of Tennessee at Chattanooga is the second largest school in the University of Tennessee System, serving a diverse student body of approximately 11,500 undergraduate and graduate students. The four academic colleges and the graduate school of the University offer 45 baccalaureate degrees with 101 program concentrations; 13 graduate certificate programs with 36 program concentrations; 20 master's programs with 47 program concentrations, an education specialist program with four program concentrations, and five doctoral degrees with six program concentrations. Two additional units are led by deans: the Honors College and the Library. UTC has ten Chairs of Excellence, and an array of endowed professorships. UTC offers a unique blend of private and public-school traditions and is a driving force for achieving excellence, embracing diversity, inspiring positive change, and enriching the community. In 1969, UTC became part of the state university system. Today, UTC is on a journey to excellence - boldly embracing a passion for excellence in all things and focused on changing lives and transforming communities.

About Chattanooga, Tennessee

The University of Tennessee at Chattanooga proudly calls Chattanooga home--a city lauded by U.S. News and World Report, Money Magazine and Southern Living (to name a few!) for its unique blend of historic charm and modern vibrancy. Nestled between scenic Lookout Mountain and the Tennessee River, Chattanooga offers breathtaking natural beauty, lively city amenities and a small-town feel. Our city has it all, with historic cultural institutions like the Chattanooga Symphony Orchestra and the Bessie Smith Cultural Center, iconic attractions like Rock City and Ruby Falls, opportunities for epic outdoor adventures, and an eclectic contemporary art, music and food scene. Chattanooga's robust economy fosters an environment where tech start-ups thrive alongside established industries and corporations. It's where innovation meets tradition, creating endless opportunities for growth and success. UTC embodies Chattanooga's dynamic spirit, serving as one of the city's most vital institutions where progressive transformation and community thrive. UTC is where Chattanooga goes to build the future.

Additional information on the Rollins College of Business, University of Tennessee at Chattanooga, and Chattanooga can be found at the following links:

https://www.utc.edu/college-business/index.php

https://www.utc.edu/