Data Integration Specialist

Data Integration Specialist

The Data Integration Specialist will play a crucial role in enhancing the Texas Birth Defects Registry (TBIRDS) by ensuring seamless data integration, automation, and interoperability. This position involves conducting needs assessments, developing and maintaining automated workflows, and collaborating with various stakeholders to improve data processing and reporting capabilities.

Responsibilities

• Interoperability Needs Assessment: Conduct a needs assessment to evaluate and identify necessary steps for TBIRDS to ingest electronic case reporting (eICR) data and auto-populate select data fields. Maintain clear documentation of programming scripts, workflows, validation procedures, developed solutions, and other integration-specific information to support sustainability and future maintenance. Develop a report/system requirements document describing functions and workflows needed for TBIRDS interoperability.
• Dashboards and System Integration: Develop, test, document, and maintain SAS, Python, R (or other statistical software) programs for multiple branch processes, including building dashboards. Programs will automate and integrate relevant data from eICRs into TBIRDS to expedite branch processes such as but not limited to: triaging cases for clinical review and/or automating data ingestion in TBIRDS.
• Testing and Validation: Test and validate automated workflow processes, standardization, linkage, and processing methods to assess accuracy, completeness, and reliability of SAS, R, and Python (or other statistical software) programs. Troubleshoot identified issues and refine programming solutions accordingly.
• Data Interoperability Automation and Registry Modernization: Support efforts to incorporate electronic health data into existing TBDR workflows and assist with needs assessment and planning related to eICR integration and other interoperability initiatives.
• Technical Requirements and Recommendations: Collaborate with BDESB staff and technical partners to identify data and system requirements, document technical processes, identify potential limitations, and develop recommendations for future interoperability projects.

Requirements

• Experience: 8 years of experience developing, testing, maintaining, and troubleshooting SAS, Python, R, or other similar programming language scripts.
• System Integration: 8 years of experience with system integration, dashboard creation, and automation for improved interoperability workflows.
• Health Data: 8 years of experience working with structured or semi-structured health, public health, or other complex administrative data and knowledge of databases and database querying.
• Reporting: 8 years of ability to develop reports that document system requirements to identify programmatic and business needs and translate them into technical solutions.
• Testing and Validation: 8 years of experience testing and validating automated data-integration solutions.
• Documentation: 8 years of ability to document code and technical specifications for improved workflows and procedures.
• Analytical and Problem-Solving Skills: Strong analytical and problem-solving skills, ability to communicate technical concepts to both technical and nontechnical staff, and ability to work collaboratively with other staff.

• Electronic Case Reporting: 2 years of experience with electronic case reporting (eCR/eICR), Electronic Health Records or Health Information Exchange, healthcare interoperability standards such as HL7, XML, or FHIR, SNOMED CT or other clinical terminology standards.
• SQL and Relational Databases: 2 years of experience with SQL and relational databases, public health surveillance systems or registries, data linkage and matching, and development of automated data pipelines or ETL processes.