IT Data Analyst 2

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 UNC School of Medicine has a rich tradition of excellence and care. Our mission is to improve the health and wellbeing 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. We strive to promote faculty, staff, and learner development in a diverse, respectful environment where our colleagues demonstrate professionalism, enhance learning, and create personal and professional sustainability. We optimize our partnership with the UNC Health System through close collaboration and commitment to service.
OUR VISION
Our vision is to be the nation's leading public school of medicine. We are ranked 2nd in primary care education among all US schools of medicine and 5th among public peers in NIH research funding. Our Allied Health Department is home to five top-ranked divisions, and we are home to 18 top-ranked clinical and basic science departments in NIH research funding.
OUR MISSION
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 will 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 will prepare tomorrow's health care professionals and biomedical researchers by facilitating learning within innovative curricula and team-oriented interprofessional education. We will cultivate outstanding teaching and research faculty, and we will recruit outstanding students and trainees from highly diverse backgrounds to create a socially responsible, highly skilled workforce.
Research: We will develop and support a rich array of outstanding health sciences research programs, centers, and resources. We will provide infrastructure and opportunities for collaboration among disciplines throughout and beyond our University to support outstanding research. We will foster programs in the areas of basic, translational, mechanistic, and population research.

The Department of Genetics is seeking an experienced IT Business Intelligence & Data Analyst to join a highly interactive, supportive, and interdisciplinary group of faculty, staff scientists, postdoctoral fellows, and students. This position will contribute to the Department of Genetics' diverse portfolio of research including grant-funded programs, potential commercialization opportunities, and partnerships. The IT Business Intelligence & Data Analyst will leverage data mining and statistical analysis to uncover insights from complex datasets. Responsibilities include designing and maintaining data quality monitoring tools and dashboards, addressing data quality issues, and ensuring compliance with reporting standards. The position involves managing EHR data quality, ensuring data security, and working with business application users to define and meet reporting and analytical needs. The role also includes overseeing the matrix reporting system, managing software and analytics programs, leading technical teams, and handling complex projects. Additional duties involve resource management , communication with senior leadership, and implementing change management procedures while providing training. Flexible work arrangements, including virtual/hybrid work locations, are an integral part of the School of Medicine's Working Forward initiative. As such, this position's work location is designated as virtual. Please note that the designated work location is subject to change based on the unit's business needs.

Master's and 1-2 years' experience; or Bachelors and 2-4 years' experience; or will accept a combination of related education and experience in substitution.

Data Analyst Experience is requiredExperience in oversight of data analysis projects

Contributions to research as evidenced through the development and dissemination of software, data and knowledgebases, preprints, and/or publications Experience building complex software systems using microservices and cloud-native technologies. Docker experience is a plus. Demonstrated ability to work on multiple large-scale collaborations that include a wide variety of domain experts. Experience programming in the following languages: Python, Java/JavaScript. Familiarity with common relational databases and SQL, which may or may not include experience in UML modeling and object-oriented methodologies; and/or multiple modeling and schema languages. Data and schema harmonization strategies and compliance testing. Familiarity with real-world-data ( RWD) EHRs and clinical data models and standards such as HL7 FHIR, CCD-A, and/or OHDSI OMOP. Experience managing the architecture and flow of data, ensuring accuracy and accessibility. Experience designing and deploying operational data stores such as SQL Server, analytical databases such as Oracle, and a metadata repository.

Experience designing stored procedures, implementing, and supporting user defined functions in SQL Server Management studios. Proficiency with integrated development environments (IDEs), e.g. with Jupyter notebooks or R markdown. Experience with test-driven development and Continuous Integration/Continuous Deployment (CI/CD), for example with GitHub Actions, Jenkins, etc. Experience with visualization tools like Tableau, Power BI, observable

The University of North Carolina at Chapel Hill is an equal opportunity and affirmative action employer. All qualified applicants will receive consideration for employment without regard to age, color, disability, gender, gender expression, gender identity, genetic information, national origin, race, religion, sex, sexual orientation, or status as a protected veteran.