This job has closed.

STO Building Group · 14 hours ago

Data Analyst

Bala-Cynwyd, PA

Full-time

Onsite

Mid Level

STO Building Group is one of the largest construction managers in the country, and they are seeking a highly skilled Data Analyst to support project management and operations teams. This role involves data integration, automation, reporting, and using cloud-based tools to ensure stakeholders have the insights needed for decision-making.

Building MaintenanceConstructionHome RenovationInterior Design

H1B Sponsor Likely

Responsibilities

PowerBI Dashboard Development & Reporting

Design, build, and maintain dashboards for Construction projects and internal use

Dashboards subject matter typically involving construction management, construction accounting, and internal financial and project tracking analytics

Develop predictive analytics dashboards, including weather impact tracking

Smartsheet Web Based Collaboration Implementation and Training

Provide training for project managers on Smartsheet functionality

Design and implement Smartsheet API integrations to improve workflow efficiency

Cloud Data Engineering (GCP)

Develop and maintain data pipeline automations using GCP Cloud Composer/Airflow DAGs (written in Python)

Use best security practices in Google Cloud Platform (using GCP Secrets Manager)

Develop and maintain Cloud Functions that integrate with other platforms

Manage ingestion of external data into BigQuery

Build and optimize views in BigQuery for reporting and analytics

Support AI projects leveraging GCP AI/ML capabilities

Continue development of project schedule Primavera P6 XER file automations integrated with BigQuery

MS 365 / Azure - Process Automation & Tool Building

Design Power Automate workflows for project and scheduling needs

Manage integrations with Lucid Charts, Alchemer, and other SaaS tools

Data Training & Support

Conduct Power Query training

Support teams with best practices in dashboard usage and reporting standards

Maintain a historical project schedule database for analytics and planning

Collaboration & Stakeholder Management

Partner with project teams to identify and scope data needs

Engage with executives and C-suite to deliver tailored reporting for leadership decisions

Translate business requirements into technical solutions aligned with enterprise goals

Qualification

Power BIGoogle Cloud PlatformData Pipeline AutomationSmartsheetPower AutomatePower QueryPrimavera P6Analytical SkillsProblem-Solving SkillsCommunication Skills

Required

Strong hands-on experience with Power BI & Smartsheet, including dashboards, automations, integrations, and training

Expertise in Google Cloud Platform (BigQuery, AI/ML, data pipelines)

Proficiency with data visualization tools, Lucid, and survey/feedback tools (e.g., Alchemer/SurveyGizmo)

Solid knowledge of Power Query, Power Automate, and related Microsoft tools

Demonstrated success building and maintaining executive-level and project-level dashboards

Strong analytical, problem-solving, and automation skills

Excellent communication skills for interacting with both technical users and executive leadership

Preferred

Experience with Primavera P6 data workflows (XER format)

Benefits

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

Company

STO Building Group

STO Building Group is a construction management company that offers site selection, design review and modernization services.

Founded in 1971

New York, New York, USA

5001-10000 employees

https://stobuildinggroup.com

H1B Sponsorship

STO Building Group has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (1)

2024 (1)