The site navigation utilizes arrow, enter, escape, and space bar key commands. Left and right arrows move across top level links and expand / close menus in sub levels. Up and Down arrows will open main level menus and toggle through sub tier links. Enter and space open menus and escape closes them as well. Tab will move on to the next part of the site rather than go through menu items.
.Net Developer - Population Health - Duke Connected Care - Hybrid
Duke University Health System
Location: Durham, North Carolina
Internal Number: 227322
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.
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; Colorado; Florida; Georgia; Hawaii; Illinois; Maryland; Massachusetts; Montana; New Jersey; New York; North Carolina; Pennsylvania; South Carolina; Tennessee; Texas; Virginia; or Washington, DC.
The Senior IT Analyst - 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
Required Qualifications at this Level
Bachelor's degree in a related field, or four years of equivalent technical experience required
3+ years of experience SQL, or an equivalent combination of relevant education and/or experience.
Knowledge, Skills, and Abilities:
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:
Strong working knowledge of object-oriented programming within the .NET framework using C#, ASP.Net, MVC architecture, Entity Framework, LINQ, 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
The intent of this job description is to provide a representative and level of the types of duties and responsibilities that will be required of positions given this title and shall not be construed as a declaration of the total of the specific duties and responsibilities of any particular position. Employees may be directed to perform job-related tasks other than those specifically presented in this 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.
As a world-class academic and health care system, Duke Health strives to transform medicine and health locally and globally through innovative scientific research, rapid translation of breakthrough discoveries, educating future clinical and scientific leaders, advocating and practicing evidence-based medicine to improve community health, and leading efforts to eliminate health inequalities.