Position: Data Engineer (Informatics)
Duration: 6 months +Contract
Location: Cambridge, MA (100% remote for now)
Responsibilities:
- Closely partner with business stakeholders and other technical team members to acquire and migrate initial data sources that are most relevant to business needs and goals.
- Demonstrate deep technical and domain knowledge of relational and non-relation databases, Data Warehouses, Data lakes among other structured and unstructured storage options.
- Determine which tools and architectures are best suited to develop a pipeline for a particular data source.
- Develop data flow pipelines to extract, transform, and load data from various data sources in various forms, including custom ETL pipelines that enable model and product development.
- Write custom scripts to extract data from unstructured/semi-structured sources.
- Provide clear documentation for delivered solutions and processes, integrating documentation with the appropriate corporate stakeholders.
- Identify and implement internal process improvements for data management (automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability).
- Stay current with and adopt new tools and applications to ensure high quality and efficient solutions.
Qualifications:
- BS/BA degree in Computer Science or equivalent with 5-8 years of relevant experience
- Minimum 5 years of experience designing, developing, testing, and implementing ETL solutions using any enterprise ETL tools.
- Proven experience working with Cloud Environments, AWS preferred.
- Experience working in regulated environments with GXP experience in pharma/biotech strongly preferred.
- Extensive knowledge of data warehouse design and data modeling principles.
- In-depth understanding of database management systems and scripting (SQL, NoSQL and distributed databases).
- Experience with BI tools such as Tableau and Looker.
- Scripting experience with Python.
- Strong communication skills, a customer service attitude, and demonstrated problem solving ability.