Senior Analytics Engineer

About the role

The Senior Analytics Engineer is responsible for designing, building, and maintaining critical data pipelines, data models, and infrastructure solutions that enable data products across project delivery, operations, and business functions. This is a hands-on implementation role focused on delivering production-ready data solutions.

Responsibilities

• Deliver production-ready ETL/ELT pipelines supporting project, financial, and operational data
• Translate business requirements into clean, scalable data models with minimal rework
• Improve performance, reliability, and usability of existing data pipelines and reporting solutions
• Migrate core data infrastructure from legacy systems to modern platforms, supporting the business's shift to a data product-first strategy
• Effectively collaborate with stakeholders in AEC, design, or project-based environments

Qualifications

• Strong proficiency in SQL and data modeling with a track record of building scalable solutions
• Hands-on experience developing and maintaining ETL/ELT production pipelines
• Experience working with the Azure Data Platform (Data Factory, Data Lake, Databricks preferred) in production environments
• Proven ability integrating data across multiple systems and APIs
• Solid understanding of data warehousing concepts and analytics data structures
• Proven track record translating business needs into technical requirements and delivering actionable data products

Requirements

• 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.
• Data Architecture & Pipeline Development
• Data Quality, Security & Governance

Attributes to Support the NELSON Culture

• Go All In. Own the Outcome
• Be Direct. Be Respectful. Be Authentic
• Grow with Purpose. We embrace growth—through learning, coaching, and continuous improvement
• Think Bold. Execute Smart
• Make Space for Everyone. We value you—and build a culture where people can thrive and do their best work

Qualifications

• 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.
• Data Architecture & Pipeline Development
• Data Quality, Security & Governance

Required Skills & Experience

• Strong proficiency in SQL and data modeling with a track record of building scalable solutions
• Hands-on experience developing and maintaining ETL/ELT production pipelines
• Experience working with the Azure Data Platform (Data Factory, Data Lake, Databricks preferred) in production environments
• Proven ability integrating data across multiple systems and APIs
• Solid understanding of data warehousing concepts and analytics data structures
• Proven track record translating business needs into technical requirements and delivering actionable data products

Preferred Experience

• Experience working with project-based data (financials, schedules, resource planning, or operational delivery data)
• Experience working in environments where data is distributed across multiple systems
• Experience supporting data products in AEC (Architecture, Engineering, Construction), design, or real estate consulting environments OR similar project-based industries (construction, engineering, capital projects)
• Experience with Deltek Vantagepoint, HubSpot, UltiPro, or similar enterprise systems
• Experience with BIM, CAD, or design platforms (Revit, AutoCAD, BIM 360, ACC)
• Experience improving data consistency across disconnected systems
• Experience implementing data quality frameworks to identify where data quality degrades and fix root causes, not just downstream reporting issues
• Experience supporting business intelligence reporting for project performance analytics, forecasting, and/or resource planning
• Understanding of and some hands-on experience with the end-to-end business intelligence build/maintain lifecycle (data model → dataset → dashboard) using Power BI and/or Tableau

Education & Experience

• Bachelor’s Degree in Computer Science, Data (or related field), or equivalent in appropriate education and experience
• 5–8+ years of experience in data engineering, BI, or analytics delivery roles
• Proven experience delivering production data and analytics solutions