Research Data Engineer II

Design, build, and operate healthcare-focused data systems that support reliable analytics and decision making.

Responsibilities

• Design, build, and maintain large-scale data processing systems to keep pipelines efficient, scalable, secure, and resilient.
• Collaborate with vendor-supplied and home-grown data warehouses and data lakes to reduce duplication and inefficiencies.
• Analyze data sources to assess value and recommend inclusion in analytical environments.
• Profile, reorganize, and structure complex or disjointed data sources.
• Deliver solid, well-documented data infrastructure designed for long-term use with minimal upkeep.
• Develop automated data validation and data mapping rules to validate regular updates, map new values, and confirm values do not change unexpectedly.
• Ensure data validation errors are identified quickly.
• Perform root cause analysis for discrepancies or anomalies and implement corrective actions.
• Integrate and ingest diverse inputs, including clinical data, supplier inputs, financial transactions, information bolstering Human Resources (HR) and other services, third-party information, and unstructured data such as Excel spreadsheets and online forms.
• Innovate and lead the design and development of ETL processes.
• Evaluate and ensure 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 with organizational partners to define emerging data requirements and terminologies.
• Manage term and concept mapping in a centralized location and monitor mapping to improve coordination with operational partners.
• Proactively communicate new capabilities and developments enabled by the data architecture team.
• Design, build, and maintain a centralized repository of reliable, high-quality data to streamline data scientists’ workflow and enable focus on AI model development.
• Mentor and guide junior engineers, fostering collaboration and continuous learning.
• Create training materials for data specialists across the organization.
• Contribute to cloud migration, data infrastructure modernization, and system optimization initiatives.
• Monitor analytics department capacity resources, including Microsoft cloud computing capacity.
• Develop and implement plans to reduce analytics capacity usage through optimization of processing techniques without reducing data functions.
• Work 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).
• Four years of experience in data engineering, including strong proficiency in SQL, Python, and other data tools.
• Proficiency in SQL and 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 (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 both technical and non-technical stakeholders.
• Experience with rigorous and automated data validation techniques.
• Knowledge of data documentation methods that prioritize documentation ROI.
• 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 Location and Schedule

• Location: Providence, RI (remote) with option to travel to sites in Rhode Island and Southeastern Massachusetts as needed.
• Hours: M-F, 8:30 am to 5:00 pm
• Work shift: Day
• Daily hours: 8 hours
• Driving required: No

Work Environment and Physical Requirements

• Requires visual and manual dexterity to operate a computer.
• Remote employee must establish a secure workspace environment to protect sensitive information.
• Sensitive information includes confidential information, protected health information (PHI), and protected identifiable information (PII).
• Employee responsible for remote workspace setup and internet connectivity costs to access Brown University Health Information Services resources.

Independent Action and Supervisory Responsibility

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

Salary

• USD 100,027 - 165,048 per year
• Pay range: $100,027.20 - $165,048.00

Reports to: Manager, Data Architecture.