Find Your Next Opportunity

Direct Hire, Contract, Contract to Hire

  1. Start your job search below
  2. Filter by Location, Remote Jobs, Keywords, and more. Save your keyword searches for automated notifications when new jobs are added.
  3. Apply! 

ERP Data ETL Specialist - Virtual

Mahwah, NJ 07430 | Fully Remote

Posted: 06/13/2024 Job Type: Contract Industry: IT Job Number: 25275 Pay Rate: $ 42.00 - $ 42.00

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. 
Apply Online
Apply with LinkedIn Apply with Facebook Apply with Twitter

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

About Mahwah, NJ

Discover exciting job opportunities in the vibrant area surrounding Mahwah, New Jersey! Nestled among beautiful parks like Ramapo Valley County Reservation and Ringwood State Park, this region offers a perfect balance of nature and urban attractions. With easy access to New York City and renowned landmarks like the Ramapo Valley County Reservation and Suffern Railroad Museum, Mahwah is a hub for culture and adventure. Don't miss out on the chance to explore new career paths while enjoying the unique charm and endless growth opportunities this area has to offer. Check out our job listings today and take the next step towards an exciting career in Mahwah!