Data Analyst

1 month ago

Mahwah, United States Kelly Science, Engineering, Technology & Telecom Full time

Job Title: Analyst, IS Business Support

Pay rate: $35 - $39 per hour

Duration: 12 months

W2 contract only (No C2C)

Location- Mahwah, NJ


When looking for a contractor with Excel and analytics skills, consider the following key competencies:


  • Align with business process areas to support data conversion and readiness activities for ERP systems deployment/go live.
  • Support data cleansing (correction in legacy system) and data construction (collection of “new” data).
  • Support data validation activities.
  • Monitor and respond to Data Readiness Reports.
  • Participate in Cutovers and DLs, responding to “Tap” emails.
  • Partner with the 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.
  • Must be able to create formulas to support data analysis.
  • Must know Excel Power Query.


1. 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).

2. Advanced Excel Skills:

  • Formulas and Functions: Strong understanding of advanced Excel formulas and functions (e.g., VLOOKUP, INDEX/MATCH, SUMIFS).
  • 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.

3. Data Analysis:

  • Statistical Analysis: Basic understanding of statistical methods and their application in Excel.
  • Data Visualization: Skills in creating charts and graphs to effectively visualize data insights.

4. 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.

5. 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.

6. Database Skills:

  • SQL Knowledge (Optional): Basic SQL skills to query databases and extract necessary data.
  • Data Connectivity: Experience with connecting Excel to external databases and data sources.

7. Soft Skills:

  • Problem-Solving: Strong analytical and problem-solving skills.
  • Attention to Detail: Meticulous attention to detail for data accuracy and integrity.
  • Communication: Ability to communicate findings and insights clearly to stakeholders.


These competencies will ensure the contractor can effectively handle data-related tasks, transform and analyze data, and provide actionable insights.


