Lead Data Analyst - fully in-person/onsite

Community Teamwork Inc

Lowell (MA)

On-site

USD 37,000 - 43,000

Full time

12 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

4 Weeks of Paid Time Off
Paid Sick Leave
12 paid holidays
Medical Insurance
Dental Insurance
Vision Insurance
Life Insurance
Tuition Reimbursement
401(k) retirement plan

Job summary

Community Teamwork, a private nonprofit in Lowell, MA, seeks a Lead Data Analyst for an entirely in-person role. The position handles data entry for housing programs, monthly payments, and accounts payable, ensuring data accuracy and regulatory compliance.

Responsibilities include preparing mandated reports, reconciling holds, reviewing payment forms, and aiding audits. Strong Excel, database experience, and confidentiality are essential.

Qualifications

  • High School Diploma and 2 years of related database experience.
  • Knowledge of basic accounting.
  • Desire to work with low income, culturally diverse, and at‑risk families and individuals.
  • Ability to manage multiple priorities and work in a fast-paced environment.
  • Proficient with Windows, Microsoft Word, Excel, or comparable software and tracking systems.
  • Excellent customer service, organizational, interpersonal, oral and written communication skills.
  • Strong attention to detail and analytical skills.
  • Ability to maintain accurate records and confidentiality of information.
  • Ability to respond to all correspondence in a timely manner.

Responsibilities

  • Run mandated reports for check processing and administer monthly check processing for leased housing.
  • Maintain records of all past check runs.
  • Reconcile with Leased Housing staff monthly Hold report and release payments as needed.
  • Identify, review and adjust late re-exams to ensure program compliance.
  • Monitor End of Participation monthly reports to eliminate payment errors.
  • Maintain fraud recovery ledger and reconcile monthly with fiscal staff for accurate reporting.
  • Oversee petty cash and process invoices and payments for promissory notes.
  • Maintain collection of data, data entry and processing forms necessary to process leased housing payments.
  • Review MRI-Tenmast payment forms for errors and accuracy.
  • Apply payment adjustments and calculations and update existing calculations.
  • Assist in preparing for internal and external audits by ensuring documentation accuracy.

Skills

Data analysis
Database experience
Excel
Attention to detail
Communication
Confidentiality
Multi-tasking
Windows OS
Problem solving

Education

High School Diploma

Tools

Microsoft Excel
Microsoft Word
Tracking systems

Job description

Lead Data Analyst - fully in-person/onsite

Lead Data Analyst (fully in-person role)

Pay Range $27 to $31 per hour

Company Overview

Community Teamwork is a private non-profit organization located in Lowell MA. We employ over 600 employees and are a catalyst for social change. We leverage our programs, our partnerships, and our collective voice to foster equity, compassion, and community engagement by creating housing, education, and economic opportunities.

Position Summary

The Lead Data Analystwill be responsible for entering and maintaining client data for housing programs; scheduling and processing monthly payments; accounts payable administration; troubleshooting complex software issues for Leased Housing programs, and performing quality control functions to ensure compliance with Executive Office of Housing and Livable Communities (EOHLC) regulations, internal policies, and accuracy of data and reporting.

Essential Functions and Responsibilities

  • Run mandated reports for check processing and administer monthly check processing for leased housing. Maintain records of all past check runs
  • Reconcile with Leased Housing staff monthly Hold report and release payments as needed to ensure accuracy and timeliness of payments
  • Work with the Leased Housing Inspections & Quality Control Compliance Manager to identify, review and adjust late re-exams to ensure program compliance with DHCD
  • Monitor “End of Participation” monthly reports to eliminate payment errors
  • Maintain fraud recovery ledger and reconcile monthly with fiscal staff for accurate reporting
  • Oversee petty cash and process invoices and payments for promissory notes
  • Maintain collection of data, data entry and processing forms necessary to process leased housing payments
  • Review MRI-Tenmast payment forms for errors and accuracy
  • Apply payment adjustments and calculations and update existing calculations according to documentation submitted by Leased Housing staff
  • Assist in preparing for internal and external audits by ensuring documentation accuracy

