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. The EEOC "Know Your Rights" Poster is available
here.
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/ .
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
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.