*** If this position may be interested to you, please email me back at somp767@kellyservices.com (with your most up to date resume in word format) and advise the best time and number at which you can be reached****

  • Data Business Analyst

    1 month ago

    Mahwah, United States Ledgent Technology Full time

    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...

  • Data Business Analyst

    1 month ago

    Mahwah, United States Ledgent Technology Full time

    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...

  • Sr Business Analyst

    3 weeks ago

    Mahwah, United States The Computer Merchant, LTD. Full time

    Job Description: Senior Business Systems Analyst Location: Mahwah, NJ or Sandy Springs, GA - Onsite Wage Range: 40-41/hr W2 OR $48/hr C2C Job Number:UPS-REQ-0022029 5 Year Contract Senior Business Systems Analysis About this role: The Schedule, Time and Pay program is looking for a Senior Business Systems Analyst to support various activities of this...

  • Data Analyst

    1 month ago

    Mahwah, United States Comrise Full time

    OverviewSummary: Encompasses the application of scientific, technological, and mathematical principles to determine the most effective way for a manufacturing organization to use people, materials, equipment, information, and energy to make a product. Plans plant, office, and production facilities and equipment layouts; determines the most efficient sequence...

  • Sr Business Analyst

    3 weeks ago

    Mahwah, United States The Computer Merchant Full time

    Job Description: Senior Business Systems Analyst Read all the information about this opportunity carefully, then use the application button below to send your CV and application. Location: Mahwah, NJ or Sandy Springs, GA - Onsite Wage Range: 40-41/hr W2 OR $48/hr C2C Job Number:UPS-REQ-0022029 5 Year Contract Senior Business Systems Analysis About this role:...

  • Cyber Intelligence Analyst

    3 weeks ago

    Mahwah, United States UNITED PARCEL SERVICE Full time

    Explore your next opportunity at a Fortune Global 500 organization. Envision innovative possibilities, experience our rewarding culture, and work with talented teams that help you become better every day. We know what it takes to lead UPS into tomorrow—people with a unique combination of skill + passion. If you have the qualities and drive to lead yourself...

  • Sales Operations Analyst

    2 weeks ago

    Mahwah, New Jersey, United States Aston Carter Full time

    *** Opportunity to work FULLY REMOTE for one of the largest national medical device companies *** Description: The Sales analytics team is currently inundated with a special project that is taking up the analysts time. They need to bring in a consultant to help support the overall workflow and help them get work done as they are pulled into the project. This...

  • Compliance Payment Processing Analyst

    3 weeks ago

    Mahwah, United States Stryker Corporation Full time

    **Why join Stryker?** **Who we want**: - ** Dedicated achievers.** People who thrive in a fast-paced environment and are driven to complete projects that meet regulations and expectations. - ** Self-directed initiators.** People who take ownership of their work and need no prompting to drive productivity, change, and outcomes. - ** Data managers.** People...

  • School Services

    2 weeks ago

    Mahwah, United States Therapy Staff EDU Full time

    Therapy Staff EDU is seeking a School Services Board Certified Behavioral Analyst (BCBA) for a local contract job in Mahwah, New Jersey.Job Description & RequirementsSpecialty: Board Certified Behavioral Analyst (BCBA)Discipline: School ServicesStart Date: 07/31/2024Duration: 36 weeks40 hours per weekShift: 8 hours, daysEmployment Type: Local ContractAequor...

  • School Services

    2 weeks ago

    Mahwah, United States Therapy Staff EDU Full time

    Job DescriptionTherapy Staff EDU is seeking a School Services Board Certified Behavioral Analyst (BCBA) for a local contract job in Mahwah, New Jersey.Job Description & RequirementsSpecialty: Board Certified Behavioral Analyst (BCBA)Discipline: School ServicesStart Date: 07/31/2024Duration: 36 weeks40 hours per weekShift: 8 hours, daysEmployment Type: Local...

  • Lead Financial Analyst

    5 days ago

    Mahwah, United States Stryker Full time

    We are excited to be named one of the World’s Best Workplaces by Fortune Magazine! We are proud to offer you 12 paid holidays annually. For an overview of our benefits and time off, please follow this link to learn more:US Stryker employee benefits....

  • Lead Financial Analyst

    2 weeks ago

    Mahwah, United States Stryker Full time

    Work Flexibility: Hybrid *This position will operate on a hybrid schedule where the candidate will be on-site at our Mahwah, NJ 2-3 days/week As a Lead Analyst, Finance you will serve as a key member supporting the Knee business unit, actively contributing to crafting and executing strategies aimed at fostering growth, enhancing profitability, and expanding...

  • Pricing / Rebate Analyst - VIrtual

    4 weeks ago

    Mahwah, United States iMPact Business Group Full time

    Job Description Our client, a Global Leader in the Medical Device Industry has an immediate opening for a Pricing / Rebate Analyst 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...

  • Local Contract School Services

    3 weeks ago

    Mahwah, United States Therapy Staff EDU Full time

    Therapy Staff EDU is seeking a School Services Board Certified Behavioral Analyst (BCBA) for a local contract job in Mahwah, New Jersey.Job Description & RequirementsSpecialty: Board Certified Behavioral Analyst (BCBA)Discipline: School ServicesStart Date: 07/31/2024Duration: 13 weeks40 hours per weekShift: 8 hours, daysEmployment Type: Local ContractAequor...

  • Sales Operations Analyst

    2 weeks ago

    Mahwah, United States Stryker Corporation Full time

    **Why join Stryker?** The Sales Compensation Analyst will engage in key business partnerships with field sales leadership to develop incentive compensation plans and territory structures that drive growth and support Stryker’s strategic sales objectives. **Who We Want**: - ** Strategic thinkers. **People who enjoy analyzing data or trends for the...

  • Sales Operations Analyst

    2 weeks ago

    Mahwah, United States Stryker Full time

    Why join Stryker?We are proud to be named one of the World’s Best Workplaces and a Best Workplace for Diversity by Fortune Magazine! Learn more about our award-winning organization by visiting *This is a hybrid schedule role with an expectation to be on-site at our Mahwah, NJ facility 50% of the time.The Sales Operations Rotational Program gives talented...

  • Senior Guardium Database Security Analyst

    3 weeks ago

    Mahwah, United States UPS Full time

    Before you apply to a job, select your language preference from the options available at the top right of this page. Explore your next opportunity at a Fortune Global 500 organization. Envision innovative possibilities, experience our rewarding culture, and work with talented teams that help you become better every day. We know what it takes to lead UPS...

  • Sr Financial Analyst

    1 month ago

    Mahwah, United States Ascena Retail Group Full time

    About us KnitWell Group, a specialty retail operating company, comprises some of the most iconic brands in America - Ann Taylor, LOFT, Lane Bryant, and Talbots. Individually, our brands are unique and strong. Together, we are powerful. Our common thread is our commitment to create exceptional products, provide memorable experiences, and achieve superior...

  • Intermed Data Repos Analyst I 20e

    3 weeks ago

    Mahwah, United States UNITED PARCEL SERVICE Full time

    Explore your next opportunity at a Fortune Global 500 organization. Envision innovative possibilities, experience our rewarding culture, and work with talented teams that help you become better every day. We know what it takes to lead UPS into tomorrow—people with a unique combination of skill + passion. If you have the qualities and drive to lead yourself...

  • Contracts Analyst

    1 month ago

    Mahwah, United States Aston Carter Full time

    Description: These two positions will be focused on the contract activation side of the contract life cycle. They are not going to be having a back and forth with the custoemrs but once the deals are signed they are going to set up and activate the deals in the system. They will upload the pricing and handle the pricing files. There is a lot of work inside...