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