Principal Data Architect

3 days ago

Bareilly, India Dhira Full time

Position Overview:

We are seeking a Principal Data Architect with 15+ years of experience who has a comprehensive understanding of the evolution of databases, from OLTP to OLAP, and relational systems to NoSQL, Graph, and emerging Vector Databases. This role requires deep expertise in data modeling, from traditional ER modeling to advanced dimensional, graph, and vector schemas, along with a strong grasp of the history, best practices, and future trends in data management.

The ideal candidate will bring both historical context and cutting-edge expertise to architect scalable, high-performance data solutions, driving innovation while maintaining strong governance and best practices. This is a leadership role that demands a balance of technical excellence, strategic vision, and team mentorship.


Responsibilities

1. Data Modeling Expertise:

  • Design and implement Entity-Relationship Models (ER Models) for OLTP systems, ensuring normalization and consistency.
  • Transition ER models into OLAP environments with robust dimensional modeling, including star and snowflake schemas.
  • Develop hybrid data models that integrate relational, NoSQL, Graph, and Vector Database schemas.
  • Establish standards for schema design across diverse database systems, focusing on scalability and query performance.

2. Database Architecture Evolution:

Architect solutions across the database spectrum-

  • Relational databases (PostgreSQL, Oracle, MySQL)
  • NoSQL databases (MongoDB, Cassandra, DynamoDB) 
  • Graph databases (Neo4j, Amazon Neptune 
  • Vector databases (Pinecone, Weaviate, Milvus).
  • Implement hybrid data architectures combining OLTP, OLAP, NoSQL, Graph, and Vector systems for diverse business needs.
  • Ensure compatibility and performance optimization across these systems for real-time and batch processing.

3 Data Warehousing and Analytics:

  • Lead the development of enterprise-scale Data Warehouses capable of supporting advanced analytics and business intelligence.
  • Design high-performance ETL/ELT pipelines to handle structured and unstructured data with minimal latency.
  • Optimize OLAP systems for petabyte-scale data storage and low-latency querying.

4. Emerging Database Technologies:

  • Drive adoption of Vector Databases for AI/ML applications, enabling semantic search and embedding-based queries.
  • Explore cutting-edge technologies in data lakes, lakehouses, and real-time processing systems.
  • Evaluate and integrate modern database paradigms, ensuring scalability for future business requirements.

5. Strategic Leadership:

  • Define the organization’s data strategy, aligning with long-term goals and emerging trends.
  • Collaborate with business and technical stakeholders to design systems that balance transactional and analytical workloads.
  • Lead efforts in data governance, ensuring compliance with security and privacy regulations.

6. Mentorship and Innovation:

  • Mentor junior architects and engineers, fostering a culture of learning and technical excellence.
  • Promote innovation by introducing best practices, emerging tools, and modern methodologies in data architecture.
  • Act as a thought leader in database evolution, presenting insights to internal teams and external forums.


Required Skills & Qualifications:

•  Experience:

  • 15+ years of experience in data architecture, with demonstrated expertise across OLTP, OLAP, NoSQL, Graph, and Vector databases.
  • Proven experience designing and implementing data models across relational, NoSQL, graph, and vector systems.
  • A strong understanding of the evolution of databases and their impact on modern data architectures.

• Technical Proficiency:

  • Deep expertise in ER modeling, dimensional modeling, and schema design for modern database systems
  • Proficient in SQL and query optimization for relational and analytical databases.
  • Hands-on experience with NoSQL databases like MongoDB, Cassandra, or DynamoDB.
  • Strong knowledge of Graph databases (Neo4j, Amazon Neptune) and Vector databases (Pinecone, Milvus, or Weaviate).
  • Familiarity with modern cloud-based DW platforms (e.g., Snowflake, BigQuery, Redshift) and lakehouse solutions.

• Knowledge of Data Practices:

  • Historical and practical understanding of data practices, from schema-on-write to schema-on-read approaches.
  • Experience in implementing real-time and batch processing systems for diverse workloads.
  • Strong grasp of data lifecycle management, governance, and security practices.

• Leadership and Communication:

  • Ability to lead large-scale data initiatives, balancing technical depth and strategic alignment.
  • Excellent communication skills to articulate complex ideas to technical and non-technical audiences.
  • Proven ability to mentor and upskill teams, fostering a collaborative environment

Preferred Skills:

•  Experience integrating Vector Databases into existing architectures for AI/ML workloads.

•  Knowledge of real-time streaming systems (Kafka, Pulsar) and their integration with modern databases.

•  Certifications in data-related technologies (e.g., AWS, GCP, Snowflake, Neo4j).

• Hands-on experience with BI tools (e.g., Tableau, Power BI) and AI/ML platforms.

  • Founder Principal

    2 months ago

    bareilly, India Seth M. R. Jaipuria Schools Full time

    About the role :The School Principal is responsible for providing leadership, direction, and oversight to ensure the effective operation and success of the school. This role involves managing faculty and staff, maintaining a safe and nurturing learning environment, fostering academic excellence, and collaborating with stakeholders to achieve educational...

  • Enterprise SOA Solutions Architect

    19 hours ago

    Bareilly, Uttar Pradesh, India Smart Data Full time

    Job Description:Solution-oriented SOA Architect to drive the design, development, and implementation of cutting-edge enterprise solutions. • Collaborate with cross-functional teams to analyze business requirements and craft technical solutions that meet scalability, reliability, and performance standards.• Develop and maintain complex SOA/BPEL services...

  • Principal Software Engineer

    2 months ago

    bareilly, India HERE Technologies Full time

    About role: As a principal engineer of HERE IAM team, you’ll be responsible for leadership, development and testing of scalable, robust, high throughput and low latency driven Authentication & Authorization services. You will have an opportunity to have noticeable impact on the performance of a critical component of the platform Some detailed...

  • Enterprise Architect

    1 month ago

    Bareilly, India Tech Mahindra Full time

    Job Description: Enterprise Architect Should be from Tier-1 CompaniesDone solutioning, pursuit mgt & handling deals part of EADone certifications – TOGAF, AWS, Azure,Cloud etcWhat the role entails? As an Enterprise Architect you are responsible for providing architecture and design leadership for complex digital transformation programmes, handling complex...

  • Automation Architect

    3 months ago

    Bareilly, India Wipro Full time

    Role: Test Automation ArchitectCollaborating with stakeholders to understand current technologies, frameworks, tools & gather requirements, understand their specific test automation needs for different business areas.Have been experience in transforming Automation across enterprise.Strong Hands-on coding experience in C#, Java, Java ScriptsExpertise in...

  • Data Engineering Expert for Scalable Business Intelligence

    7 days ago

    Bareilly, Uttar Pradesh, India Hexaware Technologies Full time

    About the RoleWe are seeking an experienced Data Engineer to join our team at Hexaware Technologies. This is a challenging and rewarding opportunity to design, develop, and optimize data infrastructure that supports scalable business intelligence and analytics solutions.The successful candidate will have a solid foundation in Snowflake, proficiency in dbt...

  • Innova ESI | BI Developer( SSIS+ Azure) | bareilly

    3 weeks ago

    bareilly, India Innova ESI Full time

    Ability to write complex SQL scripts -Should have hands-on experience as SSIS developer - Demonstrated experience in design and delivering data platforms for Business Intelligence or Data Warehouse, including data ingestion, ETL and data integration. - Strong skills in handling and analyzing complex, high volume data with excellent attention in details -...

  • Chief Enterprise Solutions Designer

    2 weeks ago

    Bareilly, Uttar Pradesh, India Nineleaps Full time

    We are seeking a highly skilled Cloud Architect and Technical Lead to join our team at Nineleaps. As a key member of our engineering team, you will play a crucial role in designing and implementing scalable, resilient, and fault-tolerant cloud-based systems using AWS best practices.The ideal candidate will have extensive experience in software development,...

  • Focaloid Technologies | Technical Architect | bareilly

    3 weeks ago

    bareilly, India Focaloid Technologies Full time

    Around 10+ years of overall experience in developing and testing highly scalable software.Expertise in designing and implementing complex solutions which is scalable and maintainable in long run.Sound knowledge in Front end (Angular/React) and Back end (Python/PHP/Node/Java) technologies.Experience in deploying application considering the Resilience.Ability...

  • Junior & Senior Site Engineer

    3 weeks ago

    bareilly, India CHILLAL REALTY & INFRA PROJECTS Full time

    We seek an experienced and efficient Junior & Senior site engineer for our company CHILLAL REALTY AND INFRA PROJECTS in Coimbatore.As a site engineer, you will monitor diversified aspects of construction project management. This will include planning, coordination and supervision of on-site activities. You will ensure all aspects of the project align with...

  • Marketing Coordinator

    6 months ago

    Bareilly, Uttar Pradesh, India My Mentor Full time

    My Mentor is looking for a full time Marketing Manager who has a pleasing personality and great communication skills. **Roles and Responsibilities**: - Visiting schools and colleges on a regular basis. - This job also includes calling on student data. - Meeting principals/ heads of different schools/colleges and building a good relationship with them. -...

  • Lead Engineer

    1 week ago

    Bareilly, India BluOcean Cyber Full time

    SummaryBluOcean is a dynamic technology company focused on building innovative, large-scale SaaS products. We are seeking a Lead Engineer to play a critical role in designing, architecting, and developing innovative SaaS applications on Microsoft Power App Platform, ensuring they meet the highest standards for performance, scalability, and security.As a Lead...

  • iOS Lead Developer

    3 weeks ago

    Bareilly, India Streamline Full time

    iOS Lead Developer Who We AreAt Streamline, we are experts in Enterprise Mobility, Product Engineering and IT Transformation. We help organizations navigate the constantly evolving landscape of IT. Our sole focus is on ensuring that our client’s organization is armed with the strategies, products and solutions that are transformative to their business....

  • Senior Software Developer

    2 weeks ago

    Bareilly, India Ascentery Full time

    Job Title: Senior Software DeveloperLocation: Remote with client interactions in Manchester, United KingdomSalary: ₹24,00,000 per annumExperience Level: 4 yearsJob Type: Full-timeAbout Us:At Ascentery, we are a results-driven consulting firm dedicated to empowering businesses through transformative strategies, innovative solutions, and operational...