Data Scientist

Data Scientist

Technical Solutions Architect (Access/VBA)

Job Description

We are seeking a Technical Solutions Architect who specializes in Microsoft Access and VBA to design, prototype, and architect the core data structures and workflow logic for a multi-module Methane compliance platform. This role focuses on hands-on Access development, including database schema design, form and report architecture, workflow automation, and functional prototyping to guide downstream software development.

Responsibilities

• Architect relational database structures, queries, and workflow logic in Microsoft Access to support Methane compliance requirements.
• Develop functional prototypes, wireframes, forms, subforms, and reports to define system behavior and user interactions.
• Build and refine VBA modules, class modules, automation routines, and validation logic to demonstrate intended system functionality.
• Translate regulatory and business requirements into technical specifications, data models, and workflow diagrams.
• Produce blueprint packages that guide external developers in implementing production-grade modules.
• Ensure Access-based prototypes align with long-term scalability, data integrity, and integration needs.

Essential Skills

• Expert-level Microsoft Access experience, including database design, complex queries, forms/subforms, reports, and prototype development.
• Advanced VBA expertise, including ADO/DAO, class modules, automation scripts, error handling, and workflow logic.
• Strong SQL skills for data manipulation, reporting, and integration with external data sources.
• Ability to translate regulatory and stakeholder requirements into clear, structured technical designs.
• Strong written and verbal communication skills for documenting specifications and presenting solution designs.

Additional Skills & Qualifications

• Experience managing software development vendors, including scope alignment, deliverable reviews, and acceptance processes.
• Background in full SDLC project management, including charters, schedules, cost estimates, and risk tracking.
• Familiarity with GIS data integration (shapefiles, geodatabases, spatial queries) and alignment between spatial and relational data.
• Experience with SQL Server or Azure SQL (stored procedures, indexing, schema review).
• Python or other scripting experience for ETL, automated testing, or validation of vendor deliverables.
• Understanding of APIs, REST services, and JSON/XML data formats.
• Experience linking Access with GIS tools such as ArcGIS or QGIS.
• Knowledge of Power BI or similar tools for dashboard prototyping.
• PMP, Agile, or Scrum certification.
• Experience with earned value management or quantitative cost/schedule tracking.
• Strong requirements engineering skills and familiarity with structured review/approval workflows.
• Knowledge of contract structures (fixed price, T&M, hybrid).

Work Environment

This is a part-time position within a software development environment focused on Methane compliance. The role requires a technical expert capable of working independently while collaborating with external development partners. The candidate will engage in detailed database and prototype development using Microsoft Access and VBA, ensuring solutions are scalable and maintainable for future integration needs.

This is a Contract to Hire position based out of Roseville, CA.

The pay range for this position is $40.00 - $60.00/hr.

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:
• Medical, dental & vision
• Critical Illness, Accident, and Hospital
• 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
• Life Insurance (Voluntary Life & AD&D for the employee and dependents)
• Short and long-term disability
• Health Spending Account (HSA)
• Transportation benefits
• Employee Assistance Program
• Time Off/Leave (PTO, Vacation or Sick Leave)

This is a fully remote position.

This position is anticipated to close on May 23, 2026.

About Actalent

Actalent is a global leader in engineering and sciences services and talent solutions. We help visionary companies advance their engineering and science initiatives through access to specialized experts who drive scale, innovation and speed to market. With a network of almost 30,000 consultants and more than 4,500 clients across the U.S., Canada, Asia and Europe, Actalent serves many of the Fortune 500.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please email actalentaccommodation@actalentservices.com for other accommodation options.

San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.

Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.

Salary : $40 - $60