Data Engineer

NELSON Worldwide is a firm focused on design, planning, and construction analytics. The Data Engineer will be responsible for developing data infrastructure, building robust data pipelines, and enabling data-driven decision-making across the organization.

Responsibilities:

• Design, develop, and maintain scalable Extract, Transform, Load/Extract, Load, Transform (ETL/ELT) pipelines for structured and unstructured AEC (Architecture, Engineering, Construction) and business operational data (BIM models, CAD files, project schedules/delivery data, finance/resourcing/reforecasting data, IoT/sensor data)
• Build and optimize data architectures supporting analytics, visualization, and AI/machine learning initiatives
• Design, build and maintain data pipelines and integrations between multiple systems/platforms leveraging tools such as Workato, Azure Data Factory, Databricks, SQL Server Integration Services and Microsoft Power Automate
• Experience leveraging API integrations as well as direct server to server integrations
• Ensure data is collected, stored, and accessible in reliable, scalable ways
• Optimize data workflows for performance, security, and cost
• Partner with IT, Enterprise and Practices to enable smooth data operations
• Develop and maintain cloud-based data lakes, warehouses, and relational databases (MSSQL, Azure SQL, AWS, GCP)
• Author, maintain and manage complex database stored procedures and job schedules
• Partner with business intelligence teams to develop, maintain and streamline enterprise semantic layers leveraging Tableau, PowerBI and Databricks
• Ensure data integrity, governance, versioning, and strong documentation standards
• Improve data accessibility for business leaders, designers and project managers
• Strong knowledge of Deltek Vantage Point, HubSpot and UltiPro a plus
• Work with business intelligence teams to support dashboards, forecasting tools, and project performance analytics
• Support automation initiatives that reduce manual work in the design and project delivery process
• Transform design and project data into standardized structures for forecasting, resource planning, carbon accounting, and operational analytics
• Enable integration and acceleration of Artificial Intelligence and Machine Learning (AI/ML) into business workflows
• Evaluate emerging technologies and help shape the firm’s digital strategy
• Implement data validation, audit processes, and error‑handling frameworks
• Ensure compliance with data privacy, security standards, and IT policies
• Create documentation, metadata, data dictionaries, and best‑practice guidelines

Requirements:

• Design, develop, and maintain scalable Extract, Transform, Load/Extract, Load, Transform (ETL/ELT) pipelines for structured and unstructured AEC (Architecture, Engineering, Construction) and business operational data (BIM models, CAD files, project schedules/delivery data, finance/resourcing/reforecasting data, IoT/sensor data)
• Build and optimize data architectures supporting analytics, visualization, and AI/machine learning initiatives
• Design, build and maintain data pipelines and integrations between multiple systems/platforms leveraging tools such as Workato, Azure Data Factory, Databricks, SQL Server Integration Services and Microsoft Power Automate
• Experience leveraging API integrations as well as direct server to server integrations
• Ensure data is collected, stored, and accessible in reliable, scalable ways
• Optimize data workflows for performance, security, and cost
• Partner with IT, Enterprise and Practices to enable smooth data operations
• Develop and maintain cloud-based data lakes, warehouses, and relational databases (MSSQL, Azure SQL, AWS, GCP)
• Author, maintain and manage complex database stored procedures and job schedules
• Partner with business intelligence teams to develop, maintain and streamline enterprise semantic layers leveraging Tableau, PowerBI and Databricks
• Ensure data integrity, governance, versioning, and strong documentation standards
• Improve data accessibility for business leaders, designers and project managers
• Work with business intelligence teams to support dashboards, forecasting tools, and project performance analytics
• Support automation initiatives that reduce manual work in the design and project delivery process
• Transform design and project data into standardized structures for forecasting, resource planning, carbon accounting, and operational analytics
• Enable integration and acceleration of Artificial Intelligence and Machine Learning (AI/ML) into business workflows
• Evaluate emerging technologies and help shape the firm's digital strategy
• Implement data validation, audit processes, and error‑handling frameworks
• Ensure compliance with data privacy, security standards, and IT policies
• Create documentation, metadata, data dictionaries, and best‑practice guidelines
• Bachelor's degree in data management or related field from an accredited University
• 10+ years' experience; or equivalent in appropriate education and experience in design profession and/or real estate consulting
• Strong knowledge of Deltek Vantage Point, HubSpot and UltiPro a plus