Job Opportunities API

Senior Data Engineer Statistics & Data Corporation (SDC), a specialized contract research organization (CRO) headquartered in Arizona, delivering top-tier clinical trial services to pharmaceutical, biologic, and medical device/diagnostic companies since 2005. SDC providing a technology enabled service offering to provide clients with both clinical services expertise, as well as the technology they need to be successful in their clinical trials. Job Summary 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 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. 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 • Incorporates 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 • Assists in executing responsibilities of Data Engineers including the following: o Maintains and develops ETL pipelines o Maintains an Enterprise Data Warehouse by updating and translation logic and support warehouse servers. o Follows Data Quality, Data Governance and Master Data Management Best Practices o Delivers high quality software design documentation o Prototypes new ideas/technologies to create proof of concept and demos o Contributes to the development of standard operating procedures o 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 Required Skills • 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 produ