Senior Data Engineer

Kastle; Falls Church (VA); Hybrid; USD 140,000 - 190,000; Full time

Benefits offered by this job

Health benefits

401K

Tuition assistance

Wellness program

Hybrid work

Job summary

Kastle Systems seeks a Senior Data Engineer to design, build, and maintain data infrastructure powering our access control platform. You will lead a small team, set standards, and bridge security hardware, cloud platform, and enterprise systems.

You will own data pipelines ingesting millions of events, develop master data for ERP/CRM, and ensure data quality, governance, and security in a SOC 2/GDPR context. Hybrid work balances in-office and remote collaboration.

Qualifications

• 7+ years of data engineering experience with leadership exposure
• Proficiency in Python and SQL for analytical and transactional workloads
• Experience with cloud data platforms and data pipelines for enterprise systems
• Strong data modeling, ERPs/CRMs integrations, and data governance knowledge
• Experience with SOC 2, GDPR, and security/compliance considerations

Responsibilities

• Design and maintain scalable ETL/ELT pipelines ingesting access events, device telemetry, and identity data
• Architect and evolve our cloud data platform (AWS/Azure/GCP) with lake, warehouse, and streaming components
• Build real-time data pipelines using Kafka, Kinesis, or equivalent for live dashboards and alerts
• Develop data models for doors, readers, credentials, cardholders, zones, schedules, and logs
• Own integration data layer connecting our platform with PIAM, LDAP/AD, HR systems, and BMS
• Manage ERP and CRM data models and master data across customers, sites, accounts, contracts, orders, invoices
• Write and tune advanced SQL for reporting, analytics, and reconciliation across systems
• Lead ERP/CRM uncover data migrations and implementations including mapping, cleansing, cutover
• Establish MDM and data stewardship standards across ERP/CRM systems
• Ensure data quality, lineage, observability, governance and security per SOC 2/GDPR

Skills

Python

SQL

Cloud platforms (AWS/GCP/Azure)

Snowflake

Databricks

BigQuery

Redshift

Apache Airflow

Kafka

REST API integration

ERP/CRM data management

Data modeling

Data governance

Data migrations

Power BI

Tableau

Job description

Overview

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, BrightHorizons 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.

Responsibilities

Role overview

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.

Key responsibilities

Data Engineering & Architecture

• 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 across systems
• Lead ERP, CRM, and support platform data migrations and implementations, including data mapping, cleansing, deduplication, validation, cutover, and post‑go‑live reconciliation
• Establish master data management (MDM) practices and data stewardship standards, including golden‑record definitions, ownership, and change control across ERP and CRM systems
• Ensure data quality, lineage, and observability across all production pipelines
• Implement and enforce data governance, retention, and security policies in alignment with SOC 2, GDPR, and FedRAMP requirements

Technical Leadership & Management

• Lead, mentor, and grow a team of 3–6 data and analytics engineers
• Conduct regular 1:1s, performance reviews, and career development planning for direct reports
• Define and uphold engineering best practices: 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 affecting customer‑facing SLAs
• Participate in technical interviews and contribute to hiring decisions for the data engineering team

Qualifications

Required qualifications

• 7+ years of professional data engineering experience, with at least 2 years in a lead or people management role
• Expert proficiency in Python and SQL (advanced analytical and transactional SQL, including window functions, CTEs, stored procedures, indexing, and query performance tuning); strong command of 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 (Apache Airflow, Prefect, Dagster, or equivalent)
• Proficiency with streaming and event‑driven architectures (Kafka, Kinesis, 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 (e.g., NetSuite, SAP, Microsoft Dynamics 365, Oracle, Salesforce, HubSpot), including data 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 data 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: LDAP, Active Directory, SCIM, OAuth 2.0, SAML
• Experience designing data systems that comply with security and regulatory frameworks (SOC 2, ISO 27001, NIST, GDPR)
• Demonstrated ability to manage and deliver projects with cross‑functional stakeholders in an agile environment
• Excellent written and verbal communication skills; ability to present technical concepts to non‑technical audiences

Preferred qualifications

• Experience in the physical security, access control, or IoT/device management industry
• Familiarity with access control protocols and standards such as OSDP, Wiegand, PACS, or ONVIF
• Background working with PIAM platforms (Lenel, Genetec, Honeywell Pro‑Watch, Gallagher, CCURE, or similar)
• Experience with ERP/CRM reporting and analytics (e.g., Salesforce reporting, NetSuite SuiteAnalytics, Power BI, Tableau, or similar) and with integration or iPaaS tools (e.g., MuleSoft, Boomi, Workato, Fivetran)
• Experience with graph databases or network analysis for entity relationship modeling
• Knowledge of edge computing data ingestion from on‑premise access control panels or controllers
• Contributions to open‑source data projects or published technical writing
• AWS, GCP, or Azure data engineering certifications

Company Overview

Kastle Systems is the leader in managed security, with a track record of introducing innovative technologies to serve over 460M square feet of real estate globally. Clients span the commercial and multifamily real estate, education, and construction industries and the customers they serve. Delivering a world class customer experience drives everything we do, and Kastle’s mission is to be our customers’ best service provider and to ensure that their security the most effective, efficient and convenient. Kastle's integrated security solution, including access control, video, and remote video monitoring, significantly reduces costs and improves the critically important 24x7 performance for building owners, developers and tenants.

Equal Opportunity Statement

At Kastle, we believe that diversity makes us stronger - at work and in the world. Kastle Systems International, LLC is an Equal Opportunity / Affi­rmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, marital status, pregnancy or any other basis protected by applicable federal or state laws.

#DatabaseAdministration #DBA #DataEngineering #SQL #PostgreSQL #MySQL #MicrosoftSQLServer #DataSecurity #DataIntegrity #CloudComputing #DataGovernance #ETL #DataPipelines #BigData #DataAnalytics #DevOps #Automation #CyberSecurity #AIinDatabases #PerformanceTuning #DataEngineer #SeniorDataEngineer #DataArchitect #ETLDeveloper #DataPipelineEngineer #BusinessIntelligenceDeveloper #DataOperationsEngineer #DataOpsEngineer #DatabaseAdministrator #DBA #BigDataEngineer #CloudDataEngineer