Data Analyst (Excel & analytics) Job Listing at Kelly Services in Mahwah, NJ (Job ID 9419701)

Description

Job Title: Analyst, IS Business Support 
Pay rate: $35 - $39 per hour
Duration: 12 months
W2 contract only (No C2C)
Location- Mahwah, NJ
 

• 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****
 

As part of our promise to talent, Kelly supports those who work with us through a variety of benefits, perks, and work-related resources. Kelly offers eligible employees voluntary benefit plans including medical, dental, vision, telemedicine, term life, whole life, accident insurance, critical illness, a legal plan, and short-term disability. As a Kelly employee, you will have access to a retirement savings plan, service bonus and holiday pay plans (earn up to eight paid holidays per benefit year), and a transit spending account. In addition, employees are entitled to earn paid sick leave under the applicable state or local plan. Click here for more information on benefits and perks that may be available to you as a member of the Kelly Talent Community.

Why Kelly® Technology?

Looking to put your tech expertise to work on today's most intriguing, innovative, and high-visibility projects? By partnering with Kelly Technology, you'll gain direct connections to top companies around the globe. Our team creates expert talent solutions to solve the world's most critical challenges. In a world where change is the only constant, our extensive network of industry relationships and IT market expertise help you take your skills exactly where you want to go. We're here to help you gain experience, make an impact, and grow your tech career.

About Kelly

Work changes everything. And at Kelly, we're obsessed with where it can take you. To us, it's about more than simply accepting your next job opportunity. It's the fuel that powers every next step of your life. It's the ripple effect that changes and improves everything for your family, your community, and the world. Which is why, here at Kelly, we are dedicated to providing you with limitless opportunities to enrich your life—just ask the 300,000 people we employ each year.

Kelly Services is proud to be an Equal Employment Opportunity and Affirmative Action employer. We welcome, value, and embrace diversity at all levels and are committed to building a team that is inclusive of a variety of backgrounds, communities, perspectives, and abilities. At Kelly, we believe that the more inclusive we are, the better services we can provide. Requests for accommodation related to our application process can be directed to Kelly's Human Resource Knowledge Center. Kelly complies with the requirements of California's state and local Fair Chance laws. A conviction does not automatically bar individuals from employment.

 Apply on company website