Contract Data / Analytics Engineer (Short-Term Project)

About the Client

Pacific Star Excavating is an established excavation and construction company based in Washington State, serving Washington and Oregon since 1995. The company specializes in excavation, underground utilities, site work, demolition, and infrastructure projects. (Pacific Star Excavating, Inc - PSX)

They are looking for a hands-on Data / Analytics Engineer to support a short-term modernization initiative involving Power Apps workflows, database design, and data automation.

Project Overview

The current workflow relies heavily on SharePoint Lists and Power Apps. The client needs an engineer who can redesign the architecture into a more scalable, database-backed solution while ensuring the existing Power App remains synchronized and operational.

This is a fast-paced engagement for someone who can quickly assess the current setup, recommend improvements, and execute efficiently.

Responsibilities

• Replace SharePoint Lists with a scalable database-backed workflow

• Design and implement ETL/data ingestion processes

• Import/export and process CSV-based project estimate data

• Clean, parse, and prepare operational datasets

• Maintain synchronization between the database and Power Apps

• Recommend technical solutions and explain tradeoffs clearly to stakeholders

• Build dashboards and data visualizations when needed

• Collaborate directly with the client in a consultative capacity

Required Skills

• Strong experience with:

  • Power Apps

  • Power Automate

  • SharePoint Lists

  • Database design and data modeling

  • ETL/data pipeline development

• Experience handling CSV ingestion and transformation workflows

• Strong communication and consultative/problem-solving mindset

• Ability to work independently with high ownership

Nice to Have

• Experience building dashboards and data visualizations

• UI/UX exposure or frontend sensibility

• Previous experience modernizing legacy internal workflows

Engagement Details

• Contract duration: Approximately 2 weeks

• Location: Fully remote

• Client based in: Washington State (USA)

• Compensation: Approximately USD 2.5K–3K for the contractor

• Start: ASAP

Ideal Candidate

Someone proactive, technically strong, and execution-focused — capable of not only building solutions, but also helping the client understand why a specific approach is the best fit.