BaltimoreRecruiter Since 2001
the smart solution for Baltimore jobs

Epic Data Engineer

Company: The Johns Hopkins Hospital
Location: Baltimore
Posted on: October 13, 2019

Job Description:

Epic Data Engineer (Data Warehouse) Requisition #: 181949
Location: Johns Hopkins Hospital, Baltimore, MD 21201
Category: Information Technology
Work Shift: Day Shift
Work Week: Full Time (40 hours)
Weekend Work Required: Yes
Date Posted: March 5, 2019

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 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:
    Bachelor's degree in Computer Science or related field of study. Master's 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 and dimensional models, data architecture and data warehousing.
    Knowledge, Skills, & Abilities (KSA's):
  • Requires a thorough knowledge of data modeling, data warehouse, data management, and database development in health system operations.
  • Strong technical knowledge of data integration tools, data modeling tools, metadata tools, and database design. Additional knowledge of ETL processes, BI analytics and development strategies, SQL programming, relational databases and ER/dimensional modeling techniques required. Understands the range of options and best practices for common ETL design techniques such as change data capture, key generation and optimization, and performance tuning.
  • Experience with all phases of the Software Development Life Cycle (SDLC). Strong proficiency in SQL programming, query writing, query performance tuning, and database technologies. Ability to distill and articulate technical and organizational approach to clinical data needs. Demonstrated experience in strategic guidance and project creation for data warehousing and business process automation.
    • Proficient analytical ability to solve complex technical problems and lead project work of a diversified staff in a matrix managed groups.
    • Ability to convey technical methods, approaches, and plans to an audience of varying degrees of technical understanding including clinical and business stakeholders and technical team.
    • Ability to manage long-term vendor relationships, including resolution of production issues and upgrades, to guide future product development to meet the needs of the organization.
    • Team player with experience leading and collaborating cross-team to ensure successful delivery of solutions.
    • Translates business and technology requirements into functional and technical specifications to design, develop, and implement relational and dimensional data models.
    • Ability to lead technical and business colleagues via influence and without authority.
    • Deploy and manage data marts with EMR data that aligns with enterprise strategy and related business architecture.
    • Ability to develop operations planning and clinical reports using enterprise level reporting packages (Tableau, Business Objects).
    • Preferred Experience with the following databases, workbenches, and codebases: SQL Server, SQL Server Management Studio, SSIS, Java, C++, PHP, Python, IIS, SharePoint and R.
    • Must be detail oriented, articulate and persuasive to conceive and portray big data picture for the enterprise.
    • Strategic business acumen and understanding of organization strategy, with an ability to design information systems to fulfill that strategy.
    • Train technical and/or other staff in their work processes and competencies. Provides guidance and direction to technical staff. Leads project development.
    • Ability to work on multiple priorities effectively and prioritize conflicting demands.
    • Strong conceptual and analytical skills, demonstrating outside-the-box problem solving skills. Tools/Skills
      • Design Modelling - Designing and developing relational and dimensional models
      • Data Architecture, Scripting, Querying - SQL Server Management Studio, SSIS, SSRS, Views, Stored Procedures
      • BI Visualization - Tableau/Epic RADAR
      • Report Design & Development - SAP Business Objects/Crystal Reports
      • Report Publication - Epic Hyperspace/Epic Crystal Integration Johns Hopkins Health System and its affiliates are drug-free workplace employers.

        Johns Hopkins Health System and its affiliates are an Equal Opportunity / Affirmative Action employers. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity and expression, age, national origin, mental or physical disability, genetic information, veteran status, or any other status protected by federal, state, or local law.

        Company Description:

        Patients are the focus of everything we do at The Johns Hopkins Hospital. From our beginnings in 1889 to the opening of our most advanced patient facilities in 2012, our mission to advance patient care, education, and research, continues to change the course of modern medicine.

Keywords: The Johns Hopkins Hospital, Baltimore , Epic Data Engineer, Engineering , Baltimore, Maryland

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Other Engineering Jobs

Automotive Technician Apprenticeship
Description: Enterprise Holdings has an exciting opportunity for an Automotive Technician Apprentice at our BWI Airport Service Center. The Automotive Technician Apprentice performs general repairs and diagnostics (more...)
Company: Enterprise Rent-A-Car
Location: Hanover
Posted on: 10/21/2019

Manufacturing Engineer
Description: Manufacturing Engineer Coordinates/Works Closely With: Interconnect Operations Manager, Manufacturing Team Leader s ,
Company: Confidential
Location: Baltimore
Posted on: 10/21/2019

Network Engineer - Senior / Mid-Level
Description: 6 years of experience Must have strong experience in Cisco/Juniper switches
Company: Computer Resources of America
Location: Baltimore
Posted on: 10/21/2019

Full Stack Engineer
Description: Oddball is looking for a Full stack engineer with experience developing, testing and debugging new moderately complex software solutions or enhancements to existing software in a maintenance capacity. (more...)
Company: Oddball
Location: Baltimore
Posted on: 10/21/2019

Robotics Engineer
Description: Senior Robotics Software Engineer - Founding Member SGI are working with a large AV company that deploy and service large autonomous driving companies and know a thing or two about robotics technology. (more...)
Company: Source Technology
Location: Baltimore
Posted on: 10/21/2019

Service Technician Nissan
Description: Bob Bell Nissan-- is looking for talented individuals to join our Service Team and we are offering a 2500.00 sign bonus . Family-owned and operated for over 30 years, we have continued to grow while (more...)
Company: Bob Bell Nissan
Location: Baltimore
Posted on: 10/21/2019

Engineering Co-op
Description: These co-op opportunities begin January 2020 through August 2020 and consist of 40 hours per week. Local candidates only. IZI Medical Products is a well-established medical device manufacturer and distributor. (more...)
Company: IZI Medical Products, LLC
Location: Owings Mills
Posted on: 10/21/2019

Deployment Engineer
Description: GP Strategies Corporation NYSE: GPX is a global performance improvement solutions provider of training, eLearning solutions, management consulting and engineering services. GP Strategies solutions improve (more...)
Company: GP Strategies
Location: Columbia
Posted on: 10/21/2019

Sales Engineer
Description: EventTracker Security LLC, a wholly owned subsidiary of Netsurion LLC., is looking to hire a Sales Engineer Technical . This position will be located in Columbia, MD. Local candidates only please. This (more...)
Company: Netsurion
Location: Columbia
Posted on: 10/21/2019

Sr. Engineer, MS&T
Description: Paragon Gene Therapy, now a part of Catalent, hires people with a passion to make a difference. Your expertise, coupled with our advanced technologies and collaboration with innovative pharmaceutical, (more...)
Company: Paragon Gene Therapy, a unit of Catalent Biologics
Location: Halethorpe
Posted on: 10/21/2019

Log In or Create An Account

Get the latest Maryland jobs by following @recnetMD on Twitter!

Baltimore RSS job feeds