About the Role
The Data Engineer designs, builds, and supports data pipelines, integrations, and curated datasets to power analytics, reporting, and AI initiatives for PBK’s Architecture vertical and broader AEC operations. This role owns integrations across enterprise platforms and ensures data reliability, governance, security, and availability.
Responsibilities
- Design, build, operate, and support ETL/ELT pipelines and integrations across enterprise systems.
- Implement data models, curated datasets, Lakehouse/Warehouse structures, and transformation layers.
- Build and support API-first data services, data contracts, and integration workflows.
- 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.
- 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.
- 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.
- Use AI tools responsibly to improve productivity, accelerate development, support testing, and improve documentation.
Requirements
- 5+ years of experience designing, building, and operating production data pipelines and integrations.
- 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.
Skills
- Salesforce
- Deltek Vantagepoint
- Autodesk data sources
- Azure
- Microsoft Fabric
- REST
- JSON
- SOAP
- webhooks
- Microsoft Fabric Data Pipelines
- Azure Data Factory
- Azure Logic Apps
- Azure Functions
- Spark notebooks
- dbt
- Event Grid
- Service Bus
- Kafka concepts
- Python
- PostgreSQL
- GitHub Enterprise
- Azure DevOps
- Autodesk Forma
- Microsoft 365
- MuleSoft
- Databricks
- Snowflake
- Airflow
- Databricks Workflows/Jobs
- Power BI semantic models
Location
- Hybrid
Work Type
- Hybrid
- Remote
Experience Level
- 5+ years of experience
Education Level
- Bachelor’s degree in Computer Science, Data Engineering, Information Systems, Engineering, or a related field
- Directly relevant experience, certifications, or training demonstrating comparable expertise may be considered in lieu of a degree
Benefits
- Alternative work scheduling
- Monthly happy hours
- Regular team outings
- Additional time off between Christmas and New Year’s
- Employee Assistance Program
- Additional PTO between Christmas and New Years
- Your birthday off
- Community involvement through recreation & service
- 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
- Online professional licensure exam prep library
- Opportunities to work on a variety of project types
- Weekly continuing education lunch & learn sessions
About the Company
- At PBK, the most accomplished and passionate architects, engineers, and thought leaders are working together to shape the future.
- We encourage our team to adopt an entrepreneurial approach to professional growth; there are no limits to what one can do or become at PBK.
- Our culture empowers our people to explore their interests, try new things, and create their own path to success – however they may define it.
- We recognize the value of work-life balance and believe in rewarding our employees’ hard work.
