Data & Automation Analyst - Estimating

About the Role

Structure Tone is one of the largest construction management and general contracting firms in the country. We are hiring a Data & Automation Analyst to support the New Jersey Estimating department through data management, reporting, analytics, Google-platform development, AI agent development, and process automation.

You will work directly with estimators and preconstruction teams to understand how the work actually gets done, then turn that understanding into Power BI dashboards, curated BigQuery data sets, and AI agents that reduce manual effort across the estimating lifecycle, from RFP intake through budgeting, bidding, bid review, and leveling.

This role sits within the NJ Estimating team and will use the shared STO Building Group data platform and approved enterprise tools. The analyst will collaborate with the central Data and Analytics team to ensure NJ Estimating solutions align with enterprise architecture, security, integration, and data governance standards. Successful solutions developed for NJ Estimating may be adapted for broader use across STO Building Group.

Key Responsibilities

Business Partnership & Requirements

• Support NJ Estimating in gathering requirements from estimators, preconstruction teams, and operations; document existing workflows and help establish measurable success criteria.
• Assist in translating established estimating processes and business requirements into clear specifications for reports, data sets, AI agents, and automations.
• Partner with the enterprise Data Engineering team to enable onboarding of new data source systems when required data is not yet available on the platform.
• Document what you build and support the people who use it.

Data Access & Preparation (Google Cloud / BigQuery)

• Write, optimize, and document SQL queries and views in BigQuery to produce reporting-ready data sets.
• Validate data quality and reconcile reporting outputs against source systems.
• Use Python for data exploration, transformation, analysis, and lightweight automation.
• Follow the naming, access, and governance standards set by the Data & Analytics team.

Reporting & Analytics (Power BI)

• Design, build, and maintain Power BI dashboards and reports for the Estimating team, including semantic data modeling, Power Query transformations, and DAX measure development.
• Develop estimating-focused reporting on historical cost data, cost benchmarking, RFP trends, bid comparisons, trade-level analysis, and leveling outcomes.
• Maintain and enhance cost benchmarking data sets covering project type, square footage, trade costs, bid results, escalation factors, and comparable project metrics.
• Support adoption through training, reporting standards, and day-to-day user support.

AI Agents & Process Automation

• Prototype and test AI agents for estimating use cases such as RFP intake and summarization, bid package review, subcontractor comparison, scope gap identification, and bid leveling support.
• Help develop evaluation criteria for AI agent outputs and test solutions against approved estimating scenarios, documenting accuracy, reliability, security, and data governance concerns before rollout.
• Build Microsoft Copilot and Power Automate workflows that connect estimating documents, data, and dashboards to reduce recurring manual tasks.
• Collaborate with the Data & Analytics team on deployment, security review, and the support model for anything moving from prototype to production.

Qualifications

Required

• 0-3 years of experience in a data analyst, BI developer, or analytics engineering role.
• Strong SQL skills, including joins, aggregation, CTEs, and query tuning, with the ability to work independently against a cloud data warehouse.
• Demonstrated Power BI experience, including data modeling, Power Query, DAX, and dashboards for business users.
• Working knowledge of Python for data transformation and analysis (pandas or equivalent).
• Hands-on exposure to a cloud data platform, ideally Google Cloud and BigQuery.
• Proven ability to gather requirements from non-technical stakeholders and translate them into working solutions.
• Comfort working through evolving requirements, sound judgment about when to clarify requirements versus when to proceed, and a habit of documenting decisions.
• Strong written and verbal communication skills.

Preferred

• Experience building or evaluating LLM-based agents (Gemini Enterprise, Microsoft Copilot, or comparable), including prompt design and output evaluation.
• Microsoft 365 and Power Automate workflow development.
• Exposure to predictive modeling, including regression, classification, or forecasting, applied to estimating problems such as cost escalation or weather impact.
• Version control (Git) and a basic understanding of orchestration tools such as Airflow / Cloud Composer.
• Familiarity with construction cost structures, CSI divisions, or estimating software.
• Construction, engineering, real estate, or professional services industry background.

• Salary: $80K - $95K
• Compensation: In addition to base pay, eligible for discretionary bonus based on company and individual performance.

Benefits

The Company offers the following benefits for this position, subject to applicable eligibility requirements: [Medical Insurance] [Dental Insurance] [Vision Insurance] [Health Savings Account] [Healthcare Flexible Spending Account] [Dependent Care Flexible Spending Account] [401(k) retirement plan with employer match] [Life & AD&D Insurance] [Long-term Disability Insurance] [Short-term Disability Insurance] [Critical Illness Insurance] [Accident Insurance] [Hospital Indemnity Insurance] [Home & Auto Insurance] [Family Support] [Pre-tax Paid Parking/Public Transportation] [Paid time off: 2 Weeks for Non-Exempt and Three Weeks for Exempt] [Time Away Benefits] [8 Paid Holidays] [Group Legal] [Employee Stock Purchase Plan] [Identity Theft Protection] [Group Legal] [Pet Insurance] [Employee Assistance Program]

Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. The Company reserves the right to modify this information at any time, subject to applicable law.

EEO Statement

The STO Building Group family of companies—Structure Tone, Structure Tone Southwest, Pavarini Construction Co., Pavarini McGovern, LF Driscoll, Govan Brown, Ajax Building Company, BCCI Construction, Layton Construction, Abbott Construction, and RC Andersen—includes over 4,000 employees located in offices throughout the US, Canada, UK, and Ireland. We provide a complete range of construction services, from site selection analysis, design constructability review and aesthetic enhancements to interior fit-outs, new building construction, and building infrastructure upgrades and modernization. Learn more about how we partner with our clients to imagine, execute, and realize their vision at stobuildinggroup.com.

We are an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other legally protected characteristics.