Data Systems Manager

A global higher education leader in innovative teaching, research and public service, the University of North Carolina at Chapel Hill consistently ranks as one of the nation's top public universities. Known for its beautiful campus, world-class medical care, commitment to the arts and top athletic programs, Carolina is an ideal place to teach, work and learn.

One of the best college towns and best places to live in the United States, Chapel Hill has diverse social, cultural, recreation and professional opportunities that span the campus and community.

University employees can choose from a wide range of professional training opportunities for career growth, skill development and lifelong learning and enjoy exclusive perks for numerous retail, restaurant and performing arts discounts, savings on local child care centers and special rates on select campus events. UNC-Chapel Hill offers full-time employees a comprehensive benefits package, paid leave, and a variety of health, life and retirement plans and additional programs that support a healthy work/life balance.

The Cecil G. Sheps Center for Health Services Research seeks to improve the health of individuals, families, and populations by understanding the problems, issues, and alternatives in the design and delivery of health care services. This is accomplished through an interdisciplinary program of research, consultation, technical assistance, and training that focuses on timely and policy-relevant questions concerning the accessibility, adequacy, organization, cost, and effectiveness of health care services, and the dissemination of this information to policymakers and the general public.

We are seeking a Data Systems Manager to work with the Program on Health Workforce Research and Policy at the Cecil G. Sheps Center for Health Services Research at the University of North Carolina at Chapel Hill. The Health Professions Data System Team ( HPDS) produces annual health workforce data for North Carolina. Check out our work here: https://www.shepscenter.unc.edu/data/health-professions-data-system

The Cecil G. Sheps Center for Health Services Research at the University of North Carolina at Chapel Hill is recruiting for a Data Systems Manager to work with the Program on Health Workforce Research and Policy.

The Data Systems Manager will
* Design and manage a PostgreSQL-based relational database to store and harmonize over 20 years of annual licensure data, including data normalization and schema design.
* Automate processes using tools like Python to transform raw flat files into structured data for the database.
* Translate legacy SAS code from the existing data pipeline and adapt it for the newer RDBMS-based system.
* Continue to process annual licensure data using legacy SAS pipeline until RDBMS focused pipeline is stable.
* Maintain documentation for annual and longitudinal licensure data, including schema and data processing workflows.
* Perform data cleaning and analysis using programming languages (e.g., Python, R, Stata, SAS).
* Provide quality assurance checks and audits of data reports; identify and propose solutions to data issues and changes.
* Collaborate with licensing boards and external organizations to troubleshoot dataset issues and clarify data sources.
* Communicate issues and findings to investigators and team members, using email, presentations, data visualizations, etc.
* Manage project timelines, deliverables, and completion of required project objectives.
* Work with interdisciplinary team to improve and maintain data systems to manage and compile datasets.

Relevant post-Baccalaureate degree required (or foreign degree equivalent); for candidates demonstrating comparable independent research productivity, will accept a relevant Bachelor's degree (or foreign degree equivalent) and 3 or more years of relevant experience in substitution. May require terminal degree and licensure.

* Experience in data management and analysis
* Experience in the design and management of relational databases for research data
* Strong understanding of best practices in data management and documentation
* Proficient in coding and analysis software tools such as Python, SQL, Stata, or SAS.

* Five years of experience in data management and analysis
* Experience managing teams or other analysts
* Ability to quickly and easily learn new software
* An analytical mindset for solving problems
* Demonstrated data management and documentation experience
* Experience cleaning and merging data
* Strong interpersonal and collaboration skills
* Strong oral, written communication, and presentation skills

Additional Application Documents Required: Example Work Products

The University is an equal opportunity employer and welcomes all to apply without regard to age, color, gender, gender expression, gender identity, genetic information, national origin, race, religion, sex, or sexual orientation. We encourage all qualified applicants to apply, including protected veterans and individuals with disabilities.