Data Architect - Data Warehousing

Job Description : The Data Architect is an individual with a passion for designing and architecting complex systems in a cloud environment and who possesses strong leadership and technical skills. In this role, you will play a crucial role in shaping the architecture of our systems, ensuring their scalability, reliability, and efficiency. Collaborating closely with stakeholders, you will analyse requirements, design comprehensive system architectures, and define data models and flows. Additionally, you will lead efforts in implementing robust security measures and optimizing system performance.We welcome candidates from Chandigarh and Bangalore to complement our existing teams.What You'll Be Responsible For :Collaborate with stakeholders to analyse the requirements for new systems and enhancements.Design comprehensive system architectures, identifying components, modules, and their interactions.Given the architecture strategy related to our big data, analytics and cloud native product vision, work on the concrete architecture design and, when necessary, prototype itDefine data architecture, including data models, databases, and data flows.Architect the underlying infrastructure, encompassing servers, networks, and databases.Design Databases, APIs, and communication protocols for system components.Implement robust security measures to safeguard systems against cyber threats.Optimize systems for performance, scalability, reliability, and efficiency.Provide technical guidance and mentorship to development teams.Drive data modeling, ETL processes, and data warehousing concepts.Integrate cybersecurity principles and best practices into system design.Basic Qualifications :6-10 years of experience as a hands-on data or software engineer.5+ years of experience in leading the system design and architecture of large-scale systems.Proficiency in programming languages such as Java, Python, Ruby, or Go.In-depth knowledge and hands-on experience in architecting and optimising large-scale database clusters, specifically MySQL and PostgreSQL, for performance, scalability, and reliability.Proficiency in microservices architecture and containerization technologies (e.g., Docker, Kubernetes).Experience with designing and architecting complex systems in a cloud environment (AWS, Azure, GCP).Knowledge of tenant data segregation techniques, such as schema-based multi-tenancy, database-per-tenant, and hybrid approaches, is essential for ensuring data isolation and privacy.Expertise in database design, including SQL and NoSQL databases, with a specific focus on MySQL and PostgreSQLKnowledge of networking protocols, security standards, and best practices.Excellent communication and collaboration skills.Technical Requirements :Proficiency in infrastructure as code tools such as Terraform or AWS CloudFormation.Experience with containerisation technologies such as Docker and container orchestration platforms like Kubernetes.Proficiency in implementing advanced replication topologies, such as master-slave replication, multi-master replication, and synchronous replication, for MySQL and PostgreSQL databases.Knowledge of database partitioning techniques, such as range partitioning, hash partitioning, and list partitioning, is essential for optimising storage and query performance in large-scale database clusters.Familiarity with high availability architectures, such as active-passive and active-active configurations, is essential for ensuring continuous availability and reliability of MySQL and PostgreSQL databases.Familiarity with microservices architecture and related tools such as Istio, Envoy, or Linkerd.Knowledge of CI/CD pipelines and related tools such as Jenkins, GitLab CI/CD, or CircleCI.Experience with monitoring and observability tools such as Prometheus, Grafana, ELK stack (Elasticsearch, Logstash, Kibana), or Splunk.Familiarity with configuration management tools like Ansible, Puppet, or Chef.Proficiency in version control systems such as Git.Knowledge of scripting languages such as Bash, PowerShell, Ruby, or Python for automation tasks.Understanding of cloud-native security practices and tools such as Google Identity and Access Management (IAM), AWS Key Management Service (KMS), or Azure Active Directory.Familiarity with network security concepts such as VPNs, firewalls, and intrusion detection and prevention systems (IDS/IPS).Preferred Qualifications :Bachelor's or above in computer science, Information Systems or Engineering from top-ranked colleges.Experience with DevOps practices and tools (e.g., CI/CD pipelines, infrastructure as code).Proficiency in implementing advanced indexing strategies, query optimisation techniques, and database tuning methodologies for optimising the performance of MySQL and PostgreSQL databases.Familiarity with monitoring and logging tools for system performance analysis.Experience with distributed systems and message queuing systems (e.g., Kafka, RabbitMQ).Proficiency in designing and implementing RESTful APIs.What You'll Bring to Maropost:Experience in deploying, managing, and fine-tuning large-scale database clusters, specifically MySQL and PostgreSQL, in self-managed environments.Adaptability to changing requirements and priorities in a dynamic environment.Strong problem-solving abilities and attention to detail.Understanding of agile development methodologies and tools such as Scrum, Kanban, or Agile Project Management software.Extensive experience in designing, implementing, and optimising multi-tenant architectures for applications, ensuring efficient resource utilisation and isolation between tenants.Proficiency in implementing authentication and authorization mechanisms for multi-tenant applications, including role-based access control (RBAC) and fine-grained permissions management.Ability to work independently and as part of a team. (ref:hirist.tech)