This job has closed.

Structure Tone · 1 day ago

Data Analyst

401 E City Avenue, Bala Cynwyd, PA, 19004, US

Full-time

Onsite

Mid Level

Structure Tone is a leading construction management firm, and they are seeking a highly skilled Data Analyst to support project management, executive leadership, and operations teams. The role involves data integration, automation, reporting, and cloud-based tools to provide insights for decision-making.

Construction

Growth Opportunities

H1B Sponsor Likely

Responsibilities

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

Provide training for project managers on Smartsheet functionality

Design and implement Smartsheet API integrations to improve workflow efficiency

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

Design Power Automate workflows for project and scheduling needs

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

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

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 PlatformSmartsheetData VisualizationPower QueryPower AutomatePrimavera P6Analytical 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

Pet Insurance

Employee Assistance Program

Company

Structure Tone

Glassdoor4.4

Structure Tone provides general contracting, construction management and project management services. It is a sub-organization of STO Building Group.

Founded in 1971

New York, New York, USA

1001-5000 employees

http://structuretone.com/

H1B Sponsorship

Structure Tone 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)

2023 (7)

2022 (6)

2021 (6)

2020 (1)