MS Access Data Analyst

Robert Half is seeking an MS Access and Asset Data Management Analyst to support a public transit organization based in Portland, Oregon. This role involves supporting the (TAM) program through the implementation of a new Asset-to-Project Mapping system in Microsoft Access. The position will focus on managing and improving asset data, linking physical infrastructure to capital projects, and ensuring accurate lifecycle modeling for long-term planning. The position is Hybrid (2–4 days onsite in Portland) and is a 3+ month contract opportunity with potential to extend. Apply today! Job Details: Schedule: 20–40 hours per week (flexible, core hours Mon–Thu) Duration: Through January 2026 (possible extension) Location: Portland, OR (Hybrid – 2–4 days onsite per week) Job Responsibilities: • Maintain and enhance the TERM-Lite MS Access database used for asset lifecycle modeling and capital replacement planning. • Clean, organize, and validate large asset data sets in Access and Excel. • Develop and modify Access tables, queries, reports, and VBA modules to improve functionality and reporting accuracy. • Build and maintain asset-to-project mappings based on geography, hierarchy, and condition data. • Support the rollout of the TERM-Lite APM enhancement, working alongside senior analysts and stakeholders. • Collaborate with asset owners, engineers, and capital planning staff to align asset data with real-world conditions. • Create process documentation and user guides to standardize future data updates. • Provide recommendations to improve asset inventory accuracy and reporting consistency. • 5+ years of Experience as a Data Analyst • Advanced MS Access experience (queries, relationships, reports, and forms). • Strong SQL skills for writing and modifying queries. • Experience using VBA (Visual Basic for Applications) for database automation and customization. • Advanced Excel skills (Pivot Tables, Power Query, data analysis). • Experience with relational databases and asset or data management. • Ability to communicate with both technical and non-technical stakeholders. • Understanding of asset lifecycle concepts or experience in transit, utilities, or public infrastructure preferred. • Power BI/Tableau and GIS experience a plus Technology Doesn't Change the World, People Do.® Robert Half is the world’s first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles. Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more. All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information. © 2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking “Apply Now,” you’re agreeing to Robert Half’s Terms of Use. Apply tot his job