-
Intl - ETL Consultant
- Insight Global (New York, NY)
-
Job Description
Our pharmaceutical client is seeking an ETL Consultant to support the migration of risk files from Excel to SQL database that their PLM (Windchill) leverages. This person will be responsible for:
Interpreting and transforming source risk files (HA, xFMEA, UTAs) per MDCP into Windchill Reliability & Risk (WRR)-importable formats.
Ensure contextual alignment between source and target data structures.
Collaborate with MDCP SMEs to validate transformation logic and assumptions.
Transform 5-6 risk files every 2-3 days (depending on volume of each file)
Serve as the SME for data migration, system integration, and process optimization efforts.
Analyze legacy systems and data structures to develop transformation roadmaps.
We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to Human Resources Request Form (https://airtable.com/app21VjYyxLDIX0ez/shrOg4IQS1J6dRiMo) . The EEOC "Know Your Rights" Poster is available here (https://www.eeoc.gov/sites/default/files/2023-06/22-088\_EEOC\_KnowYourRights6.12ScreenRdr.pdf) .
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .
Skills and Requirements
2+ years experience providing ETL migration support from Excel to SQL databases
Experience with enterprise systems such as ERP, PLM, CRM (PTC Windchill preferred)
Ability to translate technical data into business-relevant insights.
Familiarity with regulatory and quality implications of risk documentation.
Microsoft 365 tools (Excel, Word, SharePoint)
Experience migration SQL databases
Excellent communication skills Pharma or medical device industry
PTC Windchill Platform: Windchill Risk & Reliability (WRR) module
Macros and Python scripting null
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [email protected].
-
Recent Jobs
-
Intl - ETL Consultant
- Insight Global (New York, NY)
-
Medical Assistant (MA) or Licensed Practical Nurse (LPN) - Outpatient Float Pool
- Truman Medical Centers (Kansas City, MO)
-
Mutual Fund Broker Trading Lead Specialist
- KeyBank (Brooklyn, OH)
-
Herriman Coordinator
- University of Utah (Salt Lake City, UT)