Job Information
Kedrion Biopharma, Inc. Business Analyst Coop (July- December 2024) in Fort Lee, New Jersey
Intern Project Scope
Lead ETL process for legacy BPL product pull through/end user sales
Coordinate with IT to identify format and timeframe to load
Utilize data from UK to compile load file
Validate successful and accurate data load
Review customer master list for duplicates and opportunities to retire
Utilize Snowflake SQL database to identify customer duplicates based on name & address
Compile list of duplicate accounts and contacts with suggestions for remediation (merge/delete/archive)
Coordinate with IT and external data vendor to execute suggested remediation
Review data structures for opportunities to optimize and consolidate data
Develop data dictionary for Kedrion “Datamart” systems
Identify gaps in the current data structure that will impede a unified reporting environment
Work with IT, external data vendor, and BI Sr Manager to suggest and execute solutions for these gaps
Support 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.
Kedrion Biopharma, Inc.
- Kedrion Biopharma, Inc. Jobs