Senior Data Engineer

SDC is a team of diversified professionals who deliver exceptional Biometric Services, Consulting, and Technology Solutions to pharmaceutical, biologic, and medical device/diagnostic companies. Since 2005 our purpose has been to partner with sponsors to provide high quality and experienced team members to develop great medicines that save lives and cure diseases in the most efficient manner possible. Our global team operates as a value partner to our clients by fulfilling their needs as our own and delivering exceptional results. We are a specialty CRO in that we provide scalable service offerings, focused services area specialists, efficient project timelines, optimal technology solutions, and proven success and experience. Our commitment to our clients is the same commitment to our employees. By offering strong benefits including competitive pay, generous time off, attainable career advances, positive work/life balance and 401k matching (US), we are able to attract some of the most talented people in the industry.

The Senior Data Engineer will design and automate the cleaning, processing, and analyzing of both clinical data and nonclinical data with the goal of transforming data into information that supports a better understanding of the safety and efficacy of new clinical therapies. The role contributes to the organization's strong drive to be at the forefront of using Artificial Intelligence (AI) in clinical trials to simplify data processing and discover imperceptible correlations. A Fully remote opportunity is available if desired.

This is a full-time, non-contract role. Recruiters and agencies- please do not submit any candidates for consideration

#LI-Remote

Primary Responsibilities

• Designs and develops data architecture for new and existing applications and data sources
• Establishes Data Quality, Data Governance and Master Data Management Best Practices to enable the business to maintain clean and accurate data
• Designs ETL frameworks and features to allow for robust and scalable data pipelines
• Incorporate new pipelines into the existing data model, augmenting as needed
• Manages and maintains several production systems
• Engages with various internal cross-functional departments to strategically design, develop and implement data pipelines while understanding the underlying data
• Increases team productivity by developing, identifying, and implementing better tools and processes
• Exemplifies good documentation, coding, and testing best practices
• Develops standard operating procedures for the use of artificial intelligence and data engineering principles within clinical trials
• Prototypes new ideas/technologies to create proof of concept and demos
• Provides mentorship for other data engineers
• Assist in executing responsibilities of Data Engineers including the following:
• Maintains and develops ETL pipelines
• Maintain an Enterprise Data Warehouse by updating and translation logic and support warehouse servers.
• Follow Data Quality, Data Governance and Master Data Management Best Practices
• Delivers high quality software design documentation
• Prototypes new ideas/technologies to create proof of concept and demos
• Contributes to the development of standard operating procedures
• Performs other related duties incidental to the work described herein
• Adherence to all essential systems and processes that are required at SDC to maintain compliance to business and regulatory requirements
• Act as a resource for other team members for debugging, code reviews and other software development lifecycle activities.
• Contract Research Organization experience and familiarity with its operations
• The above statements describe the general nature and level of work being performed by individuals assigned to this classification. This document is not intended to be an exhaustive list of all responsibilities and duties required of personnel so classified.

Requirements

• Fluency in Python with experience parsing, manipulating and converting data to and from a wide range of formats (CSV, json, XML, html, SQL tables, etc.)
• Deep understanding of modern RDBMS concepts (triggers, indexes, views, stored procedures) and SQL syntax, including experience with at least one modern RDBMS
• Ability to design efficient data warehouse following dimensional modeling principles for scalable reporting.
• Solid understanding of multiple database systems (No-SQL, SQL)
• System design capabilities to improve operational efficiency and costs.
• Experience in the software development lifecycle.
• Ability to mentor other data engineers and increase team productivity
• Ability to work with stakeholders to translate business requirements into clear technical specifications
• Ability to communicate effectively in writing and verbally.
• Ability to identify issues, present problems, and implement solutions
• The capability of communicating technical concepts clearly, concisely, and understandably to non-technical colleagues
• Good leadership, organizational, and time management skills, with the ability to multi-task
• Strong interpersonal communication and presentation skills

Education or Equivalent Experience

• Bachelor's degree in a technical field with 7 years of technical experience with the last ~4 years being in a Data Engineering centric role
• OR
• 10+ years in a technical role with the last ~5 years being in a Data Engineering centric role

Benefits

What you can expect from us:

• We are committed to developing our employees. We recognize achievements, provide growth opportunities and career advancement, and offer a flexible work schedule, engaging work culture, and employee benefits.
• We are passionate about our company culture. Our recognition program is directly tied to our core values of Energy, Integrity, Engagement, Innovation, Ownership, and Commitment.
• We strive to provide a place of belonging to our employees with fun and engaging activities from SDC's culture club.
• We constantly grow and innovate to support our clients and employees' needs. Global in nature, we bring diverse perspectives enabling our growth in this ever-evolving industry.
• With a proven track record, SDC has successfully executed client clinical programs since 2005.
• Health Care Plan (Medical, Dental & Vision)
• Retirement Plan (401k)
• Life Insurance (Basic, Voluntary & AD&D)
• Paid Time Off (Vacation, Sick & Public Holidays)
• Family Leave (Maternity, Paternity)
• Short-Term & Long-Term Disability
• Training & Development
• Work From Home
• Profit based incentive