Senior Data Engineer

Kastle Systems•Falls Church, VA

6d•Hybrid

About The Position

Kastle Systems is hiring a Senior Data Engineer to design, build, and maintain the data infrastructure supporting its physical access control platform. The role leads a small team of data and analytics engineers and connects security hardware, cloud platforms, and enterprise systems. The engineer owns pipelines that ingest access events and device telemetry, provide customer intelligence, and support compliance and audit workflows. The role also manages data for core business systems—including ERP, CRM, and customer support platforms—using advanced SQL to model, reconcile, and govern business data for a trusted source of truth across product, operations, finance, and sales. The Senior Data Engineer will architect cloud data systems, build real-time and batch pipelines, manage integrations and master data, and establish data quality, observability, governance, retention, and security practices. The role includes people management, technical standards, project delivery, incident response, stakeholder collaboration, and participation in hiring. Kastle describes the work environment as hybrid, with flexibility to balance in-office and remote work.

Requirements

At least 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, and query performance tuning; strong data modeling and warehouse design skills.
Hands-on experience with cloud data platforms such as Snowflake, Databricks, BigQuery, or Redshift.
Deep experience with pipeline orchestration tools such as Apache Airflow, Prefect, Dagster, or equivalent.
Proficiency with streaming and event-driven architectures such as Kafka, Kinesis, or Spark Streaming.
Strong understanding of REST API integration patterns and experience building data connectors for enterprise SaaS systems.
Hands-on experience managing ERP and CRM data, including extraction, transformation, and integration through native APIs, connectors, and SQL.
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 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 that comply with security and regulatory frameworks such as SOC 2, ISO 27001, NIST, and GDPR.
Ability to manage and 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.

Nice To Haves

Experience in physical security, access control, or IoT/device management.
Familiarity with access control protocols and standards such as OSDP, Wiegand, PACS, or ONVIF.
Background working with PIAM platforms such as Lenel, Genetec, Honeywell Pro-Watch, Gallagher, or CCURE.
Experience with ERP/CRM reporting and analytics tools such as Salesforce reporting, NetSuite SuiteAnalytics, Power BI, or Tableau, and integration or iPaaS tools such as MuleSoft, Boomi, Workato, or 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.

Responsibilities

Design and maintain scalable ETL/ELT pipelines for access events, device telemetry, and identity data from distributed physical access control systems.
Architect and evolve cloud data platforms, including data lakes, warehouses, and streaming components.
Build and maintain real-time data pipelines using Kafka, Kinesis, or equivalent technologies for live 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 building management systems.
Manage ERP and CRM data models, master data, and pipelines between ERP, CRM, support/ticketing systems, and the access control platform.
Write, tune, and review advanced SQL for operational reporting, finance and sales analytics, and cross-system data reconciliation.
Lead ERP, CRM, and support-platform data migrations and implementations, including mapping, cleansing, deduplication, validation, cutover, and post-go-live reconciliation.
Establish master data management practices and data stewardship standards, including golden-record definitions, ownership, and change control.
Ensure data quality, lineage, and observability across production pipelines.
Implement and enforce data governance, retention, and security policies aligned with SOC 2, GDPR, and FedRAMP requirements.
Lead, mentor, and grow a team of 3–6 data and analytics engineers.
Conduct regular one-on-ones, performance reviews, and career development planning for direct reports.
Define and uphold engineering practices for code reviews, testing, CI/CD, and documentation.
Partner with product managers and solutions architects to translate customer requirements into technical roadmap items.
Collaborate with firmware and embedded systems engineers on 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 data engineering hiring decisions.