In this role, you have the opportunity to own the architecture and data ingestion processes from end to end including operational and data quality concerns.
Work closely with product and engineering to develop strategy for data ingestion architecture, tools and processes
Design, implement, test and monitor automated system
Automate read, extract, transform, stage and load data processes using state of the art cloud-based tools
Develop and build custom software and integrations for EMR interoperability
Develop, construct, test and maintain data management systems using appropriate tools to perform data ingestion, transformation, cleansing and loading
Integrate up-and-coming data management and software engineering technologies into existing data structures.
Implement processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it.
Performs data analysis required to troubleshoot data related issues and assist in the resolution of data issues.
Gather Data - Collected data from HIE, EMR, Flat files or other structured and unstructured sources
Clean Data - Once the data has been collected, in order to allow for proper comparison, the data engineer must filter and "clean" the data to remove errors and ensure consistency and completeness of data. Cleansing routines should be used to identify matches where data values may have been keyed incorrectly, may have partially matching strings or values may be missing. The Data Integration Engineer will need ETL tools as well as programming skills to write cleansing scripts to correct errors through automation.
Structure Data – Once the data is extracted and cleaned it must be organized and stored in database structures to optimize performance and maintain history.
Project Management - Works with the project team to define tasks and create work plans with moderate supervision. Identify issues affecting work progress and recommend solutions. Communicate variances and potential scope changes in status reports. Control project costs, communicating any project-related expenses and recommend ways to control costs.
Performs other duties as assigned.
Bachelor's degree preferred.
Experience as a data integration engineer or in a similar role
Experience with database design
Experience with MySQL experience (No-SQL experience is a plus)
Experience designing, building, and maintaining data processing systems in a cloud architecture (AWS preferred)
Experience with open-source data integration tools such as Pentaho, Talend and Mirth
Experience with processing healthcare data required
Experience with multiple ETL solutions/tools preferred.
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
Telecommuting is allowed.
Internal Number: 5421
OpenArc is a technology consulting firm providing industry-leading technical talent placement, software development, and technology strategy services to clients nationwide. Through a unique blending of people and software, OpenArc has a business practice that delivers amazing enterprise, mobile and consumer-facing apps and the best talent for contract, contract-to-hire and direct placements for clients and partners alike.
Staffed with the most-trusted recruiting experts, elite software developers, UI/UX designers and market experts, our team provides clients with the best resources, the right techniques and world-class support resulting in powerful measurable success.