Maintaining and enhancing the performance of existing data pipelines.
Monitoring data pipelines and related systems to ensure optimized performance.
Automate data pipelines to increase efficiency.
Performing debugging procedures on database scripts and programs, as well as resolving conflicts.
Developing quality assurance tests to ensure pipelines and scripts are accurate.
Collaborating with researchers to understand data requirements and review results of data pipelines.
Adhering to best practices in securely storing, backing up, and archiving data.
Documenting processes related to data pipeline design, configuration, and performance.
Keeping abreast of developments and best practices in database engineering.
Reviewing database and user reports, as well as system information.
In order to qualify you must have:
Bachelor's degree in information systems, information technology, computer science, or similar.
A minimum of 6 years experience in database engineering.
Strong experience in Data warehousing, Data Modelling, Data Integration, Data Migration and ETL process.
Hands-on experience in developing database applications and administering database and Information systems.
Strong experience in working Databases like Oracle, Microsoft SQL Server, and MySQL.
Strong knowledge in developing complex SQL queries, Stored procedures
Hand-on experience in scripting languages like Bash, Python
Must have experience in any of the Cloud Environments such as AWS, Google Cloud Platform, Azure, preferably AWS.
Exposure to any industry standard ETL providers such as AWS Glue, Google Data Flow, Informatica, Talend, Pentaho.
Experience in Automating the ETL pipelines and must have experience in ETL Development and Testing.
Strong organizational skills and attention to detail.
Exceptional problem-solving and critical thinking skills.
Excellent collaboration and communication skills.
Boston Children's Hospital offers competitive compensation and unmatched benefits, including a rotating days/evenings and week-end schedule, affordable health, vision and dental insurance, generous levels of time off, 403(b) Retirement Savings plan, Pension, Tuition Reimbursement, cell phone plan discounts and discounted rates on T-passes (50% off). Discover your best. #CB LI
