Participates in the development and maintenance of ETL processes that move data from operational systems to a Data Warehouse. Responsibilities include design, code, test, and production deployment and support of the ETL workflow. Responsible for configuration, tuning and implementation of ETL processes. Responsible for integrating the ETL tools with applications, web services, and/or data transport utilities. Has a deep technical understanding of at least one major rdbms platform. Has mentored more junior developers.
COMPETENCIES AND SKILLS:
Demonstrates working knowledge of more than one major RDBMS (excluding Access) platforms and operating systems.
Demonstrates the ability to provide ETL production support of critical data loads, Informatica workflow creation and administration, performance tuning of queries and data loads.
Demonstrates strong UNIX scripting skills. Able to mentor less senior developers.
Demonstrates ability to design and develop complex database load and maintenance processes.
Demonstrates ability to organize, prioritize work, meet deadlines, and work independently.
Must possess excellent verbal and written communication skills along with excellent administrative and facilitation skills. Must be able to communicate difficult/sensitive information in a diplomatic and tactful way.
Works on projects of moderate to high complexity across two or more development environments. Works on multiple projects as a project team member. Considered a subject matter expert for a single business area or system. May coach more junior developers.
Demonstrates strong problem-solving skills. Able to determine tasks necessary to get a job done. Works independently.
EDUCATION AND EXPERIENCE:
Master’s degree in Computer Science, Statistics, Math, Business Systems or Information Systems required. Minimum of three years of experience in developing database load processes with database procedural languages, general programming languages, or an engine based ETL tool (Informatica, etc.).
Bachelor's degree in Computer Science, Statistics, Math, Business Systems or Information Systems required. Minimum of six years of IT experience related to ETL, with participation on at least one full life-cycle Business Intelligence/Data Warehouse project required.
In lieu of degree, minimum of 11 years of IT experience related to ETL, with participation on at least three full life-cycle Business Intelligence/Data Warehouse project required.
Must have experience translating business requirements to technical specifications, creating mapping documents, developing ETL routines and testing ETL jobs.
Experience in health care or health payer systems is required.
WORKING CONDITIONS/PHYSICAL DEMANDS:
Work is typically performed in an office environment with occasional travel to different buildings. Mostly sedentary work interacting with computers and people. Requires ability to perform visual inspection and lifting less than 10 pounds.
OUR PURPOSE & VALUES: Everything we do is about caring for our patients, our members, our students, our Geisinger family and our communities. KINDNESS: We strive to treat everyone as we would hope to be treated ourselves. EXCELLENCE: We treasure colleagues who humbly strive for excellence. LEARNING: We share our knowledge with the best and brightest to better prepare the caregivers for tomorrow. INNOVATION: We constantly seek new and better ways to care for our patients, our members, our community, and the nation.
ABOUT GEISINGER: Geisinger is a physician-led health system comprised of approximately 30,000 employees, including nearly 1,600 employed physicians, 13 hospital campuses, two research centers, and a 583,000-member health plan Geisinger is nationally recognized for innovative practices and quality care. Geisinger serves more than 3 million people in central, south-central and northeast Pennsylvania and also in southern New Jersey with the addition of National Malcolm Baldridge Award recipient AtlantiCare, A member of Geisinger. In 2017, the Geisinger Commonwealth School of Medicine became the newest member of the Geisinger Family.
We offer healthcare benefits for full time and part time positions from day one, including vision, dental and domestic partners. * Perhaps just as important, from senior management on down, we encourage an atmosphere of collaboration, cooperation and collegiality. For more information, visit www.geisinger.org, or connect with us on Facebook, Instagram, LinkedIn and Twitter.
** Does not qualify for J-1 waiver. We are an Affirmative Action, Equal Opportunity Employer Women and Minorities are Encouraged to Apply. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of disability or their protected veteran status.
*Domestic partner benefits not applicable at Geisinger Holy Spirit.
At Geisinger, our innovative ideas are inspired by the communities we serve – like our Fresh Food
Farmacy, a program that delivers life-saving healthy alternatives to patients with diabetes. With additional tools like our MyCode Community Health Initiative, one of the first health system genome sequencing
programs, and our new asthma app suite that we developed in partnership with AstraZeneca, it’s no wonder we’re ranked one of the Top 5 Most Innovative Healthcare Systems by Becker's Hospital Review. We continually work towards continuous improvement in a culture where everyone has a voice and firmly believe that better begins with all of us.
Founded more than 100 years ago, Geisinger serves more than three million residents throughout central, south-central and northeastern Pennsylvania and southern New Jersey. Our physician-led system is comprised of 30,000 employees, including 1,600 employed physicians, and consists of 13 hospital campuses, the Geisinger Health Plan, Geisinger Commonwealth School of Medicine and two research centers.
What you do at Geisinger shapes the future of health and improves lives – for our patients, communities, and you.