Data Analyst (Excel Specialist)

Smart Ims
Chester, PA, US
Full-time

Job Description

Job Description

Company Description

Job Description

We are seeking a skilled Data Analyst or Excel Power User with strong proficiency in Advanced Excel , specifically with VLOOKUP , Pivot Tables , and formula use.

The ideal candidate should have the ability to compare and manipulate data, sort, analyze, and transform it to match specified formats.

This role involves working with data from 401k, 403b, and other retirement plans .

Qualifications

Responsibilities :

  • Use Excel formulas to scrub, manipulate, and analyze data from prior record keepers (PRK) to fit the company’s format.
  • Collaborate with the Implementation Partner to ensure seamless data processing for new retirement plans.
  • Identify missing data and work with PRK to obtain any needed information.
  • Perform data entry tasks with high accuracy, ensuring the integrity of the information uploaded into our systems.
  • Ability to work in a fast-paced environment with close attention to detail.
  • Key Skills :
  • Strong knowledge of Excel , including VLOOKUP and Pivot Tables .
  • Critical thinking and problem-solving skills.
  • Attention to detail and the ability to manage large data sets.
  • Excellent written and verbal communication skills.
  • Ability to work efficiently and effectively in a high-paced environment.
  • Quick learner, with the capability to adapt to new tools and systems.

Additional Information

This is going to be an Remote role.

16 days ago
Related jobs
Promoted
Smart Ims
Chester, Pennsylvania

Use Excel formulas to scrub, manipulate, and analyze data from prior record keepers (PRK) to fit the company’s format. The ideal candidate should have the ability to compare and manipulate data, sort, analyze, and transform it to match specified formats. This role involves working with data fr...

Smart Ims
Chester, Pennsylvania
Remote

Use Excel formulas to scrub, manipulate, and analyze data from prior record keepers (PRK) to fit the company’s format. The ideal candidate should have the ability to compare and manipulate data, sort, analyze, and transform it to match specified formats. This role involves working with data from. Co...

finra
Philadelphia, Pennsylvania

The Associate Principal Analyst, in the Member Supervision Data & Analytics team is responsible for analyzing member firm data collected during examinations and investigations; and creating analytics that identify potential risks and weaknesses in the associated controls and compliance with memb...

Promoted
THE VANGUARD GROUP, INC. / MALVERN, PA
Malvern, Pennsylvania

Build machine learning, statistical, and artificial intelligence models to solve business problems; create slide decks and present to business leaders about new tools we create and the insights they generate; collaborate with other Data Scientists to improve outcomes of all data science projects; wo...

Promoted
Kelly
Eagleville, Pennsylvania

SERVICE DATA ENTRY CLERK IN EAGLEVILLE, PA!!. Why you should apply to be a Service Data Entry Clerk:. What’s a typical day as a Service Data Entry Clerk? You’ll be:. Have data entry experience and typing skills. ...

Promoted
Alivia Analytics
Newtown Square, Pennsylvania
Remote

Alivia Analytics is seeking a technically adept Data Scientist with a strong foundation in SQL, Python, and machine learning to join our rapidly expanding team focused on combating healthcare fraud. Exceptional skills in SQL and Python, with significant experience applying these tools in data analyt...

Promoted
Juno Search Partners - Open Positions
Chester Springs, Pennsylvania

Our client, a fast-growing & evolving startup company in Chester County, is seeking an Office .The ideal candidate will support the day-to-day operations of the office, using exemplary communication, organizational, and customer service skills.Answer and transfer incoming calls, take & relay...

Promoted
Align ENT & Allergy
Chester, Pennsylvania

Welcomes patients and visitors by greeting and directing them in a friendly, prompt and helpful manner.Instructs new patients in completion of medical history and information forms.Maintains accuracy of patient demographic and insurance information by verifying this information at each patient encou...

US012 Marsh & McLennan Agency LLC
King of Prussia, Pennsylvania

As a Senior Data Engineer on the MMA National IT Data and Analytics Team, we will count on you to develop and maintain scalable data pipelines, enhance data models, and provide subject matter expertise in data acquisition and consumption pipelines on Azure, Databricks and Confluent. In-depth underst...

ACRISURE
Wayne, Pennsylvania

In this role you will be responsible for providing administrative support to the team. This part-time position will include regular communication with clients via phone and email, processing requests for various insurance documents, and general administrative duties as needed. ...