DHTS DEVELOPER - Level 1

DHTS Position Description:  Developer for the Duke Transplant Center

POSITION DESCRIPTION

Working Title: Developer

Department: DHTS/ACE/DART

Primary Role

The Developer functions as a data and reporting expert for the Duke Transplant Center to understand the data needs and to provide expert consultation on available tools, design options, and relevant data elements.   Brainstorm with functional teams and recommend optimal ways to collect, store, retrieve, and analyze the data.  Able to translate business requirements, write SQL code and identify appropriate reporting tools. This person will be involved in the selection, manipulation, integration, and analysis of data from a variety of data sources.

Education/training

Bachelor's degree, or four years of equivalent technical experience required

Required Experience

• Experience in understanding functional requirements, data analysis, SQL, and report development and reporting applications.

Required Skills

• Solid and effective written, interpersonal, oral, and presentation skills
• Understanding of relational and dimensional data models
• Proven ability to produce logical flows to support the design of data solutions
• Proven ability to describe technical solutions to non-technical audiences
• Ability to produce data flow diagrams that can easily show data lineage
• Data sourcing, data mapping
• Experience and knowledge in developing complex SQL scripts in various RDBMS environments
• Healthcare/Research industry experience preferred
• Ability to effectively work on a team.
• Able to identify tools relevant to develop the right solution to meet customer data needs. Available tools include but are not limited to: Clarity, Reporting Workbench, Radar Dashboards, Registries and Universes, Business Objects Crystal, WEBi, Tableau, and SQL. This requires an understanding of the strengths and limitations of each tool set.
• Understand and follow all established guidelines with respect to development, migration of data through environments to Production, and maintenance. Ensure that all data deliverables conform to established departmental standards; specifically, change management processes, reporting naming conventions, and maintenance of the enterprise reporting library.

LEVEL 1:

• Individual contributor representing the most common entry point for this career ladder; works under direct supervision.
• Demonstrates knowledge and proven application of knowledge within a specific discipline(s).
• Completes tasks and portions of larger projects, identifying internal resources to build project team capabilities.
• May function in a cross-team environment.

LEVEL 2:

• Individual contributor that works under limited supervision. Applies subject matter knowledge; requires capacity to understand specific needs or requirements to apply skills/knowledge.
• Maintains a level of exposure to external industry and market technical intelligence.
• Performs and coordinates simple to complex projects with minimal direction.
• Review, understand, and document the current operational processes and data sources to establish support for current and future reporting requirements.
• Develop design documents for data mapping and data transformation processes.

• Identify and enforce data standards to ensure consistent and maintainable structures in the data warehouse.
• Perform source system analysis and data profiling.
• Work with Data Modelers and ETL Developers to develop logical data model(s) and introduce structures for the data warehouse
• Create SQL as needed for projects to work with data already in the Data Warehouse
• Consult with customers to assist with SQL and data concerns.

The information above describes the general nature and level of work assigned to this position. It is not intended to be an exhaustive list of all duties and responsibilities required of position incumbents.

Duke University is an Affirmative Action/Equal Opportunity Employer committed to providing employment opportunities 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 essential job 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.

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.