ETL Developer, Senior

LOCATION: Geisinger Office Building I

DEPARTMENT: Data Management

WORK SCHEDULE: Days

WORK TYPE: Full Time (1.0 FTE)

JOB SUMMARY:

Geisinger Health is a leader in the healthcare space, well known for its innovative approaches in providing best patient care and member experience. Unified Data Architecture (UDA) is a latest generation data platform built on Big Data technology stack, well positioned to support Geisinger Health’s core motive of providing best patient care.

This is an opportunity to contribute to UDA platform which focuses on building and maintaining the Data/ETL pipelines on Big Data Platform (Hadoop) and related applications. Developer’s key responsibilities include integration of datasets from various data sources originating from RDBMS, NoSQL and Big Data technologies by leveraging the latest technologies/tools such as Hadoop, Hive, Spark (Scala or Python), NiFi and Kafka etc., Collaboration and participation in the design and implementation of various projects.

COMPETENCIES AND SKILLS:

Demonstrates creative and innovative thinking with a focus on novel approaches to solving computational and analytic challenges.

Demonstrates proficiency with large-scale databases and database languages (SQL, Hadoop, HBase, etc.).

Demonstrates the ability to provide ETL production support of critical data loads.

Demonstrates proficiency with one or more scripting languages (bash/shell, Python, Perl, PHP, Ruby, etc.). 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 working with large scale databases along with ETL/ELT processes/tools or general programming languages.

OR
Bachelor's degree in Computer Science, Statistics, Math, Business Systems or Information Systems required. Minimum of six years of IT experience in working with large scale databases along with ETL/ELT processes/tools or general programming languages.

Or
In lieu of degree, minimum of 11 years of IT experience in working with large scale databases along with ETL/ELT processes/tools or general programming languages.

Must have experience translating business requirements to technical specifications, creating mapping documents, developing ETL routines and testing ETL jobs.

If a suitably experienced candidate cannot be found, applicants who meet the basic qualifications but possess fewer years of experience will be considered for hire at a lower level.  Salary would commensurate with experience.

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.