Job Title: Clinical Programmer (SAS) Duration: 4- 5 months (Possible extension) Location: Lawrenceville, NJ 08648/Hybrid Note: The candidate must be able to work 50% of the time onsite at Lawrenceville, so local candidates only
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)
Job Description: 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 1. 8+ years of experience with any ETL tool. 2. Minimum 5+ years of experience in SQL language. 3. Minimum 3+ years of experience with cloud technologies. 4. Minimum 3+ years of experience in SAS programming. 5. Minimum 5+ years of experience in shell scripting. 6. Good to have experience with ECS (eClinical Solution) ETL tool.
Education: Minimum bachelor’s degree in computer science
About Us: Established in 2004, SPECTRAFORCE® is one of the largest and fastest-growing diversity-owned staffing firms in the US. The growth of our company is a direct result of our global client service delivery model that is powered by our state-of-the-art A.I. proprietary talent acquisition platform, robust ISO 9001:2015/ISO 27001 certified processes, and strong and passionate client engaged teams. We have built our business by providing talent and project-based solutions, including Contingent, Permanent, and Statement of Work (SOW) services to over 140 clients in the US, Canada, Puerto Rico, Costa Rica, and India. Key industries that we service include Technology, Financial Services, Life Sciences, Healthcare, Telecom, Retail, Utilities and Transportation. SPECTRAFORCE is built on a concept of “human connection,” defined by our branding attitude of NEWJOBPHORIA®, which is the excitement of bringing joy and freedom to the work lifestyle so our people and clients can reach their highest potential. Learn more at: http://www.spectraforce.com
Benefits: SPECTRAFORCE offers ACA compliant health benefits as well as dental, vision, accident, critical illness, voluntary life, and hospital indemnity insurances to eligible employees. Additional benefits offered to eligible employees include commuter benefits, 401K plan with matching, and a referral bonus program. SPECTRAFORCE provides unpaid leave as well as paid sick leave when required by law.
Equal Opportunity Employer: SPECTRAFORCE is an equal opportunity employer and does not discriminate against any employee or applicant for employment because of race, religion, color, sex, national origin, age, sexual orientation, gender identity, genetic information, disability or veteran status, or any other category protected by applicable federal, state, or local laws. Please contact Human Resources at LOA@spectraforce.com if you require reasonable accommodation.
California Applicant Notice: SPECTRAFORCE is committed to complying with the California Privacy Rights Act (“CPRA”) effective January 1, 2023; and all data privacy laws in the jurisdictions in which it recruits and hires employees. A Notice to California Job Applicants Regarding the Collection of Personal Information can be located on our website. Applicants with disabilities may access this notice in an alternative format by contacting NAHR@spectraforce.com.
LA County, CA Applicant Notice: If you are selected for this position with SPECTRAFORCE, your offer is contingent upon the satisfactory completion of several requirements, including but not limited to, a criminal background check. We consider qualified applicants with arrest or conviction records for employment in accordance with all local ordinances and state laws, including the Los Angeles County Fair Chance Ordinance for Employers (FCO) and the California Fair Chance Act (FCA). The background check assessment will consider whether a criminal history could reasonably have a direct, adverse impact on the job-related safety, security, trust, regulatory compliance, or suitability for this role. Such findings may result in withdrawal of a conditional job offer.
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $55.00/hr.
