Our work matters. We help people get the medicine they need to feel better and live well. We do not lose sight of that. It fuels our passion and drives every decision we make.
Job Posting Title
Senior ETL Systems DeveloperJob Description
Excellent opportunity to join a team supporting the Enterprise data warehouse and data integrations. The Senior ETL Systems Developer is responsible for analyzing and evaluating existing jobs or proposing application systems to process data. This person should be proficient at prioritizing work tasks and have a strong interest in problem solving. The position will require collaboration with internal team members and stakeholders outside of the core team, including other technical specialists and business stakeholders. Utilizes a thorough understanding of available technology, tools, and existing designs. Works on complex problems where analysis of situations or data requires evaluation of intangible variance factors. Plans, performs, and acts as the escalation point for complex platform designs, coding, and testing.
+ Consult with System Analysts, Technical Leads, and Project Managers to establish specifications and estimations on complex initiatives and requests
+ Write detailed description of user needs, system design, program functions, and steps required to modify computer systems; review specifications with System Analysts, Technical Leads, and Business User to ensure compliance
+ Work with System Analysts, Technical Leads, and Business Users to develop and implement acceptance test plan to ensure product meets customer requirements and expectations
+ Assist technical staff on use of application systems software as needed; assist less experienced staff in user specifications, coding, testing, and debugging
+ Analyze source data/file structures, technical metadata, profile source data and develop data mapping and transformation rules and detail ETL specifications based on business requirements
+ Utilize automation tools to schedule, execute, and monitor ETL jobs. Design of ETL jobs
+ Design, test, and debug data flow plans to populated databases
+ Other duties as assigned
Required Minimum Qualifications:
+ Bachelor's degree in Computer Science or related area of study, or equivalent combination of education and/or relevant work experience; High School Diploma or GED equivalent required
+ 5 years of experience with application development or packaged software implementations including deep technical expertise with IBM InfoSphere DataStage tool suite or other similar tool in support of ETL applications including experience with relational databases and different operating systems
+ Must be eligible to work in the United States without need for work visa or residency sponsorship
+ Ability to work effectively in a cross-functional team and independently
+ Strong problem-solving and analysis skills
+ Ability to transition abstract concepts into stable and supportable software solutions
+ Ability to develop unbiased options and recommendations to technical problems and unbiased comparisons
+ Strong traits of decisiveness and judgment
+ Excellent documentation skills
+ Experience with DB2, Teradata, Unix, Robot or other scheduling tools
+ Experience working in environment with regulatory compliance requirements (HIPAA, PCI, etc.)
+ Previous experience in PBM / health care industry
+ Understanding of security implications of domain
Minimum Physical Job Requirements:
+ Ability to work a flexible schedule including weekends and shifts outside of Prime's core business hours of 9:00 a.m. to 3:00 p.m. as needed for technical support and/or project needs
+ Ability to travel up to 5% of the time
+ Constantly required to sit, use hands to handle or feel, talk and hear
+ Frequently required to reach with hands and arms
+ Occasionally required to stand, walk and stoop, kneel, and crouch
+ Occasionally required to lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds
+ Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus
+ Reports to a Manager in the Information Technology department
Prime Therapeutics LLC is an Equal Opportunity Employer. We encourage qualified minority, female, veteran, disabled, and other diverse candidates to apply and be considered for open positions.
Prime Therapeutics' fast-paced and dynamic work environment is ideal for proactively addressing the constant changes in today's health care industry. Our employees are involved, empowered, and rewarded for their achievements. We value new ideas and work collaboratively to provide the highest quality of care and service to our members.
If you are looking to advance your career within a growing, team-oriented, award-winning company, apply to Prime Therapeutics today and start making a difference in people's lives.
Prime Therapeutics LLC is an Equal Opportunity Employer. We encourage qualified minority, female, veteran, disabled, and other diverse candidates to apply and be considered for open positions. If you are an applicant with a disability and need a reasonable accommodation for any part of the employment process, please contact Human Resources at 1.866.469.1257 or email Careers@primetherapeutics.com.