Data Warehouse Developer
Duke Health Technology Solutions is a robust, specialized division of Duke University Health System dedicated to the development and management of enterprise IT systems. A 2018 ‘Most Wired’ health system, Duke is nationally recognized for IT and information management as the first healthcare system to achieve the Davies Award – highest honor by the Healthcare Information and Management Systems Society (HIMSS) – for inpatient, ambulatory and analytics health information technology capabilities. Our employees are among the top-skilled IT experts in the Triangle and partner with leading scholars, clinicians and researchers across Duke University and Duke Health to develop innovative technologies that support our mission of delivering tomorrow's healthcare today.POSITION DESCRIPTION Working Title: Data Warehouse Developer Department: DHTS/ACE/DART/PORT Primary Role Brainstorm with functional teams and recommend optimal way to collect, store, retrieve and analyze the data. Translate business requirements into code and documentation. Develop metadata definitions from the business rules. This person will be heavily involved in selection, manipulation, integration and analysis of data from variety of sources. Level 2 - 5+ year’s experience in requirements gathering, data analysis, SQL and report development
- 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 document for data mapping and data transformation processes. Develop metadata for structures in the data warehouse.
- 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.
- 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 and managing metadata Experience and knowledge in developing complex SQL scripts in various RDBMS environments Thorough understanding of Data Modeling, including ER and Dimensional models Healthcare/Research industry experience preferred Ability to effectively work on a team.
Required Qualifications at this Level
Bachelor's degree in a related field, or four years of equivalent technical experience required.
None required. Preferred certification in development technologies, as appropriate for the position.
Experience: Level 2 - Two years of directly related experience is required.
Skills: Level 2:
In addition to the KSAs described for the Level 2 will demonstrate:
Comprehensive understanding of underlying technologies that support the application.
Comprehensive understanding of the deployment process and methodologies. Extensive knowledge of one or more multiple frameworks and high-level programming languages.
Ability to write software that optimizes leverage of the underlying technologies (e.g., Phusion, TCP, sockets).
Comprehensive understanding of common algorithms and patterns and ability to apply them appropriately.
Strict adherence to agreed-upon coding standards.
Demonstrated proficiency in refactoring code and developing reusable functions/objects.
Ability to design systems that span multiple technologies/platforms.
Ability to write technical documentation describing system architecture, including functional and technical specifications.
Demonstrated ability to coach more junior members of the team in a constructive manner.
Ability to complete tasks with minimal oversight that are normal in scope.
Job Code: 00003840 DHTS DEVELOPER
Job Level: CD
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 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.