Share this Job

 
Duke University and Duke University Health System require all students, faculty and staff to receive the COVID-19 and influenza vaccines.  After you have officially accepted a position at Duke, you may request a religious or medical accommodation.

IT Analyst-Full Time-Population Health-Connected Care-Duke Health-Durham

Requisition Number::  155172
Date:  May 17, 2022
Location: 

Durham, NC, US, 27710

Personnel Area:  DIN/Connected Care

Duke Connected Care, a community-based, physician-led network, includes a group of doctors, hospitals and other healthcare providers who work together to deliver high-quality care to Medicare Fee-for-Service patients in Durham and itssurrounding areas.

 

Location: 

Durham, North Carolina 

 

 

Work Hours:

Standard business hours 

 

General Description 

The IT Analyst Sr,-ETL Developer is responsible for design, implementation, and maintenance of ETL development to meet the analysis and reporting needs for Duke’s Population Health Management Office (PHMO). Preferable for this role to have additional .NET programming skills to assist in maintenance and enhancement of existing web applications (ASP.Net MVC) and other .Net applications.

The PHMO department is the central entity within Duke Health responsible for the administrative and care management aspects of Duke’s value-based care contracts. This position will reside on the PHMO Data & Analytics team, reporting to the Data Engineering team lead. This position is responsible for ensuring each solution is extensible, adheres to internal and/or industry standards, and operates with minimal manual interference.

 

Duties and Responsibilities

 

  • · Design and document effective, expandable, and efficient ETL processes for new database subject areas
  • · Ensure solutions are aligned with business and IT strategies and comply with the organization's architectural standards.
  • · Develop, implement and maintain schedule/dependency logic for automated ETL processing.
  • · Develop monitoring, logging, and error notification processes to ensure data is updated as expected and processing metrics reported.
  • · Participate in the creation and maintenance of standards for coding, documentation, error handling, error notification, logging, etc.
  • · Accountable for conforming to established architectural, developmental, and operational standards and practices including creation of ETL metadata.
  • · Work with other team members in establishing and sharing design and development techniques of the ETL process.
  • · Assist in the maintenance and administration of applications and software used by the PHMO Data and Analytics team
  • · Evaluate and recommend database development tools
  • · Assist in application and database performance tuning
  • · Participate in system architecture design
  • · Effectively communicate issues or project status updates with customers, team members, and/or IT management.
  • · Identify and enforce data standards or best practices to ensure consistent and maintainable structures in the database.
  • · Assist with maintenance and troubleshooting issues
  • · Serve as a technical resource for discipline in cross-functional teams.
  • · Individual contributor that works under limited supervision, who can perform and coordinate simple to complex projects with minimal direction.
  • · Maintain a level of exposure to external industry and market technical intelligence

 

Knowledge, Skills and Abilities:

  • 3+ years of experience SQL, or an equivalent combination of relevant education and/or experience.
  • Bachelor's degree in a related field, or four years of equivalent technical experience required
  • Strong knowledge and experience in creating SSIS packages for complex ETL processes with various sources such as Flat files, SQL server, Oracle, XML, Microsoft Excel, JSON etc. ·
  • Working knowledge of complex SQL in Microsoft SQL Server, PL-SQL, with SQL Server Reporting Services a plus ·
  • Working knowledge of .Net scripting within SSIS a plus. · .NET programming skills a plus, including o Strong working knowledge of object-oriented programming within the .NET framework using C#, ASP.Net, MVC architecture, Entity Framework, LINQ, etc. o Strong working knowledge of scripting languages (JavaScript, JQuery, etc.)
  •  Experience with web security, multi-user/multi-level application access setup and configuration ·
  • Excellent analytical and problem-solving ability required
  •  Knowledge and experience in relational and dimensional database design techniques
  • Proven ability to produce logical flows to support the design of data solutions
  • Ability to produce data flow diagrams to show data lineage · Knowledge of Entity Relationship (ER) Diagrams
  • Thorough understanding of data modeling
  • Highly self-motivated and self-directed
  • Strong organizational skills with attention to detail · Solid and effective written, interpersonal, oral and presentation skills

 

 

Minimum Qualifications

 

 

Education

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.

 


Nearest Major Market: Durham
Nearest Secondary Market: Raleigh