Job Title: ETL Engineer
Our client is seeking an experienced ETL Engineer. This software will be
deployed on a national and global scale to integrate distributed clinical and research
data sites to enable both federated and centralized networks for clinical, biomolecular,
imaging and genomic data.
Prior Experience with the following areas are sought:
" Python programming integrated with many different databases
" Strong SQL knowledge and data modeling capabilities
" Strong overall database knowledge and tools.
" Metadata driven ETL
" Experience working with healthcare and research data (OMOP Data Model
" Experience with biomedical and research terminologies.
" Working knowledge of Data Integration/ETL technologies
" Demonstrable Software Development experience
" SQL based development experience preferably in data warehouse, data
integration/migration or analytics
" Knowledge of Microsoft SQL Server database and Integration Services (SSIS)
" Ability to identify functional and non-functional requirements for Data
" Ability to code software according to published standards and design
" Software license management.
" Software Monitoring to support 24x7 support team and SAAS licensing model.
Key Roles and Responsibilities:
" Perform ETL work sourcing from various databases and files with various
" Perform tests and validate all data flows and prepare all ETL processes
according to business requirements and incorporate all business requirements
into all design specifications.
" Perform root cause analysis on all processes and resolve all production issues
and validate all data and perform routine tests on databases and provide
support to all ETL applications.
" Monitor all business requirements and validate all designs and schedule all
ETL processes and prepare documents for all data flow diagrams.
" Pragmatic approach to problem solving
" Develop and perform tests on all ETL codes for system data and analyze all
data and design all data mapping techniques for all data models in systems.
" Documents all technical and system specifications documents for all ETL
processes and perform unit tests on all processes and prepare required
programs and scripts.
" Coordinate with Deployment team to implement all ETL procedures for all new
projects and maintain effective awareness of all production activities
according to required standards and provide support to all existing applications
" Development of advanced services to support statistical data characterization
" Provide recommendations and designs for enhancements to our data model,
in accordance with industry best practices, to enable product development and
customer use cases.
This position will report to ETL Engineer Team Lead
" Education: BS in Software Engineering or Computer Science
" Strong problem solving and analytical skills.
" Strong SQL skills and understanding of data persistence.
" Excellent written and verbal communication.
" Excellent personal time management skills including the ability to work
independently and efficiently in a fast paced environment while tracking work
" A continuous interest in expanding knowledge of software engineering
through hands-on investigation of technologies and tools with
recommendations to senior management and development team