Senior Software Developer

OVERVIEW

The Software Developer will work closely with clients and provide technical consulting services and oversight for specific projects that include ETL development. The Software Developer will provide direction on database aspects to the team of existing ETL developers on various database related activities. This position reports to the Team Lead-ETL, Technical Services.

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
• 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
• Other duties as assigned

CANDIDATE’S PROFILE

Education & Experience

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

Professional Skills

• Minimum of 2 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
• 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 modelling, and design
• Strong troubleshooting skills and use of defect/feature management systems
• Proven ability to work independently and with technical team members (Start-up environment experience is a plus)
• Excellent verbal and written communication skills

Technical Skills

• 1+ years with SQL Server, ETL and Data Warehousing
• 1+ years with ETL architecture and design
• Experience with Performance tuning and management of SQL Server
• Knowledge of Dimensional modelling
• Understanding of any BI tools (e.g., Qlik, MicroStrategy, etc)
• Knowledge of clinical trial data is a plus