Senior Data Engineer

Kastle Systems is hiring a Senior Data Engineer to design, build, and maintain the data infrastructure that supports its access control platform. Based in Falls Church, VA with a hybrid work model, this role partners with product and architecture teams while leading a small data and analytics group responsible for pipelines, data management, and governance aligned with SOC 2, GDPR, and FedRAMP.

In this position, you will shape the end-to-end data platform from ingestion and streaming through modeling, reporting support, and operational migrations, while ensuring data quality, lineage, and security across production workloads.

Responsibilities

• Design and maintain scalable ETL/ELT pipelines ingesting access events, device telemetry, and identity data from distributed physical access control systems
• Architect and evolve a cloud data platform across AWS, Azure, and GCP, including data lake, warehouse, and streaming components
• Build and maintain real-time pipelines using Kafka, Kinesis, or equivalent to support live event dashboards and alerting
• Develop data models for access control entities including doors, readers, credentials, cardholders, zones, schedules, and audit logs
• Own the integration data layer connecting the platform with PIAM, LDAP/Active Directory, HR systems, and BMS (building management systems)
• Own ERP and CRM data management, including data models and master data for customers, sites, accounts, contracts, products, orders, invoices, and service entitlements, plus pipelines between ERP, CRM, support/ticketing, and the access control platform
• Write, tune, and review advanced SQL (complex joins, window functions, CTEs, stored procedures, views) for operational reporting, finance and sales analytics, and cross-system reconciliation
• Lead ERP, CRM, and support platform data migrations and implementations, including mapping, cleansing, deduplication, validation, cutover, and post-go-live reconciliation
• Establish MDM practices and data stewardship standards, including golden-record definitions, ownership, and change control across ERP and CRM
• Ensure data quality, lineage, and observability across all production pipelines
• Implement and enforce data governance, retention, and security policies aligned with SOC 2, GDPR, and FedRAMP
• Lead, mentor, and grow a team of 3–6 data and analytics engineers, including regular 1:1s, performance reviews, and career development planning
• Define and uphold engineering best practices such as code review standards, testing requirements, CI/CD pipelines, and documentation
• Partner with product managers and solutions architects to translate customer requirements into technical roadmap items
• Collaborate with firmware and embedded systems engineers to define data schemas and transmission protocols for access control hardware
• Drive incident response for data pipeline failures impacting customer-facing SLAs
• Participate in technical interviews and contribute to hiring decisions for the data engineering team

Requirements

• 7+ years of professional data engineering experience, including at least 2 years in a lead or people management role
• Expert proficiency in Python and SQL, including advanced analytical and transactional SQL (window functions, CTEs, stored procedures, indexing, query performance tuning) and strong data modeling and warehouse design
• Hands-on experience with cloud data platforms such as Snowflake, Databricks, BigQuery, or Redshift
• Deep experience with data pipeline orchestration tools such as Apache Airflow, Prefect, Dagster, or equivalent
• Proficiency with streaming and event-driven architectures using Kafka, Kinesis, and/or Spark Streaming
• Strong understanding of REST API integration patterns and experience building data connectors for enterprise SaaS systems
• Hands-on experience managing data in ERP and CRM platforms (NetSuite, SAP, Microsoft Dynamics 365, Oracle, Salesforce, HubSpot), including extraction, transformation, and integration via native APIs/connectors and SQL
• Proven experience leading or supporting ERP, CRM, or support platform data migrations or implementations, including mapping, cleansing, validation, and reconciliation
• Working knowledge of master data management, data stewardship, and cross-system data synchronization for customer, product, contract, and financial data
• Familiarity with identity and access management concepts including LDAP, Active Directory, SCIM, OAuth 2.0, and SAML
• Experience designing data systems compliant with security and regulatory frameworks such as SOC 2, ISO 27001, and NIST, as well as GDPR
• Demonstrated ability to deliver projects with cross-functional stakeholders in an agile environment
• Excellent written and verbal communication skills, including the ability to present technical concepts to non-technical audiences

Technologies

• Python, SQL
• AWS, Azure, GCP
• Kafka, Kinesis
• Snowflake, Databricks, BigQuery, Redshift
• Apache Airflow, Prefect, Dagster, Spark Streaming
• REST API
• PIAM, LDAP, Active Directory
• ERP, CRM, NetSuite, SAP, Microsoft Dynamics 365, Oracle, Salesforce, HubSpot
• SCIM, OAuth 2.0, SAML
• SOC 2, GDPR, FedRAMP, ISO 27001, NIST
• CI/CD, MDM

Benefits

• Comprehensive Medical/Dental/Vision
• 401K
• Tuition/Training Assistance
• BrightHorizons Lifestyle Assistance
• Wellness Program
• Hybrid work environment with flexibility to balance in-office and remote work

Company Overview

Kastle Systems is a leader in managed security, introducing innovative technologies for over 460M square feet of real estate globally. Its integrated security solution, including access control, video, and remote video monitoring, helps reduce costs and supports 24x7 performance for building owners, developers, and tenants. Kastle’s mission focuses on delivering world-class customer experience by serving as the customer’s best service provider and ensuring security is effective, efficient, and convenient.

Equal Opportunity Statement

• Kastle believes diversity makes the company and the world stronger
• Kastle Systems International, LLC is an Equal Opportunity / Affirmative Action employer
• All qualified applicants receive consideration without regard to protected status under applicable federal and state laws