Research Data Engineer II (IT@JH Univ Data Analytics & Engineering)

<div class="container-3Gm1a"><p></p><p> IT@JH Univ Data Analytics & Engineering is seeking a<b> <i>Research Data Engineer II</i> </b>who will support research investigators and Research Leadership across Johns Hopkins University and Johns Hopkins Medicine by designing and deploying complex data architectures and supporting data integration, curation, and analysis. The Research Data Engineer works with cloud lake house environments such as Databricks and Microsoft Fabric, as well as modern ETL tools and Python to manage and support data pipelines for enterprise research data products. Assignments are primarily project-based, involving direct engagement with end-users to understand requirements, facilitate modeling sessions, write business and technical requirements, and implement solutions. The role functions with a high degree of independence under the general supervision of the IT Director of Research Data, with work assigned through project goals and reviewed based on solution outcomes.</p><p class="br"><br></p><b>Specific Duties & Responsibilities</b><p></p><ul><li>Contribute to the design, production, and maintenance of data pipelines for data acquisition, management, transformation, and back-end code development to power data web applications and convert raw data into usable information.</li><li>Write and maintain ETL/ELTs that operate on a variety of structured and unstructured sources.</li><li>Develop and maintain web data scraping systems for automatic data acquisition.</li><li>Help design data architecture and provide ongoing support.</li><li>Input/output data from databases and perform queries.</li><li>Create scripts to clean, transform, and analyze data.</li><li>Put into production data pipelines using data warehousing systems.</li><li>Create and implement production software to monitor data quality and detect data anomalies.</li><li>Perform daily manual data quality assurance tasks.</li><li>Support, maintain, and troubleshoot the software infrastructure.</li><li>Source data, conduct analyses, visualize data, and generate insights to support ongoing research projects and other requests across the organization.</li><li>Collaborate with developers, analysts, data scientists, researchers, policy experts, and other partners.</li><li>Communicate with Division leadership, and others on the team.</li><li>Collaborate with external partners, contractors, and vendors.</li><li>Other duties as assigned.</li></ul><br><br><strong>Minimum Qualifications</strong><br><ul><li>Bachelor’s Degree.</li><li>Five years of related work experience focused within database management and design, and business requirements gathering.</li><li>Additional education may substitute for required experience and additional related experience may substitute for required education permitted by the JHU equivalency formula beyond a high school diploma/graduation equivalent, to the extent permitted by the JHU equivalency formula.</li></ul><br><br><strong>Preferred Qualifications</strong><br><ul><li>Experience with data standards such as controlled vocabularies (e.g., SNOMED, LOINC, ICD) and the OMOP common data model</li><li>Experience working with EHR data, particularly EPIC data models such as Clarity and Caboodle</li><li>Experience working with a variety of data types such as semi-structured and unstructured data</li><li>Experience working in a highly decentralized, consensus-driven environment, such as an academic institution</li><li>Experience directly engaging with end users to understand requirements and implement successful architectures</li><li>Thorough knowledge of data warehouse and data management principles and processes and database development</li><li>Strong proficiency in SQL programming, query writing, query performance tuning, and database technologies</li></ul><hr style="width:50%;text-align:center"><p>Classified Title: Data Engineer II <br>Job Posting Title (Working Title): Research Data Engineer II (IT@JH Univ Data Analytics & Engineering)   <br>Role/Level/Range: ATP/04/PG  <br>Starting Salary Range: $99,800 - $175,000 Annually (Commensurate w/exp.) <br>Employee group: Full Time <br>Schedule: Mon-Fri 8:30am-5:00pm <br>FLSA Status: Exempt <br>Location: Remote <br>Department name: IT@JH Univ Data Analytics & Engineering  <br>Personnel area: University Administration </p></div>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...