Find Your Next Opportunity
Direct Hire, Contract, Contract to Hire
- Start your job search below
- Filter by Location, Remote Jobs, Keywords, and more. Save your keyword searches for automated notifications when new jobs are added.
- Apply!
ERP Data ETL Specialist - Virtual
Mahwah, NJ 07430 US | Fully Remote TELECOMMUTE US
Job Description
Our client, a Global Leader in the Medical Device Industry has an immediate opening for a ERP Data ETL Specialist for a 12 month + Contract. Our client offers results-driven people a place where they can make a difference - every day! You will also have the opportunity to work with other like-minded, self-directed and detail oriented Top Talents in an extremely collaborative and professional environment.
Position Description (Principle Duties and Responsibilities)
- This role will align to business process areas to support the data conversion and readiness activities to prepare for the ERP systems deployment/go live.
- Support data cleansing (correction in legacy system) and data construction (the collection of 'new' data)
- Support data validation activities
- Monitors and responds to Data Readiness Reports
- Participates in Cutovers and DLs responding to 'Tap'emails.
- Partner with program on data load templates to ensure readiness.
- Work with the team to capture test data sets required for proper testing scenarios.
- Support testing efforts as needed.
- Proficiency in Microsoft programs including excel is required as well as the ability to create formulas to support data analysis. MUST KNOW EXCEL POWER QUERY.
Job Requirements
Requirements
Must be able to show experience in past roles in the following;
- Excel Power Query
- Data Transformation: Ability to clean, transform, and reshape data from various sources.
- Query Development: Proficiency in creating complex queries using the Power Query editor.
- Data Importing: Experience in importing data from multiple sources (Excel files, CSVs, databases, web services).
- Advanced Excel Skills:
- Formulas and Functions: Strong understanding of advanced Excel formulas and functions (e.g., VLOOKUP, INDEX/MATCH, SUMIFS, etc.).
- PivotTables and PivotCharts: Ability to create and manipulate PivotTables and PivotCharts for data analysis.
- Conditional Formatting: Knowledge of applying conditional formatting to highlight key data points.
- Data Analysis:
- Statistical Analysis: Basic understanding of statistical methods and their application in Excel.
- Data Visualization: Skills in creating charts and graphs to visualize data insights effectively.
- Power BI (optional but beneficial):
- Integration with Power Query: Familiarity with Power BI for more advanced data modeling and reporting.
- Report Development: Ability to create interactive dashboards and reports.
- Scripting and Automation:VBA (Visual Basic for Applications):
- Proficiency in writing VBA macros to automate repetitive tasks.
- M Language: Understanding of the M language for advanced data transformations in Power Query.
- Database Skills:
- SQL Knowledge: Basic SQL skills to query databases and extract necessary data.
- Data Connectivity: Experience with connecting Excel to external databases and data sources.
Contract positions
Will be employed and paid hourly by iMPact Business Group. Benefits (medical, dental & vision) are available after 90 days of employment.
Permanent placed employees
Paid by and qualify for benefits in accordance with the policies of the hiring company.
Submit your resume today to be considered for this position. A recruiter will review within a business day or two and will reach back out to you if they would like to discuss next steps.
Internal Positions
We have several internal positions at iMPact that we are hiring for. Please view our internal positions here.
- Recruiters
- Account Managers
Learn more about working with iMPact Business Group
Share This Job:
Related Jobs:
About Mahwah, NJ
Are you sure you want to apply for this job?
Please take a moment to verify your personal information and resume are up-to-date before you apply.