Kastle Systems is seeking a Senior Data Engineer to design, build, and maintain the data infrastructure that supports its access control platform. The role is responsible for owning production data pipelines and data management across ERP and CRM systems, while leading a small data and analytics team.
Location and Work Model
Falls Church, VA (hybrid)
Key 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 data pipelines using Kafka, Kinesis, or equivalent tools to support 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 (BMS)
- Own ERP and CRM data management by designing and maintaining data models, master data, and pipelines between ERP, CRM, support/ticketing systems, and the access control platform
- Write, tune, and review advanced SQL including complex joins, window functions, CTEs, stored procedures, and views for operational reporting and analytics
- Lead ERP/CRM/support platform data migrations and implementations, including 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
- 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
- Lead, mentor, and grow a team of 3–6 data and analytics engineers through 1:1s, performance reviews, and career development
- Define and uphold engineering best practices including code review standards, testing requirements, 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 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
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, 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 including Apache Airflow, Prefect, Dagster, or equivalent
- Proficiency with streaming and event-driven architectures using 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 data in ERP and CRM platforms such as NetSuite, SAP, Microsoft Dynamics 365, Oracle, Salesforce, and HubSpot, including extraction, transformation, and integration via APIs, connectors, and SQL
- Proven experience leading or supporting ERP, CRM, or support platform data migrations or implementations
- Working knowledge of MDM, 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 that comply with security and regulatory frameworks such as SOC 2, ISO 27001, and NIST, including GDPR
- Demonstrated 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
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 (including CI/CD pipelines), 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 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. The company delivers a customer experience centered on being customers’ best service provider and ensuring security is the most effective, efficient, and convenient.
Kastle’s integrated security solution, including access control, video, and remote video monitoring, is designed to reduce costs while improving 24x7 performance for building owners, developers, and tenants.
Equal Opportunity Statement
- Kastle believes that diversity makes the company stronger at work and in the world.
- Kastle Systems International, LLC is an Equal Opportunity / Affirmative Action employer.
- All qualified applicants 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.
