DataJobs.io
← Back to all jobs

Job Description

Kastle Systems is hiring a Senior Data Engineer to design, build, and maintain the data infrastructure that powers its access control platform. This hybrid role in Falls Church, VA includes leading a small data and analytics team while owning core pipelines, integrations across ERP/CRM systems, and data governance aligned with SOC 2, GDPR, and FedRAMP.

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 on AWS, Azure, or GCP, covering data lake, warehouse, and streaming components
  • Build and maintain real-time data pipelines using Kafka, Kinesis, or equivalent technologies 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 building management systems (BMS)
  • Own ERP and CRM data management, including data models and master data covering 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 using complex joins, window functions, CTEs, stored procedures, and views for operational reporting, finance and sales analytics, and cross-system reconciliation
  • 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 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 for code review, testing, 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

Required Qualifications

  • 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), along with strong data modeling and warehouse design skills
  • 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 including Kafka, Kinesis, and 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/support platform data migrations or implementations, including 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
  • 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, 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

About Kastle Systems

Kastle Systems is the leader in managed security, introducing innovative technologies to serve over 460M square feet of real estate globally. Its clients span commercial and multifamily real estate, education, and construction industries. Kastle’s integrated security solution, including access control, video, and remote video monitoring, is designed to reduce costs and improve 24x7 performance for building owners, developers, and tenants.

Equal Opportunity Statement

Kastle Systems believes diversity makes the organization stronger. 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.

Similar Jobs