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 OverviewThe 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.
ResponsibilitiesReplace 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
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
Experience building dashboards and data visualizations
UI/UX exposure or frontend sensibility
Previous experience modernizing legacy internal workflows
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
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.
Skills Required
- Strong experience with Power Apps
- Strong experience with Power Automate
- Strong experience with SharePoint Lists
- Strong experience in database design and data modeling
- Strong experience in 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
What We Do
G2i is a hiring community connecting remote developers with world-class engineering teams. Our unique approach combines rigorous technical assessments with a solid commitment to developer health, ensuring companies get skilled developers who are supported, valued, and ready to execute from day one. Our transparent vetting process includes in-depth, performance-ranked developer profiles, recorded technical interviews, and soft-skills assessments. Whether you're working on a short-term project or burning down a backlog, G2i connects you with a community of pre-vetted developers. Planning to hire ten or more engineers? We create a Custom Talent Pipeline, allowing for specific customizations in sourcing, assessment criteria, technical interview questions, and integration with your existing HR systems and processes. G2i partners with clients who support the developer health mission—matching developers with environments that improve their health, support recovery from burnout, and enable professional growth through restful work. Is your team overworked or understaffed? Contact us today to learn how G2i can help you. More information about our mission and commitment to developers and clients can be found at https://g2i.co or follow us on X @g2i_co
