Director

Job Description

Responsibilities 

Schema Design & Data Modeling

• Design and maintain standardized data schemas used across different data sources and storage systems.
• Define data contracts and models to ensure consistent representation of entities such as users, groups, resources, and permissions.
• Develop and maintain schema evolution and versioning processes to support iterative product development.
• Ensure data models are optimized for both transactional and analytical workloads.
• Collaborate with engineering and product teams to align data models with business logic and reporting requirements.

Analytical & Application Storage

• Design and optimize ClickHouse schemas for analytical and time-series workloads.
• Iterate on and maintain PostgreSQL schemas for metadata, configuration, and application-level data.
• Develop indexing, partitioning, and retention strategies that balance performance, scalability, and cost.
• Define transformation specifications to ensure consistency between raw and analytical data layers.

Data Quality & Governance

• Establish naming conventions, data types, and relationship standards for all stored data.
• Implement validation and normalization checks to ensure incoming data adheres to defined schemas.
• Partner with QA and product teams to verify that stored data accurately represents system behavior and business intent.
• Maintain clear documentation and metadata definitions for all datasets and structures.

Infrastructure & Automation

• Manage schema migrations and versioning through CI/CD workflows.
• Collaborate with DevOps teams to deploy and monitor databases in Kubernetes-based environments.
• Use Infrastructure as Code tools (Helm, Terraform, or similar) for consistent database provisioning.
• Support observability and monitoring for data performance and reliability.

Qualifications 

Data & Database Expertise

• 5+ years of experience in data engineering, backend development, or database architecture.
• Hands-on experience with ClickHouse or other columnar analytics databases (e.g., Redshift, BigQuery, Snowflake).
• Strong proficiency in PostgreSQL and SQL query optimization.
• Solid understanding of database administration, indexing, and performance tuning.

Data Modeling & Standards

• Demonstrated experience designing data models for complex or multi-system environments.
• Familiarity with data contracts, schema evolution, and versioning best practices.
• Experience enforcing data standards and conventions across teams or systems.
• Understanding of metadata and documentation management (e.g., dbt, OpenMetadata, or similar).

DevOps & Tooling

• Experience deploying and managing databases with Kubernetes and containers.
• Knowledge of CI/CD pipelines and Infrastructure as Code (Helm, Terraform, GitHub Actions, etc.).
• Understanding of observability and performance monitoring for data systems.

Are you interested in this position?
Apply by clicking on the “Apply Now” button below!
#GraphicDesignJobsOnline
#WebDesignRemoteJobs
#FreelanceGraphicDesigner
#WorkFromHomeDesignJobs
#OnlineWebDesignWork
#RemoteDesignOpportunities
#HireGraphicDesigners
#DigitalDesignCareers
# Dynamicbrand guru