Contract Data / Analytics Engineer (Short-Term Project)

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.