Sr Software Architect

Company: Covance
Location: Indianapolis
Posted on: November 23, 2020

Job Description:

Job Description: Job Overview: As a market leader in central laboratory, pre-clinical services and clinical trial management services, Covance works with most leading pharmaceutical and biotechnology companies to life-saving medicines to patients in need sooner. Over the past 10 years we have handled over 10,000 clinical trials in more than 600 indications, worked with over 200 thousand investigators, and collected data from over 14 million patient visits. Recognizing the enormous potential of data-driven decision making, we are developing cutting-edge informatics capabilities to unleash the power of this data to help pharmaceutical and biotechnology companies protect patient safety, reduce cost and increase speed of clinical development to bring new medications to patients who cannot wait. As a member of the Informatics team, you will play a key role developing effective, efficient, and elegant ETL algorithms to meet the diverse and flexible needs of data analysis in the clinical R&D process. Your technical understanding and strong communication skills will enable you to communicate with key customers how our implementation will improve their business processes. Your technical expertise will contribute to the evaluation of implementation options that deliver critical impact with optimized performance. We seek smart, focused, passionate self-starters who bring energy, new ideas and practical experience to a fast-paced and dynamic team, are obsessed with delivering useful and elegant solutions, and care deeply about their customers and each other. Responsibilities: * Participate in the design and development of information flow from business processes and source systems into ETL workflows for data warehouses that support Covance's Xcellerate platform. * Coordinating multiple ETL workflows and data load processes and monitoring systems performance, including on-going optimization and tuning. * Analyzing and evaluating data sources, data volume, and business rules. * Collaborate with diverse team across business engagement, architecture, testing, and support. * Demonstrated ability to provide documentation of code designs and develop unit and integration testing in alignment with functional specifications. * Participate in the full development cycle from product inception, research and prototyping to release in production. * Demonstrate ability to develop a high degree of autonomy in performing the tasks outlined above. Education : BS/MS in computer science, information systems, life sciences, or related discipline. Required: * Minimum 7 years of data warehousing and data integration experience in complex business environments * Demonstrated experience in designing ETL processes for high-volume, complex data environments using Informatica, BODS, or similar. * Demonstrated experience of relational and dimensional database models, including logical and physical design using SQL Server, Oracle, or similar. * Strong knowledge of database programming using T-SQL, PL/SQL, or similar. * Strong knowledge of SQL and query performance tuning. * Knowledge and experience in cloud deployments on AWS, Azure, or similar. * Knowledge and experience of REST API calls, json schemas and parsing, and xml schemas and parsing. * Good interpersonal and communication skills. Preferred: * Experience in healthcare or life sciences * Programming skills in C#, Java, JavaScript, or related languages * Experience with 21CFR Part 11 software validation * Experience with master data management approaches, tools and design patterns. Education/Qualifications: BS/MS in computer science, information systems, life sciences, or related discipline. Experience: Required : * Minimum 7 years of data warehousing and data integration experience in complex business environments * Demonstrated experience in designing ETL processes for high-volume, complex data environments using Informatica, BODS, or similar. * Demonstrated experience of relational and dimensional database models, including logical and physical design using SQL Server, Oracle, or similar. * Strong knowledge of database programming using T-SQL, PL/SQL, or similar. * Strong knowledge of SQL and query performance tuning. * Knowledge and experience in cloud deployments on AWS, Azure, or similar. * Knowledge and experience of REST API calls, json schemas and parsing, and xml schemas and parsing. * Good interpersonal and communication skills. Preferred : * Experience in healthcare or life sciences * Programming skills in C#, Java, JavaScript, or related languages * Experience with 21CFR Part 11 software validation * Experience with master data management approaches, tools and design patterns.

Keywords: Covance, Indianapolis , Sr Software Architect, IT / Software / Systems , Indianapolis, Indiana