Intern Project Scope

Lead ETL process for legacy BPL product pull through/end user salesCoordinate with IT to identify format and timeframe to loadUtilize data from UK to compile load fileValidate successful and accurate data loadReview customer master list for duplicates and opportunities to retireUtilize Snowflake SQL database to identify customer duplicates based on name & addressCompile list of duplicate accounts and contacts with suggestions for remediation (merge/delete/archive)Coordinate with IT and external data vendor to execute suggested remediationReview data structures for opportunities to optimize and consolidate dataDevelop data dictionary for Kedrion “Datamart” systemsIdentify gaps in the current data structure that will impede a unified reporting environmentWork with IT, external data vendor, and BI Sr Manager to suggest and execute solutions for these gapsSupport ad-hoc reporting and projects as needed

Requirements:

A current student in an undergrad/Masters program pursuing a Business degree or degree in Computer Science. 

The coop is over 6 months and must commit to specific hours in order to support the project

Candidate must be interested to learn basic coding 

Candidate should recognize that this is more of a data analytics/commercial coop opportunity versus an IT, Finance or Other opportunity

The coop can be hybrid out of the Fort Lee, NJ headquarters or fully remote based on where school is located. 

Please be advised that our organization participates in E-verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S.  For more information on E-verify, please contact the Dept. of Homeland Security.

Please note that salary ranges are calculated based off levels of: relevant experience, education and certifications.  For this role, it will be paid hourly. 

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status.