Senior Data Engineer

Kastle Systems is a leader in managed security solutions, offering cutting‑edge technologies to enhance the safety and security of commercial buildings, residential complexes, and government facilities. We are on a mission to deliver scalable, innovative security services with our powerful tech stack, open platform, and managed service business model.

We are a fast‑growing security technology company specializing in enterprise‑grade physical access control systems and deep platform integrations. Our solutions protect critical infrastructure, commercial real estate, healthcare facilities, and government campuses worldwide. We build proprietary hardware‑software ecosystems and partner with leading identity providers, PIAM platforms, and building management systems to deliver seamless, intelligent security operations at scale.

We are looking for a Senior Data Engineer with proven people management experience to join our engineering organization and help us unlock the full potential of the data our systems generate — from access events and device telemetry to integration pipelines and compliance reporting.

In addition to a collaborative work environment in a cutting‑edge industry, we provide excellent benefits (Comprehensive Medical/Dental/Vision, 401K, Tuition/Training Assistance, Bright Horizons Lifestyle Assistance, Wellness Program, etc.). This role would also offer a hybrid work environment with the flexibility to balance in‑office and remote work. We are proud to be a Certified Great Place to Work with awards for being a Top Work Place with Top Diversity, Equity, & Inclusion practices!

Please visit Kastle Careers to learn more about working with Kastle.

As a Senior Data Engineer, you will design, build, and maintain the data infrastructure that powers our access control platform. You will lead a small team of data and analytics engineers, set technical standards, and serve as the connective tissue between our security hardware, cloud platform, and the enterprise systems our customers integrate with. You will own the data pipelines that ingest millions of daily access events, deliver actionable intelligence to customers, and feed the compliance and audit workflows our enterprise clients depend on.

You will also own the data management layer for our core business systems — ERP, CRM, and customer support platforms — using advanced SQL to model, reconcile, and govern customer, contract, order, billing, and service data so that product, operations, finance, and sales teams work from a single trusted source of truth.

• Design and maintain scalable ETL/ELT pipelines ingesting access events, device telemetry, and identity data from distributed physical access control systems
• Architect and evolve our cloud data platform (AWS/Azure/GCP) including data lake, warehouse, and streaming components
• Build and maintain real‑time data pipelines using Kafka, Kinesis, or equivalent to support live event dashboards and alerting
• Develop data models for access control entities: doors, readers, credentials, cardholders, zones, schedules, and audit logs
• Own the integration data layer connecting our platform with PIAM, LDAP/Active Directory, HR systems, and building management systems (BMS)
• Own ERP and CRM data management: design and maintain data models, master data (customers, sites, accounts, contracts, products, orders, invoices, and service entitlements), and pipelines between ERP, CRM, support/ticketing, and our access control platform
• Write, tune, and review advanced SQL (complex joins, window functions, CTEs, stored procedures, views) to support operational reporting, finance and sales analytics, and data reconciliation…