Research Data Engineer II

Brown University Health is seeking a Research Data Engineer II to support the design and operationalization of data systems across the healthcare organization. Reporting to the Manager, Data Architecture, this role focuses on scalable, performant, and resilient pipelines that enable effective decision making while strengthening enterprise data quality.

This position blends engineering rigor with healthcare-informed data management, including automated validation, careful data mapping, and collaboration across teams and partners to meet emerging data requirements and shared terminology.

Role focus

• Design, build, and maintain scalable data processing systems that deliver efficient, secure, and reliable pipelines.
• Lead operationalization of complex data pipelines so data solutions align with organizational and business objectives.
• Develop fully automated data validation and data mapping rules to confirm regular updates, map new values, and detect unexpected changes.
• Perform root cause analysis for discrepancies or anomalies and implement corrective action.

Data engineering and integration

• Work across multiple vendor-supplied and home-grown data warehouses and lakes to reduce duplication and inefficiencies.
• Profile and re-organize complex or disjointed data sources to improve usability for analytics.
• Integrate and ingest information from diverse sources including clinical data, supplier inputs, financial transactions, HR and other service applications, third-party information, and unstructured inputs from tools such as Excel spreadsheets and online forms.
• Evaluate the integrity of data movement, transformation code, and large datasets.
• Innovate and lead the design and development of Extract, Transform, Load (ETL) processes.

Data products, governance, and enablement

• Maintain documentation for data processes, tools, and pipelines written for data users.
• Contribute to and grow a unified data catalog and data model.
• Engage organizational partners to define new data requirements and evolving terminologies.
• Manage and maintain mappings for common or related terms in a centralized location, including ongoing updates to support coordination.
• Proactively inform the data community about new capabilities delivered by the data architecture team.
• Design, build, and maintain a centralized repository of reliable, high-quality data to streamline data scientist workflows and support faster dataset validation.
• Work with data governance bodies to advocate for safer, more secure, and more effective data procedures.

Collaboration and growth

• Mentor and guide junior engineers and help foster collaboration and continuous learning.
• Produce training materials for data specialists across the organization.

Cloud and optimization

• Contribute to cloud migration initiatives, data infrastructure modernization, and system optimization.
• Monitor analytics department capacity resources such as Microsoft cloud computing capacity.
• Develop and implement plans to reduce analytics department capacity usage without reducing data functions by optimizing processing techniques.

Basic qualifications

• Bachelor’s Degree in a STEM-related field (or equivalent).
• Four years’ experience in data engineering, including strong 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 processes, 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 is preferred.
• Demonstrated experience mentoring junior engineers and collaborating across teams.
• Strong analytical and critical thinking skills, including the ability to decompose complex issues into practical solutions.
• Excellent written and verbal communication skills for technical and non-technical stakeholders.
• Skilled in rigorous and automated data validation techniques.
• Knowledge of data documentation methods that prioritize documentation value.
• Epic Clarity Cogito certification is preferred.

Technologies

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

Compensation

• $100,027.20 to $165,048.00 per year

Work environment

• 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, including PHI and PII.
• Employee is responsible for costs related to setting up, furnishing, and maintaining the remote workspace, including internet connectivity to access Brown University Health Information Services resources.
• Requires the visual and manual dexterity to operate a computer.

Independence and supervision

• Performs independently within broad scope of department policies and practices.
• Refers specific complex problems to supervisor when clarification is required.
• Supervisory responsibility: none.

Schedule

• Work type: M-F 8:30 am to 5:00 pm
• Work shift: Day
• Daily hours: 8
• Driving required: No

Location

• Corporate Headquarters - 15 LaSalle Square Providence, Rhode Island 02903
• Location: Providence, RI (remote)