Technical Business Analyst – AEC Data & Analytics

Description

We are seeking a Technical Business Analyst specializing in data 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 strong Power BI and data modeling expertise with hands-on experience supporting project-based professional services organizations, and can work effectively with architects, project managers, and leadership to improve visibility, efficiency, and decision-making. Key Responsibilities

• Partner with both operational and project delivery teams to understand business processes, data needs, and performance challenges
• Analyze and document requirements related to project delivery, utilization, financial performance, scheduling, and operational metrics
• Design, develop, and maintain Power BI dashboards, reports, and semantic models tailored to AEC business needs
• Integrate data from Deltek Vision / Vantagepoint, Autodesk-related platforms, Resource Planning, and other AEC SaaS systems using APIs and data connectors
• Work with Dataverse, SQL, and Azure data services to support structured and scalable data solutions
• Perform data transformation, cleansing, validation, and modeling across multiple project and enterprise data sources
• Develop and optimize DAX measures and calculations to support project, financial, and operational reporting
• Conduct 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 operations
• Support the design and development of analytics solutions that align with professional services workflows and best practices
• Collaborate closely with cross-functional professional teams, IT, and leadership to continuously improve data quality and insights

Requirements

• 4+ years of experience as a Technical Business Analyst, Data Analyst, or similar analytics-focused role
• Advanced experience with Power BI, including data modeling, DAX, and performance optimization
• Strong experience working with SQL, Dataverse, and Azure-based data platforms
• Proven experience integrating and analyzing data from multiple SaaS platforms and APIs
• Strong analytical and problem-solving skills with the ability to interpret complex, multi-source datasets
• Ability to translate AEC business needs into technical solutions and actionable insights
• Excellent communication skills and the ability to work effectively with both technical and non-technical stakeholders

Preferred AEC Experience & Skills

• Prior experience working in an architecture, engineering, or construction (AEC) firm
• Knowledge of Deltek Vision and/or Deltek Vantagepoint, including project, financial, and labor data
• Experience integrating or working with Autodesk Platform Services (APS / Forge) or Autodesk-related datasets
• Familiarity with architectural, engineering, or project delivery data, such as fees, budgets, schedules, utilization, and project performance
• Experience with building, space, or facilities data analysis

Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is occasionally required to stand; walk; sit; use hands to grasp objects; reach with hands and arms; balance, stop, kneel, or crouch; speak or listen. The employee must occasionally lift and/or carry up to 25 pounds. Specific vision abilities required by the job include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to adjust focus.

Workplace Environment WorkWork environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions. While performing the duties of this job, the employee may occasionally be exposed to hazardous working conditions in conjunction with construction site visits. The noise level in the construction zone may be loud. While performing the duties of this job in the office work environment, the employee will not be exposed to hazardous working conditions. The noise level in the office work environment is usually moderate.

McMillan Pazdan Smith Architecture provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation or gender identity), national origin, age (40 or older), disability or genetics. In addition to federal law requirements, McMillan Pazdan Smith Architecture complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment. Applicants also have rights under the following Federal Employment Laws: Family and Medical Leave Act (FMLA), Equal Employment Opportunity (EEO), Employee Polygraph Protection Act (EPPA).