Senior Business Systems Analyst (ERP, Analytics and Data Science)

GeoStabilization International•Westminster, CO

1d•$80,000 - $100,000•Hybrid

About The Position

GeoStabilization International is seeking a Senior Business Analyst who operates at the intersection of ERP architecture, advanced analytics, and executive decision-making. This individual will directly shape how leadership understands cost, risk, margin, productivity, and execution performance across complex construction operations. You will work below the UI layer, directly inside ERP back-end tables (Trimble Viewpoint Vista preferred), translating raw transactional data into clear, defensible, decision-grade insight. Success in this role is defined by trust, accuracy, and impact—not by volume of reports produced. This role has clear runway into Director-level Analytics, Business Systems, or Operational Strategy leadership for individuals who demonstrate judgment, ownership, and scale.

Requirements

ERP Systems: deep experience with Trimble Viewpoint Vista strongly preferred; must demonstrate ERP back-end fluency
Data Access: advanced SQL across complex relational schemas
Data Science: Python or R for statistical modeling and predictive analysis
Visualization: Power BI or Tableau connected directly to ERP data
Excel: Expert-level skills including complex models, automation, structured logic
Experience: 5+ years in highly technical BA / analytics roles, preferably construction, engineering, or asset-heavy industries
Intellectual Sharpness: Rapid comprehension of unfamiliar systems and datasets
Analytical Rigor: Precision, reconciliation discipline, and defensible logic
Judgment Under Pressure: Clear thinking when data is incomplete or messy
Executive Communication: Translating complex analysis into decisive guidance
Ownership Mentality: You act like the data is yours—because it is

Responsibilities

Directly access, navigate, and query ERP back-end tables to extract raw financial, job cost, labor, equipment, and payroll data
Develop a deep working mastery of Vista’s table structure, joins, and data dependencies
Serve as a trusted internal authority on what the data actually means, not just how it looks
Apply statistical modeling, forecasting, and predictive analytics to: Project margin and cost-to-complete risk Identify labor productivity and equipment utilization trends Surface early indicators of project or portfolio underperformance Build models that leadership can act on, not academic exercises
Rapidly synthesize data from multiple systems and imperfect sources
Answer ambiguous, high-stakes questions with incomplete information
Deliver conclusions that withstand scrutiny from Finance, Operations, and Executive Leadership
Design and maintain a small, high-impact suite of standardized reports
Ensure 100% reconciliation to ERP source-of-truth
Automate delivery while preserving traceability and audit confidence
Build robust, intuitive Excel models using: Power Query Power Pivot Advanced formulas and structured data models Translate complexity into tools leaders actually use—not spreadsheets that break