Data Engineer

NELSON Worldwide • Atlanta, GA

35d • Hybrid

About The Position

The Data Engineer will play a critical role in developing the data
infrastructure that supports design, planning, construction analytics, and
business operations across the firm. This role focuses on building robust data
pipelines, integrating architecture and design software systems, and enabling
data-driven decision-making for project teams, leadership, and clients.

Critical features of this job are described under the headings below. They may
be subject to change at any time due to reasonable accommodation or other
reasons.

Requirements

• 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

Nice To Haves

• Strong knowledge of Deltek Vantage Point, HubSpot and UltiPro a plus

Responsibilities

• Data Architecture & Pipeline Development:
• 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
• Semantic Layer, Database & Infrastructure Management:
• 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.
• Cross‑Functional Collaboration:
• 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.
• Analytics & Innovation:
• 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.
• Data Quality, Security & Governance:
• 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.

Benefits

• 401(K) plan with company match
• Full health benefits including medical, dental, and vision
• Wellness program with rewards for healthy activities
• Pet Insurance
• Opportunities for career advancement
• Paid time off and holiday pay
• Paid parental leave
• Flexible working schedules and work from home options based on client’s needs
• Professional Development including discretionary support and reimbursement for registrations, certifications, and membership to a professional organization

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level