Research Data Engineer II

Brown University Health is seeking a Research Data Engineer II to design, build, and operate scalable data systems that support decision making across the healthcare system.

Responsibilities

• Design, build, and maintain large-scale data processing systems to keep pipelines efficient, scalable, and secure.
• Collaborate with multiple vendor-supplied and home-grown data warehouses and lakes to reduce duplication and inefficiencies.
• Analyze data sources to assess value and recommend inclusion in analytical environments.
• Profile and re-organize complex or disjointed data sources.
• Produce well-documented data infrastructure that supports long-term use with minimal upkeep.
• Develop automated data validation and data mapping rules for regular source updates, new value mapping, and detection of unexpected changes.
• Ensure validation errors are quickly identified.
• Perform root cause analysis for discrepancies or anomalies and implement corrective action.
• Ingest information from diverse sources including clinical data, supplier inputs, financial transactions, HR and other services, third-party data, and unstructured inputs such as Excel spreadsheets and online forms.
• Innovate and lead the design and development of ETL processes.
• Evaluate and protect the integrity of data movement, transformation code, and large datasets.
• Write detailed documentation for data processes, tools, and pipelines with data users in mind.
• Contribute to, maintain, and grow a unified data catalog and data model.
• Engage organizational partners to define emerging data requirements and terminologies.
• Manage common or related term mapping in a single unified location and monitor/adjust it to improve coordination.
• Proactively inform the data community about new developments and capabilities from the Data Architecture team.
• Design, build, and maintain a centralized repository of reliable, high-quality data to streamline workflows for data scientists and support AI model development.
• Mentor and guide junior engineers; foster collaboration and continuous learning.
• Create training materials for data specialists across the organization.
• Contribute to cloud migration, data infrastructure modernization, and system optimization.
• Monitor analytics department capacity resources such as Microsoft cloud computing capacity.
• Develop and implement plans to reduce analytics capacity usage without reducing data functions through processing optimization.
• Partner with data governance bodies to advocate for safer, more secure, and more effective data procedures.

Requirements

• Bachelor’s Degree in a STEM-related field (or equivalent).
• 4 years of data engineering experience.
• Proficiency in SQL, Python, and other data tools.
• Experience architecting scalable data systems and working with large, complex datasets.
• Experience designing and operationalizing complex solutions.
• Experience with data modeling, ETL, and data pipeline optimization.
• Firsthand experience with cloud platforms, data warehousing, and ETL design.
• Experience with healthcare data management and familiarity with healthcare industry standards preferred.
• Demonstrated experience mentoring junior engineers and collaborating across teams.
• Strong analytical and critical thinking skills, including decomposing complex issues into practical solutions.
• Excellent written and verbal communication skills with the ability to convey technical information to technical and non-technical stakeholders.
• Skilled in rigorous, automated data validation techniques.
• Knowledge of data documentation methods that prioritize return on documentation time.
• Epic Clarity Cogito certification preferred.

Technologies

• SQL
• Python
• Extract, Transform, Load (ETL)
• Cloud platforms
• Data warehousing
• Data lakes
• Data pipelines
• Microsoft cloud computing capacity
• Epic Clarity Cogito
• Excel

Work Environment & Physical Requirements

• Requires visual and manual dexterity to operate a computer.
• Remote position with option to travel to sites in Rhode Island and Southeastern Massachusetts, as needed.
• Employee must establish a secure workspace environment to protect confidentiality of sensitive information.
• Sensitive information includes confidential information, PHI, and PII.
• Employee is responsible for costs to set up, furnish, and manage the remote workspace, plus costs of maintaining internet connectivity to access Brown University Health Information Services resources.

Additional Information

• Reports to Manager, Data Architecture.
• Independent action within broad scope of department policies and practices; refers specific complex problems to supervisor when policy clarification is required.
• Supervisory responsibility: None.
• Pay range: $100,027.20 - $165,048.00
• Location: Corporate Headquarters, 15 LaSalle Square, Providence, Rhode Island 02903
• Work type: M-F, 8:30 am - 5:00 pm
• Work shift: Day
• Daily hours: 8 hours
• Driving required: No