DEADLINE TO APPLY IS SUNDAY, MARCH 16, 2025 AT 11:59 PMIF YOU ARE INTERESTED, PLEASE APPLY IMMEDIATELYFirst round interviews tentatively scheduled for Friday, March 28, 2025A resume and cover letter are not required with your application, but highly encouraged
THIS IS A TIME-LIMITED POSITION THROUGH JUNE 30, 2026
Be ready to rethink your assumptions about the public sector. Dedicated and motivated colleagues? Beautiful, high amenity building for on-site work and collaboration? Flexible schedules and hybrid work options? Yes, yes, and yes!
ABOUT MTCThe Metropolitan Transportation Commission (MTC) is the transportation planning, financing and coordinating agency for the nine-county San Francisco Bay Area. MTC is the federally designated Metropolitan Planning Organization (MPO) and the state designated Regional Transportation Planning Agency (RTPA) for the nine-county San Francisco Bay Area. MTC provides services to the Association of Bay Area Governments (ABAG). For more information about MTC, visit www.mtc.ca.gov.
ABOUT THE ROLE
MTC is committed to being an equitable and inclusive workplace. The Technology Services Section (TSS) focuses on career and personal development with emphasis on emotional intelligence, innovation, and a growth mindset. TSS’ vision is to empower the region using innovative technology solutions to connect citizens and enrich and transform how we travel, work and live.

The ERP Data Engineer will be a team member in the Business Development Business Unit within TSS. The unit is tasked with managing the operation, modification, and maintenance of technology platforms – and particularly, MTC’s ERP (Enterprise Resource Planning) environment – to support a more productive, more collaborative, equitable, friendly, and more dignified user experience. The ERP Data Engineer will need to hit the ground running and work within a technology workstreams team responsible for the migration of data from our legacy ERP system (Central Square) to our future ERP system (Oracle) this year.

The ERP Data Engineer will perform development and data migration work currently underway at MTC. With the guidance of a Data Strategist, the ERP Data Engineer will be responsible for the following:

Development of SQL queries and scripts enabling the reproducible extraction of structured data from a SQL Server database, into raw files following a specified format and structure.
Engagement with relevant vendors, subject matter experts, and operational users, to define data scopes, establish data requirements, and corroborate query outputs.
Participate in recurring working sessions discussing Central Square’s reporting, platform logic, and data structures, in support of this activity.
Collaborate with other MTC technology workstream team members to enable the bulk extraction of attachments from Central Square and loading of these into the Oracle system.
Other relevant database engineering/data quality tasks to ensure successful data conversion and migration.

Collaborate with resources in data integration, migration, delivery, and validation.
Follow best practices and established standards of data governance and data quality.
Analyze source and target data models and templates, and perform investigative analysis to identify the correct logical transformations and source-to-target mappings between each.
Facilitate coordinated movement of data from source to target systems.
Coordinate with technical and business subject matter expert (SME) staff on data validation in target systems.
Assist with the creation of functional and technical documentation related to Data Architecture.
Build SQL queries and scripts to support reproducible extraction and loading of data.
Perform other job-related tasks and duties as needed or assigned by the Section.

KNOWLEDGE, SKILLS, AND ABILITIES

Required Skills
Working knowledge of ERP systems and concepts, and/or ERP data, specifically human capital and financial accounting systems.
Understanding of Oracle and MS SQL Server data models.
Competency in performing data quality analysis and data remediation across large and varied structured datasets.
Understanding of system data migration processes, techniques, and best practices.
Solid conceptual understanding of data architecture principles and best practices.
Ability to engage non-technical and operational users and stakeholders in service to the refinement and definition of technical requirements.
Desired Skills
Familiarity with Central Square ERP system.
Experience authoring Python and/or Shell scripts to support data migration and/or ETL/ELT processes specifically.
Oracle Certified Professional or similar relevant certification(s).
Experience with Oracle ERP Cloud offerings, and related migration tools, APIs, and/or integration frameworks.
Strong proficiency in query development, and in particular SQL querying:
Ability to translate business and operational requirements into clear technical specifications for Extract, Transform, Load (ETL) / Extract, Load, Transform (ELT) solutions.
Demonstrable ability to independently author and implement efficient and accurate ETL/ELT solutions that are well-documented.
Knowledge and experience of ETL/ELT processes and tools, specifically ETL/ELT solutions optimized for ERP implementations.
Soft Skills
Problem-solving and critical thinking.
Effective communication and collaboration skills with cross-functional teams, and both technical and non-technical stakeholders.

MINIMUM QUALIFICATIONS
An appropriate combination of education and experience that has provided the required knowledge, skills and abilities is qualifying. A typical way of obtaining the required qualifications is:

Education: A Bachelor's degree in computer science, information systems or related field. A Masters Degree is desirable. Applicants with a degree issued from an institution outside the United States must have their transcripts evaluated by an academic accrediting service and provide proof of equivalency along with their application.
Experience: Five years of increasingly complex work experience in planning, designing and implementing major computer systems and databases, including the equivalent of two years as a Systems Analyst II in MTC. License/Certificate: Possession of a valid California Class C driver's license and a safe driving record, or the ability to provide alternate transportation which is approved by the appointing authority.

EMPLOYMENT REQUIREMENTS
Successful completion of a background check, professional references and the Employment Eligibility Verification Form I-9.

DISABILITY
The Human Resources Department will make reasonable efforts in the recruitment or skills assessment process to accommodate applicants with disabilities. If selected for an interview or testing, and you require accommodation, please notify the Human Resources Department when confirming your interview or test.

APPLICATION ASSISTANCE
If you need technical assistance with your on-line application, please contact NEOGOV's Applicant Support Line at (855) 524-5627 available from 8:00 AM to 5:00 PM (PST) Monday through Friday, excluding holidays.
All MTC employees are designated Disaster Service Workers through state and local law (California Government Code Section 3100-3109). Employees are required to complete all Disaster Service Worker-related training as assigned, and to return to work as ordered in the event of an emergency.