Data Engineer - TID (Contractor Position) bei Massachusetts Bay Transportation Authority, MA

About the Department

As the Data Engineer in the Technology’s Innovation Department Fares Technology team, you will be building and maintaining data pipelines to support analysis of financial and other types of data.  

Position Duties

As a Data Engineer on our Fares Technology team, you will play a pivotal role in shaping the architecture and flow of fares technology data across systems. In this role, you will architect data solutions using modern engineering principles, ensuring scalability and reliability. Your competency in data modeling will be crucial for designing structures that support our business logic and analytical needs. Your analytical skills will be put to use tuning logic to optimizing data processing and retrieval performance.

This role demands a blend of technical acumen in data engineering tools and practices, strategic thinking for technology selection, and the interpersonal skills to collaborate effectively within the team and broader organization. Your contributions will directly impact the efficiency and effectiveness of our data-driven strategies, making this a critical and rewarding position in our department.

Additional responsibilities may include a focus on one or more departments or locations. See applicable addendum for department or location-specific functions.

Physical Demands and Working Conditions

• The physical demands and work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
• Available to work all shifts and locations as assigned or directed.
• Available to work as per assignment by the MBTA twenty-four (24) hours per day, seven (7) days per week as directed by supervisory staff for severe weather conditions, emergencies or any other circumstances that may potentially impact service or the safety of service.

Supervision

• This role does not supervise employees or contractors.

Minimum Education

• This role has no minimum education requirements.

Minimum Qualifications

• Proficient with Python 
• Proficient with SQL and query optimization 
• Experience with data management on local environments 
• Experience with automated testing, including continuous integration (CI) 
• Experience with Git workflows (such as pull requests) and code reviewing 
• Experience with data pipeline architecture and deployment 
• Experience with data modeling 
• Experience with data quality analysis 
• Ability to translate business requirements into technology 
• Strong communication skills 
• Strong analytical thinking and debugging abilities 

Preferred Experience and Skills

• Knowledge of transit data standards (such as GTFS, GTFS-RT, TODS, TIDES)
• Experience with Terraform / Infrastructure as Code tools
• Experience with AWS data tools and resource management
• Experience with cross-language data platforms like Arrow

Job Conditions

• Adhere to rules, regulations, collective bargaining agreements (if applicable) and policies of the MBTA including the EEO, anti-discrimination, anti-harassment, and anti-retaliation policies.
• Ability to pass a Criminal Offender Record Information (CORI) check, background screening, and the MBTA’s medical requirements, including a physical examination and drug and alcohol screening. 
• Have a satisfactory work record for the two (2) years immediately prior to the closing date of this posting, including overall employment, job performance, discipline, and safety records (infractions and/or offenses occurring after the closing of the posting and before the filling of a vacancy may preclude a candidate from consideration for selection). 

The above statements are intended to describe the general nature and complexity of the work being performed by staff assigned to this job, and do not represent an exhaustive list of all duties, tasks, and responsibilities required of staff assigned to this position.

Other Qualifications

• A High School Diploma or GED with an additional seven (7) years of directly related experience substitutes for the bachelor’s degree requirement.
• An associate degree from an accredited institution an additional three (3) years of directly related experience substitutes for the bachelor’s degree requirement.
• A master’s degree in a related subject substitutes for two (2) years of general experience.
• A nationally recognized certification, or statewide/professional certification in a related field substitutes for one year of experience.