Data Engineer

3 weeks ago


Baltimore, United States Johns Hopkins Medicine Full time

**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


  • Data Engineer

    3 weeks ago


    Baltimore, United States eTeam Full time

    Job Description : Data Engineer (Advance level 6 -10 years) Support and optimize data engineering workflows with data in Snowflake and Azure cloud environments and prepare data for use in PowerBI visualizations. Job Responsibilities : Assist with migrating data using ETL tools to Snowflake and optimizing queries in Snowflake Assist analysts with...

  • Data Engineer

    5 days ago


    Baltimore, United States eTeam Full time

    Job Description : Data Engineer (Advance level 6 -10 years) Support and optimize data engineering workflows with data in Snowflake and Azure cloud environments and prepare data for use in PowerBI visualizations. Job Responsibilities : Assist with migrating data using ETL tools to Snowflake and optimizing queries in Snowflake Assist analysts with...

  • Data Engineer

    2 weeks ago


    Baltimore, United States eTeam Full time

    Job Description : Data Engineer (Advance level 6 -10 years) Support and optimize data engineering workflows with data in Snowflake and Azure cloud environments and prepare data for use in PowerBI visualizations. Job Responsibilities : Assist with migrating data using ETL tools to Snowflake and optimizing queries in Snowflake Assist analysts with complex...

  • Lead Data Engineer

    3 weeks ago


    Baltimore, United States Ryan Specialty Full time

    Press Tab to Move to Skip to Content Link Select how often (in days) to receive an alert: JOB SNAPSHOT: Employee Type: Full-Time Location: Hunt Valley, MD, US, 21030 Job Type: Information Technology Secondary Location: Years of Experience: Ryan Specialty is looking for a Lead Data Engineer to join our Chicago, IL team. We are a fast-paced, energetic, and...

  • Lead Data Engineer

    2 weeks ago


    Baltimore, United States Ryan Specialty Full time

    Press Tab to Move to Skip to Content Link Select how often (in days) to receive an alert: JOB SNAPSHOT: Employee Type: Full-Time Location: Hunt Valley, MD, US, 21030 Job Type: Information Technology Secondary Location: Years of Experience: Ryan Specialty is looking for a Lead Data Engineer to join our Chicago, IL team. We are a fast-paced, energetic, and...

  • Data Engineer

    3 weeks ago


    Baltimore, United States System One Holdings, LLC Full time

    Data Engineer - 7 month contract Fully Remote | Must be able to work 8am - 5pm MST Job Description Summary: The ideal candidate will possess a strong foundation in data engineering principles and technologies, with a proven ability to design build and maintain robust data pipelines and architectures. Duties Shall Generally Include: Building and visualization...

  • Data Engineer

    1 week ago


    Baltimore, United States TAYS INC Full time

    Job DescriptionJob DescriptionTAYS is seeking a Data Engineer to join our high-performing tech team based in Woodlawn, MD. At TAYS, every team member is vital. We recognize and celebrate diverse insights, believing they fuel our innovative spirit. We are not just tech-savvy; we are people-centric. Here, you will work closely with our clients, forging lasting...

  • Data Engineer

    3 weeks ago


    Baltimore, United States Space Telescope Science Institute Full time

    The Space Telescope Science Institute (STScI) is a multi-mission science operations center for NASA’s flagship observatories. Our world-class astronomical research center is based on the Johns Hopkins University Homewood campus in Baltimore, Maryland. Visit our website to learn more about our missions. This position can support hybrid work. Candidates must...

  • Data Engineer

    2 weeks ago


    Baltimore, United States MindPal Full time

    We are looking for experienced Data Engineers with knowledge of Snowflake platform. Responsibilities Creating and managing data in the Snowflake environment Designing and implementing ETL (Extract, Transform, Load) solutions for transferring data between various sources and platforms Optimizing the performance of Snowflake databases, including designing and...

  • Data Engineer

    4 weeks ago


    Baltimore, United States Bridgeway Benefit Technologies Full time

    We are seeking a Data Engineer to join our growing Professional Services organization, who will be responsible for converting customer data onto our enterprise software platform. This position involves extensive data analysis, development of solutions via ETL to migrate data to our software and establishing new best practices for high complexity conversions....

  • Data Engineer

    2 weeks ago


    Baltimore, United States Bridgeway Benefit Technologies Full time

    We are seeking a Data Engineer to join our growing Professional Services organization, who will be responsible for converting customer data onto our enterprise software platform. This position involves extensive data analysis, development of solutions via ETL to migrate data to our software and establishing new best practices for high complexity conversions....

  • Data Engineer

    3 weeks ago


    Baltimore, United States Bridgeway Benefit Technologies Full time

    Job DescriptionJob DescriptionWe are seeking a Data Engineer to join our growing Professional Services organization, who will be responsible for converting customer data onto our enterprise software platform. This position involves extensive data analysis, development of solutions via ETL to migrate data to our software and establishing new best practices...

  • Data Engineer

    1 week ago


    Baltimore, United States Bridgeway Benefit Technologies Full time

    Job DescriptionJob DescriptionWe are seeking a Data Engineer to join our growing Professional Services organization, who will be responsible for converting customer data onto our enterprise software platform. This position involves extensive data analysis, development of solutions via ETL to migrate data to our software and establishing new best practices...

  • AWS Data Engineer

    1 week ago


    Baltimore, United States Meritore Full time

    Job DescriptionJob DescriptionTitle: Data EngineerLocation: Baltimore, MD12+ Months ContractPROJECT OVERVIEW50% BA / 50% DAStrong SQL skills needed.Should be able to query data.Should be able to gather and document requirements in JIRA.Multifamily business-related data Loans, mortgages, tenants, etc.Will be part of Scrum Team Product Owners, Developers, Data...


  • Baltimore, United States Capital One Full time

    Center 2 (19050), United States of America, McLean, Virginia Senior Lead Data Engineer Do you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-paced, collaborative, inclusive, and iterative delivery environment? At Capital One, you'll be part of a big group of makers, breakers, doers and...


  • Baltimore, United States Mackinnon & Partners Full time

    As a Senior Mechanical Data Center Engineer with us, you will design complex cooling and HVAC systems including air distribution systems, chiller, and alternative energy solutions for mission-critical facilities. Your ImpactIndependently support the project team during the design and construction stages of projects,Design air distribution, hydronic, and...


  • Baltimore, United States Mackinnon & Partners Full time

    As a Senior Mechanical Data Center Engineer with us, you will design complex cooling and HVAC systems including air distribution systems, chiller, and alternative energy solutions for mission-critical facilities. Your ImpactIndependently support the project team during the design and construction stages of projects,Design air distribution, hydronic, and...


  • Baltimore, United States Mackinnon & Partners Full time

    As a Senior Mechanical Data Center Engineer with us, you will design complex cooling and HVAC systems including air distribution systems, chiller, and alternative energy solutions for mission-critical facilities. Your ImpactIndependently support the project team during the design and construction stages of projects,Design air distribution, hydronic, and...


  • Baltimore, United States Mackinnon & Partners Full time

    As a Senior Mechanical Data Center Engineer with us, you will design complex cooling and HVAC systems including air distribution systems, chiller, and alternative energy solutions for mission-critical facilities. Your ImpactIndependently support the project team during the design and construction stages of projects,Design air distribution, hydronic, and...


  • Baltimore, United States Mackinnon & Partners Full time

    As a Senior Mechanical Data Center Engineer with us, you will design complex cooling and HVAC systems including air distribution systems, chiller, and alternative energy solutions for mission-critical facilities. Your ImpactIndependently support the project team during the design and construction stages of projects,Design air distribution, hydronic, and...