Princeton University Hiring for ETL Data Integration Associate (Summer Experience) – Temporary at Nassau Hall Full Time

As the ETL Data Integration Associate, you will gain hands-on experience in the design, development, and maintenance of ETL processes using IBM DataStage and Python. As a member of the Center for Data, Analytics and Reporting (CeDAR) team, you will contribute to the enhancement of the Data Warehouse (Oracle D/B) sourcing into reporting and analytics tools. In this position, you will collaborate with experienced professionals in a dynamic and collaborative environment.

This position is part of Princeton’s Office of Informational Technology (OIT) Summer Experience Program. OIT is excited to welcome a cohort of undergraduate students to learn, explore, and gain professional experience in a variety of technical and administrative roles. All positions are sponsored by one of the six major departments within OIT, each specializing in a different area of information technology.

This is a temporary position.

Responsibilities

What you’ll be doing:  

• Working with the ETL data warehouse team to understand data requirements and design ETL processes for reporting and analytics platforms
• Developing, testing, and deploying ETL jobs using IBM DataStage to extract, transform, and load data into the Data Warehouse
• Writing Python scripts to communicate and extract data from vended REST APIs
• Assisting in troubleshooting and resolving issues related to data processing and integration
• Collaborating with cross-functional teams to understand business needs and translate them into effective ETL solutions
• Meeting with customers to review and iteratively develop data integration pipelines

Qualifications

Skills you bring to the table:  

• Programming skills in SQL and other scripting languages (Python, Java)
• Ability to quickly learn new software
• Excellent communication skills
• Ability to work both independently and as part of a team
• Ability to transform customer requirements into written specifications and deliverables
• Intellectual curiosity in taking an idea or concept and turning it into a deliverable product.
• Excitement for seeing data turned into insights

Skills you will gain:  

• Basic knowledge of ETL analysis, development, and data modeling
• Experience with the software development lifecycle (SDLC) and Agile methodologies for delivery and support maintenance.
• Knowledge of ETL IBM DataStage, Oracle, and data warehousing concept

The OIT Summer Experience Program is a great opportunity for undergraduate students enrolled at any accredited university or college. For more information, see Explore Our OIT Summer Experiences. 

Application requirements: 

OIT is accepting applications for summer experience positions through March 29.  All applications should include a cover letter, resume (or CV), transcripts from previous academic programs, and two letters of recommendation.

Tips: When completing the application, enter (or paste) your cover letter into the text box. Upload your resume (or CV) and academic transcripts to the ‘Other Documents’ field during the submission process. 

Letters of recommendation are due by March 29, however, it is recommended you submit them as soon as possible following application. Letters should be sent via email directly from the letter writer to the summer experience program email account at [email protected]. Letters received after March 29 will not be considered.

The final candidate will be required to successfully pass a background check.

Be advised that you will be contacted only if there is further interest in your application. Your candidate dashboard may not display status updates for this requisition.

Princeton University is an Equal Opportunity/Affirmative Action Employer and all qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity or expression, national origin, disability status, protected veteran status, or any other characteristic protected by law. KNOW YOUR RIGHTS

Standard Weekly Hours0.00Eligible for OvertimeYesBenefits EligibleNoProbationary PeriodN/AEssential Services Personnel (see policy for detail)NoPhysical Capacity Exam RequiredNoValid Driver’s License RequiredNo#LI-LO1