- 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
CANDIDATE S PROFILE
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(e.g. Qlik, MicroStrategy, etc.)
- Knowledge of clinical trial data is a plus
