Data Engineer

**Data Engineer (Epic Data Warehouse)**

**Requisition #:** 415805

**Location:** Johns Hopkins Hospital, Baltimore, MD 21201

**Category:** Information Technology

**Work Shift:** Day Shift

**Work Week:** Full Time

**Weekend Work Required:** Yes

**Date Posted:** Sept. 22, 2021

Johns Hopkins Health System employs more than 20,000 people annually. Upon joining Johns Hopkins Health System, you become part of a diverse organization dedicated to its patients, their families, and the community we serve, as well as to our employees. Career opportunities are available in academic and community hospital settings, home care services, physician practices, international affiliate locations and in the health insurance industry. If you share in our vision, mission and values and also have exceptional customer service and technical skills, we invite you to join those who are leaders and innovators in the healthcare field.

**Position Summary:**

Reports to the Epic Data Warehouse manager and is responsible for the design, deployment, standards, and performance of the enterprise-wide Electronic Medical Record data architecture. This position plays an important role supporting the implementation of the enterprise strategy to leverage the EMR data assets by collaborating closely with leadership. It is important for this role to understand the information and integration needs, source systems, quality standards, report and analytic requirements, and the EMR data itself to support centralized and decentralized development of institutional and business intelligence content. Serves as a specialist/consultant on complex projects.

Responsible for business analysis and systems architecture related to business intelligence and data warehousing projects, including data integration, reporting, and analytics to support the health system objectives. Develops and validates the creation and maintenance of enterprise data definitions and metadata. Aligns enterprise data architecture and design with business needs and strategies. Conducts user interviews, facilitates modeling sessions, writes business and technical requirements, creates standards and best practices, designs solutions and implements development. Participates in project planning to ensure effective use of technology and/or business process to meet customers needs. Establishes and monitors project and task schedules and ensures adherence to work deadlines. Provides leadership, motivation, and direction to staff, builds teamwork, and fosters staff cohesion. Contributes to staff evaluations.

**Job Responsibilities:**

The primary responsibility of the Data Engineer is to design and deploy data models to support Tableau and other data visualization projects. This may involve extending the data warehouse with external data to meet business needs. To achieve this the Data Engineer will:

DESIGN, DEVELOPMENT, and DEPLOYMENT

- Design and deliver guidelines that allow a broad base of internal and external developers to build content sourced in the data warehouse while adhering to established standards and strategy.

- Perform discovery to understand process flows and impact on how data is generated, normal data values and potential reasons for anomalies.

- Understand requirements for data, information, reporting, and analytic needs to ensure alignment with Epic data warehouse architecture and data models.

- Support the translation of business and technical objectives into solution architecture requirements, and data architecture designs to deliver Tableau applications.

- Collaborate with the vendor Epic to design and implement scalable and extensible data architectures.

- Provide experienced leadership for strategic planning in designing and developing comprehensive, innovative and integrated solutions. Oversee and mentor junior staff by reviewing tasks and milestones for quality standards and provide guidance in system/application design and development.

- Develop database objects such as data marts cubes, queries, stored procedures, views and tables required to support appropriate levels of reporting and security.

- Develop, manage and maintain standards for the enterprise data model. Partner in the development, management, establishment, and enforcement of technical standards.

- Develop detailed tasks and project plans by analyzing project scope and milestones for highly complex projects in order to deliver product in a timely fashion according to lifecycle standards.

- Integrate multiple cross-functional processes and disciplines to meet business and technical requirements by bringing perspective from all architecture domains (process, system, application information, data, and security).

- Identify areas for data quality improvement by participating in root cause analysis. Make recommendations to prevent and remediate data quality issues through the appropriate choice of architectures and practices.

- Incorporate standards for gathering requirements for aggregate navigation, response time, repeatable queries, row level security etc. into data warehouse design.

- Assist with troubleshooting and tuning of business intelligence reports.

IMPLEMENTATION AND MAINTENANCE

- Monitor changes and resolve highly complex problems requiring the highest level of technical expertise by responding as problems arise. Accomplish this by reviewing all processing and output of the newly implemented solution, and by proactively ensuring the solution works successfully in order to satisfy the customer requirements and to provide a smooth transition to the new solution.

- Oversee changes by adhering to the change management policies and procedures for any given project to communicate to all parties the nature, significance, and risk factors of the solution.

- Recommend and advocate for data policies, governance structures and control frameworks for the ongoing management of data to ensure convergence, synchronization, accuracy, completeness and reliability.

- Make recommendations for optimization and performance improvements to database design, as well as improvements to ETL processes and tuning of software and hardware for existing and projected needs. Work with source system owners to establish and measure data quality metrics, investigate and resolve source data issues, and continuously evaluate and refine transformation rules.

- Define roles and responsibilities for centralized and decentralized data management functions.

STRATEGY/LEADERSHIP

- The ability to embrace change, adapt to the unexpected, and focus energies, people, and solutions on practical and positive results Strong written and oral communication skills to effectively lead change, and communicate with business and IT staff.

- Develop guiding principles, standards, and best practices consumed by Epic Reporting and Analytic teams.

- Collaborate with, and frequently lead, other technical experts, architects and subject matter experts to contribute technology elements with a focus on BI technologies for the enterprise.

- Address highly complex problems by meeting with clients to observe and understand current processes and the issues related to those processes. Provide written documentation of findings to share with the client and other IT colleagues.

- Track a broad range of emerging technologies to:

- Determine their maturity and applicability to the enterprise

- Assess the relative impact to IT strategy and interprets meaning to senior IT leadership team

- Lead and manage strategic activities, including adoption of enterprise products and continuous integration strategies

**Required Education:**

Bachelors degree in Computer Science or related field of study. Masters Degree, preferred. May substitute work experience where appropriate. Technical certifications in Epic Clarity and Caboodle, preferred.

**Required Experience:**

Six years of work experience with computer systems and applications. Requires demonstrated experience in developing ER a