Summer Intern - Data Warehouse QA
Job Description
Agency Overview
A&F IT is a unit under the Executive Office for Administration & Finance (A&F) and is overseen by the A&F IT Secretariat Chief Information Officer (A&F SCIO). A&F IT is comprised of over 200 employees working on IT systems and applications for 15 various A&F agencies. A&F IT oversees and provides all the IT application support for these agencies to ensure their IT operations are running effectively and efficiently.
One of the key agencies supported by A&F is the Department of Revenue. The Department of Revenue's core mission is to collect the revenues required to support the business of the Commonwealth, to make a difference in the lives of children by enforcing the financial responsibilities of parenthood, and to assist Massachusetts cities and towns in sound and efficient fiscal management.
Bureau/Division Overview
The Child Support Data Warehouse team supports reporting and analytics that help program staff, leadership, and partner agencies make informed decisions. The team manages data integration processes and develops reports and dashboards that provide insight into child support operations, financial activity, and program performance. The team works closely with program staff, analysts, and developers to ensure systems are reliable, accessible, and supported by accurate reporting and analytics.
Want more jobs like this?
Get jobs in Revere, MA delivered to your inbox every week.

Position Summary
The Data Warehouse QA Intern will assist the team in supporting reporting and integration activities, including learning how enterprise reporting and data warehouse tools are used in a production environment. With guidance from experienced staff, the intern will gain hands-on experience working with reporting tools such as Cognos, an introduction to data warehouse concepts, learning about data integrations processes using Oracle Data Integrator (ODI), and helping validate and enhance reports
Core Responsibilities:
• Assist with validating and reviewing reports to help ensure data accuracy and consistency.
• With guidance from staff, help support development or updates using enterprise reporting tools such as Cognos.
• Assist the team in reviewing data loads or processes related to the data warehouse environment.
• Help document report logic, data sources, and testing or validation results.
• Participate in team meetings and help track tasks and progress related to reporting and data activities.
• Assist in identifying and documenting data or reporting issues for review by team members.
Preferred Qualifications:
• Interest in information technology, data analytics, computer science, or a related field.
• Strong attention to detail and interest in working with data.
• Basic familiarity with Excel or other data tools is helpful but not required.
• Good written and verbal communication skills.
• Ability to follow procedures and work both independently and as part of a team.
• Interest in learning about accessibility, reporting, data integration and data warehouse environments.
An external candidate recommended for a position with the Department of Revenue will be subject to a background check that includes checks for: state and federal tax compliance; child support compliance; education verification; Massachusetts CORI checks; criminal background checks in state(s) of current and previous residence/employment; validation of eligibility to work in the United States; and national fingerprint-based criminal background checks.
Qualifications
First consideration will be given to those applicants that apply within the first 14 days.
Please see Preferred Qualifications.
Comprehensive Benefits
When you embark on a career with the Commonwealth, you are offered an outstanding suite of employee benefits that add to the overall value of your compensation package. We take pride in providing a work experience that supports you, your loved ones, and your future.
Want the specifics? Explore our Employee Benefits and Rewards!
An Equal Opportunity / Affirmative Action Employer. Females, minorities, veterans, and persons with disabilities are strongly encouraged to apply.
The Commonwealth is an Equal Opportunity Employer and does not discriminate on the basis of race, religion, color, sex, gender identity or expression, sexual orientation, age, disability, national origin, veteran status, or any other basis covered by appropriate law. Research suggests that qualified women, Black, Indigenous, and Persons of Color (BIPOC) may self-select out of opportunities if they don't meet 100% of the job requirements. We encourage individuals who believe they have the skills necessary to thrive to apply for this role.
Perks and Benefits
Health and Wellness
- Health Insurance
- Health Reimbursement Account
- Dental Insurance
- Vision Insurance
- Life Insurance
- Short-Term Disability
- Long-Term Disability
- FSA
- HSA
- Mental Health Benefits
Parental Benefits
- Adoption Assistance Program
- Family Support Resources
Work Flexibility
- Flexible Work Hours
- Hybrid Work Opportunities
Office Life and Perks
- Commuter Benefits Program
Vacation and Time Off
- Paid Vacation
- Paid Holidays
- Personal/Sick Days
- Volunteer Time Off
Financial and Retirement
- Pension
- Financial Counseling
Professional Development
- Promote From Within
- Mentor Program
- Access to Online Courses
- Lunch and Learns
- Internship Program
- Leadership Training Program
- Associate or Rotational Training Program
Diversity and Inclusion
- Diversity, Equity, and Inclusion Program