IT Analyst/Programmer - 3 (Haendel)

The Department of Genetics is looking for a Research Informatics Specialist that will work both independently and in collaboration with other team members and other investigators on campus with responsibilities related to data management and processing, extract, transform, and load (ETL), data quality improvements, and reporting. This position is also tasked with developing and testing new data management solutions or consulting with investigative teams to solve problems for specific projects., 2. * Please describe your level of expertise with relational databases and web-based content management systems. (Open Ended Question)

1. • Do you have experience with Extract Transform and Load (ETL) automation to create research-specific data marts (e.g., diabetes patient population database)? + Yes + No
2. • Do you have experience planning and executing data curation workflows for clinical/health-related data? + Yes + No
3. • Please briefly describe your experience collaborating with other researchers and principal investigators in the development and execution of clinical and translational research projects. (Open Ended Question)
4. • What are your strengths as a data analyst? (Open Ended Question)

Masters’ and 2-4 years’ experience; or Bachelors and 3-5 years’ experience; or will accept a combination of related education and experience in substitution., Three years of relevant work experience Knowledge of relational database systems such as Oracle, MS-SQL, MySQL, etc Programming skills in R and/or Python Experience with electronic health record data ( Demonstrable past experience in scoping technical projects in terms of length of time, competencies and cost. Preferred Qualifications, Competencies, and Experience Experience with cloud computing Strong computational skills as evidenced by completed projects and developed software, tools, and systems Experience with ETL and data transformation Experience with common data models (such as OMOP, PCORNet, TriNetx, ACT), terminologies, and standards for electronic health record data Experience performing research data management and familiar with and HIPAA compliance Past experience working with faculty in an academic research environment., 1. * Please select the response below that describes your level of education that best or mostly closely satisfies the education requirements for this position.

• Bachelor’s degree in required discipline(s) listed or related field
• Bachelor’s degree in any field/discipline
• Master’s degree or Doctorate degree in required discipline(s) listed or related field
• Master’s degree or Doctorate degree in any field/discipline

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. Primary Purpose of Organizational Unit Our mission is to improve the health and well-being of North Carolinians and others whom we serve. We accomplish this by providing leadership and excellence in the interrelated areas of patient care, education and research.

Patient care: We promote health and provide superb clinical care while maintaining our strong tradition of reaching underserved populations and reducing health disparities across North Carolina and beyond.

Education: We prepare tomorrow`s healthcare professionals and biomedical researchers from all backgrounds by facilitating learning within innovative and integrated curricula and team-oriented interprofessional education to ensure a highly skilled workforce.

Research: We develop and support a rich array of outstanding health sciences research programs, centers and resources. We provide infrastructure and opportunities for collaboration among disciplines throughout and beyond our university to support outstanding research. We foster programs in the areas of basic, translational, mechanistic and population research.