Clinical Programmer in Lawrenceville, NJ

Hybrid worker - 50% on-site

The candidate must be able to work 50% of the time onsite at Lawrenceville, so local candidates only please.

Must Have List

• 8+ years of experience with ETL tools such as Informatica, Data Stage or eClinical Solutions.
• 2+ years of experience with programming ETL Tools. eClinical is the preferred tool.
• 5+ years of experience with SQL language and experience with shell scripting.
• 3+ years of experience with cloud technologies and SAS Programming.
• Bachelor’s Degree (Computer Science preferably)

Summary

• This position will be dedicated to the Clinical Data Warehousing & Delivery function within the Clinical Data Reporting & Analytics group and contribute to the improvement of clinical data review, cleaning efficiency and formal statistical analyses by providing innovative and forward-thinking Extract Transform and Load (ETL) solutions.
• Responsible for planning, connecting to the different data sources, designing and developing the mappings, scheduling those mappings within the Clinical Data Warehouse, monitoring and maintaining the ETL process within the Clinical Data warehouse.

Key Responsibilities and Major Duties

• Leverage technical expertise to define feasible solutions and understand limitations.
• Can create/develop prototypes for new solutions as applicable.
• Create best practices for data loading, transformation, and extraction.
• Develop data architecture, data modeling, and ETL mapping solutions within structured data warehouse environment.
• Develop and implement ETL routines according to the Data Warehouse (DWH) design and architecture.
• Support the development and validation required through the lifecycle of the DWH, maintain user connectivity and provide adequate security for data warehouse.
• Monitor the DWH systems performance and integrity; provide corrective and preventative maintenance as required.
• Maintain data integrity and traceability across the transformation lifecycle from the Source to Target

Qualifications

• 8+ years of experience with any ETL tool.
• Minimum 5+ years of experience in SQL language.
• Minimum 3+ years of experience with cloud technologies.
• Minimum 3+ years of experience in SAS programming.
• Minimum 5+ years of experience in shell scripting.
• Good to have experience with ECS (eClinical Solution) ETL tool.

Education:

• Minimum bachelor’s degree in computer science

Rangam Consultants is a minority, women-owned, disability workforce solutions global organization. Specialized in attracting and retaining talents globally for a rewarding career in IT, Engineering, Scientific, Clinical, Healthcare, Administrative, Finance, Business Management, and many more, while integrating veterans and individuals with disabilities into the workforce. Indeed, we connect career aspirants to relevant job opportunities, be it jobs in USA, UK, India, or Ireland. Also remote jobs, work-from-home jobs, or contract jobs in different verticals and industries.
Rangam strives to put job seekers first, giving them free access to search for jobs, post resumes, and research companies.Every day, we connect millions of people to new opportunities.