The duties listed above are representative of the work performed. Other related duties may be assigned.

Qualifications

  • High School Diploma and 2 years of related database experience
  • Knowledge of basic accounting
  • Desire to work with low income, culturally diverse, and at-risk families and individuals
  • Ability to manage multiple priorities and work in a fast-paced environment
  • Proficient with Windows, Microsoft Word, Excel, or comparable software and tracking systems
  • Excellent customer service, organizational, interpersonal, oral and written communication skills
  • Strong attention to detail and analytical skills
  • Ability to maintain accurate records and confidentiality of information
  • Ability to respond to all correspondence in a timely manner

Preferred Qualifications

At Community Teamwork, our employees enjoy best-in-class benefits to support their physical, financial and emotional wellness. We offer:

  • 4 Weeks of Paid Time Off - Paid Sick Leave - 12 paid holidays
  • Medical, Dental, and Vision Insurance - Company Paid Life Insurance – Critical Illness Insurance-Pet Insurance
  • Tuition Reimbursement - Career Advancement and Professional Development Opportunities
  • 5% employer contribution to your 401(k) retirement account after 6 months of employment
  • Great coworkers and a great mission with an outstanding Community Action offering a chance to help make a real difference in the lives of those we serve
  • The stated pay range represents the Agency’s good‑faith estimate of the compensation for this role at the time of posting. Actual compensation within the range will be based on factors such as experience, skills, and qualifications

Equal Opportunity Employer – Vets/Disabled

This is an exciting opportunity to become an integral member of an innovative team in an organization committed to excellence.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead Data Analyst - fully in-person/onsite
Lead Data Analyst - fully in-person/onsite

Community Teamwork • Lowell (MA)

On-site
USD 37,000 - 43,000
Onsite Lead Data Analyst - Housing Payments & Compliance
Onsite Lead Data Analyst - Housing Payments & Compliance

Community Teamwork Inc • Lowell (MA)

On-site
USD 37,000 - 43,000
4 Weeks of Paid Time Off
Paid Sick Leave
12 paid holidays
+6
Lead Data Analyst - Housing Payments & Compliance
Lead Data Analyst - Housing Payments & Compliance

Community Teamwork • Lowell (MA)

On-site
USD 37,000 - 43,000
Data & Performance Analyst
Data & Performance Analyst

Commonwealth of Massachusetts • Boston (MA)

Hybrid
USD 84,000 - 123,000
Hybrid work schedule
Youth Housing Manager
Youth Housing Manager

Community Teamwork • Lowell (MA)

On-site
USD 68,000 - 78,000
4 Weeks Paid Time Off
Paid Sick Leave
12 paid holidays
+8
Managing Director of Outreach Services
Managing Director of Outreach Services

Metro Housing Boston • Boston (MA)

On-site
USD 77,000 - 88,000
Health and dental coverage
Vision plan
Life and AD&D insurance
+3
Data and Compliance Coordinator
Data and Compliance Coordinator

Commonwealth of Massachusetts • Boston (MA)

Hybrid
USD 74,000 - 106,000
Leasing Coordinator
Leasing Coordinator

Related • Colonial Heights (VA)

On-site
USD 24,000 - 34,000
Paid time off
Medical, vision and dental options
401(k) with employer matching
+1
Auditor IV
Auditor IV

Commonwealth of Massachusetts • Boston (MA)

Hybrid
USD 84,000 - 123,000
Hybrid work schedule
Affordable Housing Leasing Consultant
Affordable Housing Leasing Consultant

Asset Living • Atlanta (GA)

On-site
USD 25,000 - 29,000
Medical, dental, vision insurance
401K with employer matching
Paid sick days
+1