[Industry: Architecture and Planning | Type: Full-time | Level: Mid-Senior level]
DescriptionWe are seeking aTechnical Business Analystspecializing indata analytics for architecture, engineering, and construction (AEC) firms. This role focuses on analyzing complex project, financial, and operational data; integrating data from AEC-specific platforms and SaaS systems; and delivering actionable insights through modern analytics solutions.The ideal candidate combines strongPower BI and data modeling expertisewith hands-on experience supportingproject-based professional services organizations, and can work effectively with architects, project managers, and leadership to improve visibility, efficiency, and decision-making.Key ResponsibilitiesPartner with both operational and project delivery teams to understand business processes, data needs, and performance challengesAnalyze and document requirements related to project delivery, utilization, financial performance, scheduling, and operational metricsDesign, develop, and maintain Power BI dashboards, reports, and semantic models tailored to AEC business needsIntegrate data from Deltek Vision / Vantagepoint, Autodesk-related platforms, Resource Planning, and other AEC SaaS systems using APIs and data connectorsWork with Dataverse, SQL, and Azure data services to support structured and scalable data solutionsPerform data transformation, cleansing, validation, and modeling across multiple project and enterprise data sourcesDevelop and optimize DAX measures and calculations to support project, financial, and operational reportingConduct building, space, or project-related data analysis where applicable (e.g., utilization, space planning, performance metrics)Translate analytical findings into clear recommendations for leadership, project teams, and operationsSupport the design and development of analytics solutions that align with professional services workflows and best practicesCollaborate closely with cross-functional professional teams, IT, and leadership to continuously improve data quality and insightsRequirements4+ years of experience as a Technical Business Analyst, Data Analyst, or similar analytics-focused roleAdvanced experience with Power BI, including data modeling, DAX, and performance optimizationStrong experience working with SQL, Dataverse, and Azure-based data platformsProven experience integrating and analyzing data from multiple SaaS platforms and APIsStrong analytical and problem-solving skil...