• Design, build, and maintain reliable and scalable data pipelines, primarily leveraging SQL • Develop and optimize complex queries to support analytics and reporting needs • Ensure data accuracy, consistency, and quality across multiple data sources • Partner with stakeholders to translate business questions into data solutions • Support experimentation frameworks, including A/B testing and data validation • Work with analytics teams to deliver datasets used in dashboards and reporting tools (e.g., Metabase or similar) • Communicate insights effectively through data storytelling, tailoring messages for non-technical audiences • Collaborate with cross-functional teams in a client-facing consulting environment • Contribute to best practices in data modeling, documentation, and governance

• Design, build, and maintain reliable and scalable data pipelines, primarily leveraging SQL • Develop and optimize complex queries to support analytics and reporting needs • Ensure data accuracy, consistency, and quality across multiple data sources • Partner with stakeholders to translate business questions into data solutions • Support experimentation frameworks, including A/B testing and data validation • Work with analytics teams to deliver datasets used in dashboards and reporting tools (e.g., Metabase or similar) • Communicate insights effectively through data storytelling, tailoring messages for non-technical audiences • Collaborate with cross-functional teams in a client-facing consulting environment • Contribute to best practices in data modeling, documentation, and governance

Role Description IT@JH Univ Data Analytics & Engineering is seeking a Research Data Engineer II 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. - 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. - Write and maintain ETL/ELTs that operate on a variety of structured and unstructured sources. - Develop and maintain web data scraping systems for automatic data acquisition. - Help design data architecture and provide ongoing support. - Input/output data from databases and perform queries. - Create scripts to clean, transform, and analyze data. - Put into production data pipelines using data warehousing systems. - Create and implement production software to monitor data quality and detect data anomalies. - Perform daily manual data quality assurance tasks. - Support, maintain, and troubleshoot the software infrastructure. - Source data, conduct analyses, visualize data, and generate insights to support ongoing research projects and other requests across the organization. - Collaborate with developers, analysts, data scientists, researchers, policy experts, and other partners. - Communicate with Division leadership, and others on the team. - Collaborate with external partners, contractors, and vendors. - Other duties as assigned. Qualifications - Bachelor’s Degree. - Five years of related work experience focused within database management and design, and business requirements gathering. - 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. Requirements - Experience with data standards such as controlled vocabularies (e.g., SNOMED, LOINC, ICD) and the OMOP common data model. - Experience working with EHR data, particularly EPIC data models such as Clarity and Caboodle. - Experience working with a variety of data types such as semi-structured and unstructured data. - Experience working in a highly decentralized, consensus-driven environment, such as an academic institution. - Experience directly engaging with end users to understand requirements and implement successful architectures. - Thorough knowledge of data warehouse and data management principles and processes and database development. - Strong proficiency in SQL programming, query writing, query performance tuning, and database technologies. Benefits - Starting Salary Range: $99,800 - $175,000 Annually (Commensurate w/exp.) - Employee group: Full Time - Schedule: Mon-Fri 8:30am-5:00pm - FLSA Status: Exempt - Location: Remote - Department name: IT@JH Univ Data Analytics & Engineering - Personnel area: University Administration

Role Description The Data Engineer will support the growth of leading-edge health and human service data projects that use data to transform care across the nation. This role is responsible for working simultaneously on more than one project within a team that includes technical experts, data engineers, data scientists, research associates, project managers, and subject matter experts – to achieve project goals and deliverables. The Data Engineer is responsible for designing, building, and optimizing scalable data solutions that support organizational analytics, reporting, and data quality initiatives. This role works independently on complex data engineering tasks and owns end-to-end data pipelines, integrations, and performance optimization using SQL, Python, and Microsoft Azure technologies. Qualifications - Bachelor’s degree in computer science, information systems, or related field (or equivalent experience) - 3–5 years of experience in data engineering or related roles - Strong proficiency in SQL and Python - Experience with Azure data services and data pipeline design - Experience building and optimizing data pipelines, architectures, and datasets - Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement - Experience supporting and working with cross-functional teams in a dynamic environment - Excellent attention to detail - Awareness of DevOps and Agile principles - Intermediate to advanced expertise with RESTful APIs, XML, JSON, C#, JavaScript, jQuery, and Azure Data Factory - Promote teamwork and team-building Requirements - Design, develop, and maintain scalable data pipelines and automation workflows - Own and optimize ETL/ELT processes using SQL, Python, and Azure data technologies - Develop and maintain REST APIs and other data integration mechanisms - Integrate new and external data sources into production data environments - Monitor, test, and optimize data systems for performance and reliability - Define and implement data quality checks and reporting frameworks - Design and maintain dashboards, scorecards, and reports - Collaborate with cross-functional teams to improve data systems - Mentor Associate Data Engineers - Attend staff, team, and other required meetings and trainings Benefits - Health - Dental - Short- and long-term disability - Life Insurance - 403(b) retirement plan - Flexible spending accounts - Education assistance program - 10 paid holidays - Remote work stipends (e.g., home office improvements, internet/mobile services) Company Description HSRI is a nonprofit organization that conducts research and evaluation to improve health and human service systems. We work at the local, state, and federal levels. Our goal is to help public agencies understand and demonstrate the real-world impact of the services they provide, helping them transform their policies and practices to address root causes of disparities and improve health outcomes. Our teams have an unwavering commitment to envisioning equitable policies and solutions that create a stronger society for us all. HSRI is an equal opportunity employer and is committed to building a diverse team, bringing as many possible perspectives as possible to bear on services that can profoundly affect people’s health and well-being by addressing social determinants of health. We are committed to building an inclusive environment where people of all backgrounds can come to do their best work.