Data Engineer

Role Overview

• Design, build, operate, and support ETL/ELT pipelines and integrations across enterprise systems, including Salesforce, Deltek Vantagepoint, Autodesk data sources, Azure, and Microsoft Fabric.
• Implement data models, curated datasets, Lakehouse/Warehouse structures, and transformation layers to support BI, reporting, AI, and machine learning use cases.
• Build and support API-first data services, data contracts, and integration workflows using REST, JSON, SOAP where applicable, webhooks, and related patterns.
• Develop orchestration and scheduling processes using Microsoft Fabric Data Pipelines, Azure Data Factory, Azure Logic Apps, Functions, Spark notebooks, dbt, or similar tools.
• Apply event-driven integration patterns using Event Grid, Service Bus, Kafka concepts, or similar technologies where appropriate.
• Own the operational reliability of pipelines and integrations, including monitoring, alerting, incident response, troubleshooting, root-cause analysis, and remediation.
• Implement data quality checks, validation, lineage, documentation, and governance practices to ensure data is accurate, trusted, and usable.
• Partner with analytics, application, IT/Security, and business teams to support secure access, data governance, compliance, and reliable data delivery.
• Support AI initiatives by preparing reliable datasets, including AI/ML pipelines or RAG-oriented datasets where applicable.
• Use AI tools responsibly to improve productivity, accelerate development, support testing, and improve documentation while maintaining security and quality standards.

Requirements

• 5+ years of experience designing, building, and operating production data pipelines and integrations.
• Bachelor’s degree in Computer Science, Data Engineering, Information Systems, Engineering, or a related field; directly relevant experience, certifications, or training demonstrating comparable expertise in data pipelines, integrations, cloud data platforms, APIs, data governance, and secure data workflows may be considered in lieu of a degree.
• Strong SQL skills and experience with PostgreSQL or similar relational databases.
• Proficiency in Python for data engineering, automation, and workflow development.
• Hands-on experience with Microsoft Azure data services and Microsoft Fabric, or equivalent cloud data platforms.
• Experience with ETL/ELT pipelines, data modeling, curated datasets, orchestration, and production data workflows.
• Strong experience with APIs and integration patterns, including REST, webhooks, authentication, error handling, retry strategies, and cross-system data movement.
• Familiarity with SDLC and CI/CD for data workflows using GitHub Enterprise, Azure DevOps, or similar tools.
• Strong understanding of security, data governance, access controls, and secure handling of sensitive business information.
• Ability to communicate clearly with technical and non-technical stakeholders in an AEC or similar business environment.
• Operational discipline with the ability to maintain, monitor, troubleshoot, and improve mission-critical data flows over time.

Tech Stack

• Azure
• Cloud
• ETL
• Kafka
• Postgres
• Python
• SDLC
• SOAP
• Spark
• SQL

Benefits

• Additional PTO between Christmas and New Years
• Your birthday off
• Community involvement through recreation & service
• Hybrid schedule & remote work options
• Flexible "dress for your day" policy
• Paid parental leave for birth or adoption
• Firm covers employee healthcare premiums
• 401(k) program
• Costco / Sam's Club membership
• $4,000 license bonus
• Dynamic company with quick advancement
• Online professional licensure exam prep library
• Opportunities to work on a variety of project types
• Weekly continuing education lunch & learn sessions