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 2021 '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.
Occupational Summary
The IT Analyst for Maestro Care ETL Admin demonstrates knowledge and proven application of knowledge within a specific Information Technology discipline(s). Incumbent is responsible for monitoring, managing, and updating the Clarity, Caboodle, and SlicerDicer applications as it relates specifically to the extract, transform, and load processes.
Work Performed
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.
Proactively complete assigned Maestro Care application deployment(s), management and testing tasks within defined timeline
Manage the documentation, resolution and completion of identified deployment issues and tasks
Participate in identified development and production support meetings, reviews, and design sessions, as assigned
Build, test, and debug Epic application(s) to ensure the system meets end user requirements as agreed upon
Develop and document system and user procedures as necessary within Service Now
Adhere to organizational policies and procedures and follow all change control processes defined within Maestro Care
Provide both business and after hours support for issues around system production support including the analysis, prioritization and implementation of requested changes, analysis of new functionality, coordination of software release updates, system testing and interface enhancements
Maintenance, monitoring, and updating of extract processes from Chronicles to Clarity
Maintenance, monitoring, and updating of extract processes from Clarity to Caboodle
Maintenance, monitoring, and updating the SlicerDicer application
Manage and support multiple EMR Production and non-Production reporting environments
Monitor and troubleshoot Clarity and Caboodle nightly, weekly, and custom processes, utilize appropriate procedures for addressing data load issues
Ensure integrity of reporting database and associated load processes
Perform troubleshooting analysis and problem resolution as it relates to extract, transform, and load processes
Plan, execute and support testing activities
Other duties as assigned
LEVEL 2:
In addition to the responsibilities described above, the Level 2 is responsible for:
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.
Optimizes internal resources to maximize team capabilities.
Leads peers to resolve complex issues consistent with divisional/organizational goals.
Serve as technical resource for discipline in cross-functional teams.
Effectively communicates specific IT issues/solutions to clients.
Required Qualifications at this Level
Education/Training:
Bachelor's degree in a related field, or four years of equivalent technical experience required.
CERTIFICATION:
The employee hired for this position will be required complete Epic certification through a formal training program requiring attendance at the training facilities in Verona, Wisconsin. Training will include classroom instruction, project assignments, competency exams, and e-learning classes. Cogito Tools Administration Certification will be required.
Experience:
Level 1 - One year of related experience is required.
Level 2 - Three years of related experience is required.
For all levels, Duke Health System experience and/or IT system deployment experience preferred
Skills:
LEVEL 1:
Experience with database systems
High degree of competency with learning and interpreting IT systems
Strong communication, interpersonal and team skills
Prefer knowledge and experience in health care information systems
Prefer knowledge of Epic clinical data and experience supporting Meaningful Use reporting
Strong working knowledge of Database Management tools, such as Oracle Enterprise Manager and Microsoft SQL Server Management Studio
Demonstrated written, verbal and follow-up skills
Prefer Experience with Oracle Databases
Prefer Experience with Microsoft SQL Server
Prefer Experience with KB SQL
Prefer UNIX operating system experience
Prefer Windows Server administration experience
Prefer knowledge of supporting report writers and report users of Epic systems
Prefer knowledge of creating triggers, views, and stored procedures
Keeps current on new industry trends in a specific discipline and applies learnings to assignments.
Takes personal responsibility for taking actions on projects that result in solutions that truly address customer needs.
Understands when to request supervisor involvement in programming related matters.
Considers impact to others and current processes within discipline prior to taking action.
Adapts individual work style and reprioritizes assignments as changes in department or project goals or requirements are communicated.
Independently completes complex tasks and portions of larger projects.
Identifies and uses appropriate resources to accomplish tasks and build individual and team knowledge.
Suggests new approaches to accomplishing individual responsibilities or team assignments.
Accomplishes assignments/project objectives through keeping people focused on the solution and the team informed of project status.
Shares information and solicits input and ideas from other team members.
Persuades team members to use different work steps/methodologies to accomplish assignments.
Promotes the goals of the initiative, setting aside departmental or functional biases to achieve objectives.
Delivers systems or programs that are completed on time and within budget.
Self-motivated and focused on delivering quality work even when faced with difficulties or over a longer-term project.
Possesses advanced knowledge and proven application of it within a specific discipline.
Provides assistance to project team members in accomplishing technical or programming-specific tasks.
Independently completes complex tasks and portions of larger projects.
Realistically evaluates own progress against expectations/goals and takes necessary actions to address developmental needs or performance issues.
Develops realistic project plans for assigned tasks or portions of larger projects and modifies plan as requirement changes are communicated.
Obtains necessary information/data to complete assignments independently or as part of a project team.
Understands client/project issues to develop moderately complex solutions within a single discipline.
Develops strong working relationships with colleagues and/or project team and customers to effectively complete team goals and objectives.
Builds strong working relationships with members of his/her team and interacts and establishes relationships with individuals in other teams or departments as needed.
LEVEL 2:
Proven ability to lead meetings, prioritize, resolve conflicts, maintain issues lists and manage a project plan.
Able to managing large relational database management systems utilizing stored procedures, triggers, and data marts/summary tables with an emphasis on the creation, optimization, and execution of enterprise-wide reporting
Experience supporting data warehouses/data stores and data marts, and extensive experience using SQL query techniques to access and manage Oracle and MS SQL Server databases
Keeps current on industry and market intelligence; applies appropriate new technologies and best practices to specific discipline or functional area.
Adapts/modifies personal and project goals to align with IT priorities.
Uses a variety of communication styles to get (technical) messages across clearly to a variety of audiences through the use of terminology and examples that are familiar.
Displays ability to recognize appropriate communication, audience, timing, and content necessary for building and maintaining alliances for success.
Effectively communicates specific IT issues/solutions to clients.
Develops solutions that help the customer in both the short- and long-term.
Takes personal responsibility for taking or directing actions on projects that result in solutions that truly address customer needs.
Takes action without being prompted to achieve business goals.
Identifies and uses appropriate resources to accomplish projects and build knowledge within a specific discipline or department.
Persuades others to reach conclusions or make decisions regarding complex issues through understanding the ideas, situations, or problems by breaking the issue into small pieces or by identifying causal links or relationships.
Synthesizes data from multiple (appropriate) sources to make sound decisions.
Considers impact on IT goals prior to making decisions.
Implements new approaches, and/or technologies to develop solutions meeting customer's needs.
Promotes goals of the initiative, overcoming departmental or functional biases to achieve objectives.
Delivers systems or projects that are completed on time and within budget.
Ability to motivate and focus self and others to reach long- term project goals even when faced with difficulties.
Possesses expert knowledge and proven application (through developing solutions and efficiencies) of it in a specific discipline or functional area.
Actively seeks out opportunities to share his/her in-depth knowledge and contribute to the learning of other department or team members.
Performs and coordinates simple to complex tasks with direction.
Accepts accountability for decisions, actions, and commitments of self and others to successfully meet project objectives.
Prioritizes and organizes project actions and resources to achieve targeted objectives.
Achieves project objectives through the identification and coordination of the right people to participate in the project initiatives.
Identifies key issues, analyzes cause/effect relationships, and seeks ideas and suggestions from those who can contribute and are affected.
Develops solid working relationships with colleagues, customers, and across project teams to effectively achieve functional/project goals.
Builds strong working relationships with members of his/her team and those within other relevant teams, departments, or disciplines.
Keeps team focused on goals and addresses issues to ensure good working relationships are maintained.
Prefer knowledge of supporting MS IIS and SSL Certificates
Prefer knowledge of supporting Business Objects Enterprise
Prefer knowledge of supporting Epic-Crystal integration
Prefer knowledge of upgrading Clarity, Caboodle, and SlicerDicer to newer Epic version
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.
