Summer Intern - Data Warehouse QA

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. 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./ 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. Job: * Information Systems and Technology Organization: * Exec Office of Administration and Finance Title: Summer Intern - Data Warehouse QA Location: Massachusetts-Chelsea-200 Arlington Street Requisition ID: 2600023O