1076256true1076256falseSubmission for the position Summer Intern - Data Warehouse QA - Job Number 2600023Ofalse1076256falsetrueSummer Intern - Data Warehouse QA2600023O
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 Revenues 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.
BureauDivision 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 states of current and previous residenceemployment validation of eligibility to work in the United States and national fingerprint-based criminal background checks.
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 Revenues 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.
BureauDivision 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 states of current and previous residenceemployment 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 BIPOCmay self-select out of opportunities if they dont meet 100 of the job requirements. We encourage individuals who believe they have the skills necessary to thrive to apply for this role.
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 BIPOCmay self-select out of opportunities if they dont meet 100 of the job requirements. We encourage individuals who believe they have the skills necessary to thrive to apply for this role.