Senior Analyst - Database Integration & Data Automation
Role Overview
The Senior Analyst supports a Federal Transit Administration program with database integration, data migration, data quality, workflow automation, reporting, and modernization.
The role works with the Senior Consultant/SME and Program Manager to maintain and enhance data-management processes and migrate and integrate program information across platforms.
Key Skills for This Role
Full Job Posting
Role overview
The Senior Analyst supports a Federal Transit Administration program with database integration, data migration, data quality, workflow automation, reporting, and modernization.
The role works with the Senior Consultant/SME and Program Manager to maintain and enhance data-management processes and migrate and integrate program information across platforms.
Workplace
- The position is remote.
Responsibilities
- Support database integration, migration, modernization, and implementation activities.
- Analyze databases, datasets, business processes, and workflows to identify integration requirements, dependencies, data gaps, and improvements.
- Map, transform, reconcile, and validate data between legacy and modernized systems.
- Maintain data mappings, dictionaries, field definitions, database and process documentation, and system requirements.
- Conduct data-quality reviews and resolve duplicate, incomplete, inconsistent, or inaccurate data.
- Support relational databases, including Microsoft Access, and develop automated workflows using Power Automate or comparable tools.
- Support dashboards, reports, queries, metrics, and analytical products using Power BI, SQL, Excel, and related tools.
- Gather stakeholder needs and translate them into technical, database, integration, and reporting requirements.
- Test and validate database changes, migrations, integrations, workflows, and reporting solutions; troubleshoot issues with technical and program stakeholders.
- Support data governance, access controls, integrity, auditability, and documentation.
- Prepare technical documentation, status information, briefings, recommendations, and implementation materials for project and Government stakeholders.
- Coordinate with FTA personnel, project leadership, analysts, and technical resources and provide additional support for transportation-safety programs.
Required qualifications
- Bachelor’s degree plus 7 years of relevant professional experience, or master’s degree plus 5 years, or an education/experience equivalent.
- Significant experience in database integration, data migration, data management, data governance, or enterprise systems.
- Experience translating business requirements into technical or data requirements and working with relational databases, data mapping, validation, reconciliation, and data quality.
- Experience documenting databases, systems, workflows, technical requirements, and business processes; experience supporting enterprise implementation, integration, migration, or modernization.
- Strong analytical, problem-solving, documentation, and stakeholder communication skills and ability to work with technical and nontechnical stakeholders.
- Must complete required FTA/DOT suitability requirements before beginning work on the project.
Preferred qualifications
- Experience with Microsoft Access, SQL, Power BI, Power Automate, SharePoint, Dataverse, or comparable platforms is preferred.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career