Learn & Earn- Database Analyst/Finance Intern

Anticipated Start and End Dates: Spring 2023 with possible extension

Remote or In Person: In Person Internship- 52 Chauncy St, Boston, MA 20111

Hours Per Week: 20 – 40 hours per week

Work Schedule: To Be Determined           

Website: https://bostonhousing.org/

Pay Rate and Travel Stipend: $18/hour and one-time $240 travel stipend

Internship Class: If chosen for the internship, you will take the three credit INT-299 Learn and Earn internship course during spring semester (you pay for the course but if an internship course is not part of your program, we can try to see if a required course can be replaced but this is not always possible). 

Boston Housing Authority (BHA) provides quality affordable housing for low-income families and individuals through the public housing and Section 8 rental assistance programs. BHA serves more than 58,000 of Boston's most vulnerable residents; including elderly, disabled, children and low-income families from a broad range of backgrounds and experiences. We foster vital communities that are essential to the city of Boston's economic diversity and way of life. As the largest housing provider in Boston, we bring stability, opportunity, and peace of mind to the thousands of low-income families we support – and to the city as a whole.

 

The Database Analyst position (“position”) will be working with BHA’s MS SQL operational and data warehouse databases. The main focus of the position will be financial presentations (reports) of data. The position will also be responsible for developing and maintaining extracts, transformations and loads into BHA’s data warehouse. The financial presentations will be based upon the data stored in the data warehouse. The position will primarily work with Finance on the work required. The position will be supervised and guided by the Information Systems Senior Director and Information Systems developers. The end result is the position providing data analytics to the Finance department and its various customers. Depending upon the candidate’s qualifications, the position will also work with the Information Systems team in developing web presentations of the Data in the form of web page presentations and reports.

 

•            Develop and maintain data extracts for financial report presentations

•            Develop and review the technical requirements for financial data ETL’s

•            Assist in the data warehouse storage strategies for the various data requirements of the BHA

•            Develop extract, translate, load (“ETL”) tasks on the operational and data warehouse databases

•            Develop data presentations based on the operational and data warehouse databases

•            Assist the Data Analysts on the Information Systems team

•            Assist in various tasks as directed by the department’s Directors

 

•            Experience with Microsoft SQL Server (2016 and higher)

•            Experience in developing SQL Server objects

•            Experience in developing SQL code

•            Ability to speak and read English, does not have to be the primary language

•            Experience working with computers in a networked environment

o            knowledgeable of various components of a computer (i.e. computer, monitor, etc.)

o            have a basic understanding of a network.

•            Experience working independently and with a team of other professionals

 

•            Experience with data presentation platforms (i.e. Microsoft BI, Tableau)

•            Experience with Angular

•            Experience with Python

 

The MIS Internship Program is designed around college’s and technical institute’s semesters. A potential candidate can hold an internship position for up to one year. A formal review will be done at the end of each semester. BHA will provide a college’s or institute’s internship documentation and requirements at that time. The internship program is a paid position at the BHA. A potential candidate can expect to learn various skills with regards to a large-scale, distributed-work-location MIS environment. The candidate can also expect to learn and build customer relationship management skills. Finally, the candidate can expect to gain experience and build proficiency in a computer technology field, both as an individual and as part of a team.

 

BHA is an equal opportunity employer. Bilingual candidates are encouraged to apply. Thank you.

 

 

BHCC Vaccination Requirement:

In order to create a safe and inclusive environment for our students working in the field, BHCC is requiring:

·       All students who are doing in-person internships to BE VACCINATED AGAINST COVID19

·       Students seeking a medical or religious exemption may request an exemption at COVIDvaxexemption@bhcc.edu. Exemptions and accommodations are not guaranteed.

 

 

Katie Colello - Learn and Earn Coordinator ● Office: B-101E ● 617-936-1943 ● kvcolell@bhcc.edu