Data Analyst (Excel Specialist)

Smart Ims
Chester, Pennsylvania, United States
Remote
Full-time

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.

18 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
D Aceto Services LLC
Philadelphia, Pennsylvania

D Aceto Services LLC is seeking a motivated and detail-oriented Entry-Level Data Analyst to join our team. Help maintain data integrity and accuracy within databases. Proficient in Microsoft Excel; familiarity with data visualization tools (e. In this remote position, you will work closely with vari...

Promoted
RouteOne
Philadelphia, Pennsylvania

The Business Intelligence Analyst will be responsible for identifying trends, analyzing data, and preparing analytical and graphical reports for executive management. The Business Intelligence Analyst will be required to create and produce daily, monthly, and ad-hoc reports, as well as have the abil...

Promoted
Capital One
Upland, Pennsylvania

We are seeking Data Engineers who are passionate about marrying data with emerging technologies. Delaware Avenue (18052), United States of America, Wilmington, DelawareSenior Data Engineer (Bank Tech)Do you love building and pioneering in the technology space? Do you enjoy solving complex business p...

Promoted
Outcome Logix ( A Tech 50 Finalist company 2022, by Pittsburgh Technology Council )
Philadelphia, Pennsylvania
Remote

Write and execute SQL queries for data extraction, analysis, and reporting to support business needs. Collaborate with stakeholders to gather and document business requirements for accounting and treasury processes. Identify inefficiencies in current processes and work with teams to implement improv...

Promoted
PeopleShare
Philadelphia, Pennsylvania

The Data Entry Clerk will handle inbound calls and high speed data entry. Our openings include receptionist, data entry, customer service, collections, office managers, call center, administrative assistant, accounts payable clerk, accounts receivable clerk, file clerk, warehouse, assembly, producti...

Promoted
Reli.
Philadelphia, Pennsylvania
Remote

We are seeking an Administrative Assistant who is highly organized, detail-oriented, and has excellent communication skills. As an Administrative Assistant, you will play a key role in supporting our team and ensuring the smooth operation of our office. Providing general administrative support to th...

Promoted
Robert Half
Exton, Pennsylvania

We are seeking a Data Analyst for our team located in Exton, Pennsylvania. Utilizing data analysis tools and software, such as Apache Spark, Atlassian Jira, BusinessObjects Technologies, Erwin Data, Gap Analysis, AB Testing, Agile Scrum, Analytics, and Business Intelligence (BI). The role involves i...