ZipRecruiter

Log In

2

Full Time Excel Data Analyst Jobs in Springfield, MA

State of Connecticut

Health Care Analyst

Hartford, CT · On-site

$106K/yr

SCHEDULE: Full-Time, 40 Hours per Week, First Shift, Monday through Friday, 8:00am - 4:30pm (Up to ... Research and analyze data that is received from providers and that is released for billing;

STI

Data Scientist

Hartford, CT · On-site

... analytics software and platforms (GA, GTM, SPSS, Excel, Microsoft Office Suite) • Experience using business intelligence tools like Tableau or Power BI • Experience in data collection from on ...

Okaya Corp.

Business Analyst

Hartford, CT · On-site

A bachelor's degree in business IT / Computer Science or a related field is standard, Agile, Business analysis, Data analysis skills, Jira, Microsoft Excel, Proven experience in eliciting ...

Milliman

Actuarial Analyst (CMH Health)

Windsor, CT

$60K - $136K/yr

  • Medical

  • Dental

  • Vision

  • Life

  • Retirement

  • PTO

Perform data analysis using Excel, SAS, and proprietary Milliman programs to assist with consulting ... Full-time employees accrue 15 days per year, and employees working less than full-time accrue PTO ...

New

The Hartford

Sr. Data Engineer - Hybrid

Hartford, CT · Hybrid

$117K - $175K/yr

To excel in this role, you must be proficient in writing complex SQL transformations. You should also have experience in data analysis, requirements gathering, data modeling, and process design, with ...

CVS Health

Senior Analyst, Actuarial (ADP)

Hartford, CT

$79K - $158K/yr

  • Medical

  • Dental

  • Vision

  • Retirement

  • PTO

... data preparation and validation efforts * Use Excel, VBA, Power Query, and Power BI to develop ... This fulltime position is eligible for a comprehensive benefits package designed to support the ...

IFG Companies

Senior Actuarial Analyst

Hartford, CT · On-site

$100K - $130K/yr

  • Medical

  • Dental

  • Vision

  • Life

  • Retirement

  • PTO

Utilizing tools such as Excel, SQL and Python to analyze data, streamline workflows and improve data quality and efficiency. * Creating and maintaining documentation that adheres to the high ...

previous pagenext page

Showing results 21-40

All JobsExcel Data Analyst JobsFull Time Excel Data Analyst JobsFull Time Excel Data Analyst Jobs in Springfield, MA

Full Time Excel Data Analyst information

See Springfield, MA salary details

$33.9K

$82.4K

$135.5K

How much do full time excel data analyst jobs pay per year?

As of Aug 16, 2026, the average yearly pay for full time excel data analyst in Springfield, MA is $82,351.00, according to ZipRecruiter salary data. Most workers in this role earn between $62,300.00 and $96,700.00 per year, depending on experience, location, and employer.

What are the key skills and qualifications needed to thrive as a full time Excel data analyst, and why are they important?

To thrive as a Full Time Excel Data Analyst, you need strong analytical skills, advanced proficiency in Microsoft Excel, and a background in data management or a related field such as statistics or business. Familiarity with Excel functions, pivot tables, data visualization tools, and sometimes supplementary software like SQL or Power BI is commonly required. Attention to detail, problem-solving abilities, and effective communication are vital soft skills for interpreting data and conveying insights to stakeholders. These skills are crucial for ensuring accurate data analysis, informed business decisions, and efficient workflow in data-driven environments.

What are some common challenges faced by full time Excel data analysts and how can they be addressed?

Full Time Excel Data Analysts often encounter challenges such as managing large datasets that can slow down spreadsheet performance, ensuring data accuracy, and maintaining version control when collaborating with team members. To address these, it's important to master advanced Excel functions (like pivot tables, Power Query, and VBA), use data validation techniques to minimize errors, and leverage shared drives or cloud-based platforms for collaborative work. Staying organized and documenting processes also helps streamline workflows and reduces miscommunication within teams.

What does a full time Excel data analyst do?

A Full Time Excel Data Analyst is responsible for collecting, organizing, and analyzing data using Microsoft Excel. They use advanced Excel functions and tools—such as pivot tables, formulas, and charts—to identify trends, create reports, and support business decisions. Their work often involves cleaning large datasets, ensuring data accuracy, and presenting insights to stakeholders. This role requires strong analytical skills, attention to detail, and proficiency in Excel.

Is full time excel data analyst a high paying job?

Full-time Excel data analysts can earn competitive salaries, especially with strong skills in data manipulation, visualization, and proficiency in tools like Excel and SQL. Salaries vary based on experience, industry, and location, but they are generally considered to be moderate to high within data-related roles.

What are the most commonly searched types of Excel Data Analyst jobs in Springfield, MA?

The most popular types of Excel Data Analyst jobs in Springfield, MA are:

Full Time Excel Data Analyst jobs near you

Health Care Analyst

State of Connecticut

Hartford, CT • On-site

$106K/yr

Full-time

Posted 4 days ago

Job description

Introduction
Do you have experience in financial management with some experience in health care management?
Join our team as a Health Care Analyst to make an impact and lead with excellence!
THE POSITION
The State of Connecticut, Department of Mental Health and Addiction Services (DMHAS) is now hiring for a Health Care Analyst to join their team!
HIGHLIGHTS
  • FACILITY: DMHAS Office of the Commissioner (OOC)
  • LOCATION: 410 Capitol Ave, Hartford, CT
  • SCHEDULE: Full-Time, 40 Hours per Week, First Shift, Monday through Friday, 8:00am - 4:30pm (Up to 5 days in office during probation period. Hybrid schedule after probation period)
    • There is some flexibility to work remote during the probationary period.
  • POSITION NUMBER: 125998

WHAT WE CAN OFFER YOU
  • Visit our new State Employee Benefits Overview page!
  • Professional growth and development opportunities
  • A healthy work/life balance to all employees

DISCOVER THE OPPORTUNITY TO
  • Ensure the Medicare and Medicaid billing associated with billable Inpatient and Outpatient services provided by 7 DMHAS state operated facilities and 40+ private non-profit contracted DMHAS agencies is maximized and done in accordance with state and federal guidelines;
  • Research and analyze data that is received from providers and that is released for billing;
  • Analyze reports for further billable opportunities;
  • Complete paid and denied claims analysis through review of Explanation of Benefits;
  • Work closely with program and quality staff who provide and monitor service delivery;
  • Provide training to staff of state agencies and private non-profit agencies;
  • Prepare regular and special project data reports that analyze service delivery, billing and revenue data;
  • Conduct ongoing research of billing opportunities to increase revenue;
  • Produce reports routinely requested by DSS, OPM, state legislature, CMS and other agencies;
  • Work closely with state facilities and private agencies, assisting in their understanding of billing reports, requirements and billable service delivery;
  • Track Medicare and Medicaid enrollment of facilities and providers;
  • Ensure EHR implementation; and
  • Work closely with IT and DAS on system errors and on system changes including significant quality testing of systems.

ABOUT US
DMHAS is a health care agency whose mission is to promote the overall health and wellness of persons with behavioral health needs through an integrated network of holistic, comprehensive, effective, and efficient services and supports that foster dignity, respect, and self-sufficiency in those we serve.
PLEASE NOTE
  • A comprehensive medical examination, including a drug screening, will be required of all applicants upon a conditional offer of employment.
  • All state employees must adhere to Connecticut's Policy for a Drug Free Workplace.

Selection Plan
FOR ASSISTANCE IN APPLYING:
Check out our Applicant Tips on How to Apply! Need more resources? Visit our Applicant Toolkit for additional support throughout the recruitment process.
BEFORE YOU APPLY:
  • Meet Minimum Qualifications: Ensure you meet the Minimum Qualifications listed on the job opening by the job closing date. You must specify your qualifications on your application. The minimum experience and training requirements listed must be met by the close date on the job opening, unless otherwise specified.
  • Educational Credits: List your earned credits and degrees from accredited institutions accurately on your application. To receive educational credits towards qualification, the institution must be accredited. If the institution of higher learning is located outside of the U.S., you are responsible for providing documentation from a recognized USA accrediting service which specializes in determining foreign education equivalencies to the contact listed below by the closing date listed on the job posting.
  • Resume Policy: Per Public Act 21-69, resumes are not accepted during the initial application process. As the recruitment process progresses, candidates may be required to submit additional documentation to support their qualification(s) for this position. This documentation may include: a cover letter, resume, transcripts, diplomas, performance reviews, attendance records, supervisory references, licensure, etc., at the request and discretion of the hiring agency.
  • Preferred Shift/Location: Select all location(s) and shift(s) you are willing to work on your application. Failure to do so may result in not being considered for vacancies in that specific location or shift.
  • Timely Submission: All application materials must be received by the job posting deadline. You will be unable to make revisions once you officially submit your application to the State. Late submissions are rarely accepted, with exceptions only for documented events that incapacitate individuals during the entire duration of the job posting. Request exceptions by emailing DAS.SHRM@ct.gov.
  • Salary Calculations: For current state employees, salary calculations are not necessarily comparable from one of the three branches of state government (i.e., Executive, Legislative, Judicial) to the other.
  • Note: The only way to apply to this posting is via the 'Apply' or 'Apply Online' buttons on the official State of Connecticut Online Employment Center job posting.

AFTER YOU APPLY:
  • Some email providers may experience delays or issues delivering messages. To avoid missing important updates-such as referral questionnaires or interview scheduling links-please check your Personal Status Board regularly.
  • For added convenience, you can also enable text (SMS) notifications. To do this, log in to your Personal Status Board and select "Update My Contact Information."
  • Referral Questions: This posting may require completion of additional Referral Questions (RQs), which must be completed by the questionnaire's expiration date. If requested, RQs can be accessed via an email sent to you after the job close date or by visiting your JobAps Personal Status Board (Certification Questionnaires section).
  • Prepare For An Interview: Interviews are limited to those whose experience and training are most aligned with the role. To prepare, review this helpful Interview Preparation Guide to make the best impression!
  • Stay connected! Log in daily to your JobAps Personal Status Board to track your status and check email (including spam/junk folders) for updates and tasks.
  • The immediate vacancy is listed above, however, applications to this recruitment may be used for future vacancies in this job class.
  • Note: This position will be filled in accordance with contractual language, reemployment, SEBAC, transfer, promotion and merit employment rules. Candidates who are offered and accept a position with the State of Connecticut are bound by the State Code of Ethics for Public Officials and State employees, available at www.ct.gov/ethics.
  • This employer may participate in E-Verify and will provide the federal government with your Form I-9 information to confirm work authorization.

QUESTIONS? WE'RE HERE TO HELP:
Due to high volume, we are unable to confirm receipt or provide status updates directly. For recruitment updates, please check your Personal Status Board and review our Frequently Asked Questions. If you have additional questions about the recruitment process, reach out to Julie Barker at Julie.Barker@ct.gov.
Join the State of Connecticut and take your next career step with confidence!
PURPOSE OF JOB CLASS (NATURE OF WORK)
In the Departments of Correction, Mental Health and Addiction Services, Public Health, Social Services or the Office of the State Comptroller, this class is accountable for independently performing a full range of tasks in the analysis of financial, utilization and management records of health care facilities and/or providers or health insurance providers.
EXAMPLES OF DUTIES
  • Reviews materials to determine compliance with requirements contained in Connecticut General Statutes and agency regulations;
  • Reviews and evaluates financial, utilization and management records of health care facilities and/or providers toward various ends;
  • Prepares financial, narrative and statistical reports;
  • Reviews findings and conclusions with audit staff and members of senior staff;
  • Performs special research projects as assigned;
  • Performs related duties as required.
DEPARTMENT OF PUBLIC HEALTH:
  • Reviews various health care facility and/or physician Certificate of Need applications;
  • Analyzes impact of proposals on other health care providers in Connecticut and makes recommendations;
  • Writes related documents and assists employees of higher grade in writing decisions;
  • Assists in preparing documentation for administrative hearings;
  • Researches and analyzes data in preparation of various health care industry reports;
  • Performs related duties as required.
DEPARTMENT OF SOCIAL SERVICES:
  • Analyzes and evaluates budget, expenditure, utilization, reimbursement rate setting and/or revenue issues within social services programs, including Medicaid;
  • Participates in public hearings and assists in conferring with representatives of facilities and outside experts;
  • Interacts, under guidance, with Office of the Attorney General in litigation including preparation of complete court records;
  • May review Certificate of Need applications for nursing facility, residential care homes and ICF/MR development;
  • Performs related duties as required.
DEPARTMENTS OF CORRECTION AND MENTAL HEALTH AND ADDICTION SERVICES:
  • Analyzes and evaluates budget, expenditure, utilization, rate setting and/or revenue issues within behavioral health;
  • Analyzes General Assistance authorizations and expenditures, rate setting scenarios and new methodologies;
  • Performs related duties as required.
OFFICE OF THE STATE COMPTROLLER:
  • Analyzes financial and utilization data from vendor and state records concerning state employees and retirees health care plans;
  • Answers inquiries from employees and retirees on issues of coverage and design pertaining to state health care plans;
  • Performs related duties as required.

KNOWLEDGE, SKILL AND ABILITY
  • Knowledge of
    • principles and practices of financial management including organization, administration, management, finance, budgeting, auditing and accounting;
    • health care industry;
  • Skills
    • interpersonal skills;
    • oral and written communication skills;
  • Ability in interpretation and analysis of complex financial, statistical and technical data;
  • Ability to utilize computer software.

MINIMUM QUALIFICATIONS - GENERAL EXPERIENCE
Six (6) years of professional experience in financial management with some experience in health care management.
NOTE: Financial management is defined as professional accounting or auditing work with responsibility for the review and recommendation of financial policies and procedures of a business organization.
MINIMUM QUALIFICATIONS - SUBSTITUTIONS ALLOWED
  • College training may be substituted for the General Experience on the basis of fifteen (15) semester hours equalling one-half (1/2) year of experience to a maximum of four (4) years for a Bachelor's degree.
  • A Master's degree in accounting, finance or other closely related field or public health with some college courses in accounting or finance may be substituted for one (1) additional year of the General Experience.
  • Professional experience in health care facility administration, health program administration, health insurance administration, health planning or other health care related fields may be substituted for the General Experience on a year for year basis to a maximum of one (1) year.
  • Successful completion of a Connecticut Careers Trainee program approved by the Department of Administrative Services may be substituted for the General Experience.

PREFERRED QUALIFICATIONS
  • Inpatient and Outpatient Behavioral Health billing experience
  • Experience with Microsoft Access and/or Microsoft Excel software to create analytical reports using database queries
  • Experience with Microsoft Teams
  • Experience with Microsoft Excel functions such as formulas, pivot tables, and VLOOKUPs

Conclusion
AN AFFIRMATIVE ACTION/EQUAL OPPORTUNITY EMPLOYER
The State of Connecticut is an equal opportunity/affirmative action employer and strongly encourages the applications of women, minorities, and persons with disabilities.
ACKNOWLEDGEMENT
As defined by Sec. 5-196 of the Connecticut General Statutes, a job class is a position or group of positions that share general characteristics and are categorized under a single title for administrative purposes. As such, a job class is not meant to be all-inclusive of every task and/or responsibility.

Apply