School of Medicine

Established in 1930, Duke University School of Medicine is the youngest of the nation's top medical schools. Ranked sixth among medical schools in the nation, the School takes pride in being an inclusive community of outstanding learners, investigators, clinicians, and staff where interdisciplinary collaboration is embraced and great ideas accelerate translation of fundamental scientific discoveries to improve human health locally and around the globe. Composed of more than 2,600 faculty physicians and researchers, nearly 2,000 students, and more than 6,200 staff, the Duke University School of Medicine along with the Duke University School of Nursing, and Duke University Health System comprise Duke Health, a world-class academic medical center. The Health System encompasses Duke University Hospital, Duke Regional Hospital, Duke Raleigh Hospital, Duke Health Integrated Practice, Duke Primary Care, Duke Home Care and Hospice, Duke Health and Wellness, and multiple affiliations.

Position Summary

The Sr. Analyst, IT - Data Architect is responsible forproviding business intelligence (BI) subject matter expertise to the DCRI. This role will require to work closely with key stakeholders, collect requirements, and produce deliverables in the form of data acquisition to semantic layer design, data reports, dashboards, or raw datasets that will be used to drive business decisions. This Data Architect will ensure accuracy, accessibility, and security of data relevant to the organization and clinical research projects. The Data Architect will mentor staff and collaborate with cross-functional teams to deliver efficient, effective and reusable solutions. He/she will help to achieve the growth and use of BI at the DCRI, meet project objectives and maintain data engineering best practices.

As a member of the Data Analytics & Insights team, this Data Architect will join IT professionals with a broad knowledge of the healthcare industry including regulatory reporting and compliance and healthcare IT. The Data Architect will be part of a collaborative IT service delivery team intent on providing exceptional client service to meet overall DCRI objectives.

** NOTE: This position may have an opportunity to work remotely. All Duke University and Duke Health remote workers must reside in one of the following states or districts: Arizona; California; Florida; Georgia; Hawaii; Illinois; Maryland; Massachusetts; Montana; New Jersey; New York; North Carolina; Pennsylvania; South Carolina; Tennessee; Texas; Virginia or Washington, DC., Washington (State), Connecticut

Position Responsibilities

• Design and implement end-to-end data solutions, including data ingestion, storage, processing, and visualization on the Microsoft Azure cloud platform, focusing on scalability, security, and efficiency to support business objectives.
• Act as a liaison with the cloud architects/engineers and ensure data engineering best practices are supported by optimizing the cloud infrastructure.
• Establish and promote best practices for the data framework across enterprise data and clinical research data and implement data operation standards.
• Provide guidance and direction for business intelligence capabilities for the DCRI
• Lead efforts in data mining and analytics in support of BI efforts and projects for the organization; continually look for opportunities to diversify and draw from multiple disparate data sources, both structured and unstructured
• Identify and apply BI tools and software to perform data engineering and data analysis.
• Prepare and develop reports, presentations and other documents for communicating findings to business owners and management.
• Balance project timeliness; maintain overall quality across multiple projects and consultations; complete ad hoc analytical requests within agreed upon time
• Monitor and troubleshoot data processing systems, optimizing performance and cost.
• Assist the new proposals and projects intake process with design, architecture and budget.
• Perform other duties as assigned

Education and Experience

BA or BS Degree in Analytics, IT or other relevant field and 5 years related experience, or equivalent combination of education and experience

• 5+ years combined experience in healthcare business data management, business intelligence or IT consulting
• Experience in healthcare business intelligence (experience with CRO/Academic CRO preferred), data transformation/data modeling, metadata management, data security, data warehouse/data mart
• Experience with cloud platform and ETL tools such as Informatica, Microsoft Azure Synapse, SAS; hands on experience with Microsoft Azure platform a plus.
• Implementation experience and certification with top tier business intelligence platforms experience a plus
• Excellent problem-solving skills and the ability to work independently or as part of a team.
• Strong communication skills, capable of effectively articulating technical solutions to non-technical stakeholders

Skills, Training and Certifications

• Strong knowledge of healthcare business intelligence thought leadership a plus
• Top performer and role model in delivering exceptional client service in the healthcare industry
• Working knowledge with query, extract, transformation and load (ETL) from common database platforms and cloud technology (Microsoft SQL Server, Oracle, etc) required
• Successful track record of defining requirements, developing system design and architecture, system configuration, testing and deployment

Refer to Job Description

Duke is an Affirmative Action/Equal Opportunity Employer committed to providing employment opportunity without regard to an individual's age, color, disability, gender, gender expression, gender identity, genetic information, national origin, race, religion, sex, sexual orientation, or veteran status.

Duke aspires to create a community built on collaboration, innovation, creativity, and belonging. Our collective success depends on the robust exchange of ideas-an exchange that is best when the rich diversity of our perspectives, backgrounds, and experiences flourishes. To achieve this exchange, it is essential that all members of the community feel secure and welcome, that the contributions of all individuals are respected, and that all voices are heard. All members of our community have a responsibility to uphold these values.

Essential Physical Job Functions: Certain jobs at Duke University and Duke University Health System may include essentialjob functions that require specific physical and/or mental abilities. Additional information and provision for requests for reasonable accommodation will be provided by each hiring department.