Senior Software Developer

• The Senior Software Developer will work closely with clients and provide technical consulting services and oversight for specific projects that include ETL and custom analytics development

• The Senior Software Developer will provide direction on database aspects to the team of existing ETL developers on various database related activities

KEY TASKS & RESPONSIBILITIES

• Design, develop, test and deploy highly efficient SQL code and data mapping code according to specifications
• Design and develop ETL code in support of analytic software applications and related analysis projects
• Work with Analytics developers, other team members and clients to review the business
  requirements and translate them into database objects
• Research and utilize new technologies
• Collaborate with the Quality Assurance team to test the applications functionality
• Provide diagnostic support and fix defects as needed
• Provide technical guidance, training and support to other team members
• Ensure compliance with eClinical Solutions/industry quality standards, regulations, guidelines and procedures
• Manage multiple timelines and deliverables (for single or multiple clients) and managing client communications as assigned.
• Provide programming solutions and support using elluminate Data Intelligence Hub platform.
• Configuration, migration and support of the elluminate platform
• Through understanding of Clinical research life cycle and Clinical Data standards.
• Other duties as assigned

Education/Language:

• BE / B Tech / M Tech / Master of Science degree in Computer Science and/or equivalent
  
• Excellent knowledge of English

Professional Skills & Experience

• Minimum of 3-5 years in database design and development experience
• Thorough experience in data warehouse architecture, design and development.
• Thorough understanding of database design principles and best practices
• Thorough understanding of the data formats like CDISC, SDTM, CDISC(92,45,101), Q Format, Customized Data formats ..etc
• Excellent experience in designing scalable, modular SQL code and ETL procedures using MS-SQL Server
• Strong Software Development Lifecycle experience (Agile methodology experience is a plus)
• Excellent understanding of relational database concepts, data modeling and design
• Strong technical project management experience and team leadership skills including scope management, work planning and work delegation
• Strong troubleshooting skills and use of defect/feature management systems
• Proven ability to work independently and with technical team members (Startup environment experience is a plus)
• Excellent verbal and written communication skills

Technical Skills & Experience

• 3+ years with SQL Server, ETL and Data Warehousing
• 3+ years with ETL architecture and design
• 2+ years with Data modeling (physical & logical)
• 3+ years with SDTM mapping.
• Experience with Performance tuning and management of SQL Server
• Experience with Dimensional modeling
• Experience with any BI tools(eg Qlik, MicroStrategy, etc)
• Knowledge of clinical trial data is a plus