Senior Data Engineer

Role Overview

• Acts as liaison between software development and data sciences teams to ensure development of robust data architecture foundation and database design
• Assists in gathering requirements, writing user stories, and maintaining detailed specifications for the Syncrony EDC product
• Designs operational reports, study dashboards, and data visualizations for study sponsors, site coordinators, and other key stakeholders
• Ensures integrity of data and consistency of data delivery for data-related projects
• Designs, optimizes, and maintains data pipelines for integration and transformation of diverse and complex datasets into required formats for loading, reporting, and/or analysis
• Oversees database builds as needed; assists in database validation; assesses data impact upon subsequent changes and recommends strategies to maintain data integrity
• Identifies opportunities for improvement; implements optimizations for data flow and collection and automates manual processes
• Supports stakeholders with issues relating to data and data infrastructure; suggests strategies to improve data quality and integrity
• Extracts, transforms, and loads data from outside clinical databases into the Syncrony EDC system
• Maps, integrates, and reshapes data from clinical databases and large-scale registry studies to facilitate pooled analyses
• Develops and maintains SOPs for database development and data mapping, integration, and/or migration projects
• Identifies new opportunities for data acquisition and analysis
• Develops SOPs for standardized study reporting frameworks to provide to all Syncrony EDC clients
• Conducts training sessions for internal and external stakeholders on supported tools for data management and analytics.

Requirements

• Baccalaureate degree in Computer Science, Software Engineering, MIS or equivalent combination of education and experience
• Preferred: graduate degree in Computer Science, Informatics, Statistics, or related field
• At least 3-5 years of database management experience
• Experience writing complex SQL queries
• Experience building and optimizing data pipelines
• Familiarity with a variety of databases (SQL, NoSQL, etc.)
• Experience manipulating and transforming large datasets
• Strong analytic skills
• Experience with business intelligence tools such as Power BI, Tableau, or similar
• Proficiency with at least one object-oriented language (Python, Java, C++, Scala, etc.)
• Must be able to work independently following a period of specific training
• Excellent verbal and written communication skills
• Strong organizational skills and be attentive to detail
• Demonstrate a high degree of personal and professional integrity
• Database Knowledge (SQL, NoSQL, etc.)
• BI Tools
• Object Oriented language experience

Tech Stack

• Java
• NoSQL
• Python
• Scala
• SQL
• Tableau

Benefits

• May require travel.
• The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.