Job Closed
This listing is no longer active.
Using CaaS (Codeless-as-a-Service) to accelerate time-to-market & eliminate legacy code for the enterprise 🚀
Principal Data Architect
Location
United States
Posted
70 days ago
Salary
$215.1K - $286.2K / year
Seniority
Lead
Job Description
Principal Data Architect
Unqork
• Report to our Engineering Manager • Define and own the long-term data architecture strategy for Unqork's core platform, covering data modeling, query design, storage topology, and access patterns across a complex data environment that includes MongoDB as well as integration with Relational and Columnar database models • Ensure the data layer meets the security, performance, scalability, and resilience requirements of enterprise-grade, mission-critical applications. • Evaluate and recommend the right database technologies, indexing strategies, caching layers, ETL and search infrastructure for each class of workload — including when to use MongoDB Atlas Search, Caching (e.g., Redis), Querying (e.g., Kafka) and Streaming components • Own the end-to-end solutions around data transfers using solutions like ETL for customers. • Own the data architecture for Unqork's AI-driven development layer — defining persistence, versioning, and query standards for AI-generated configurations. • Lead the design of declarative data models and schemas that enable non-technical users to build complex logic while maintaining strict data integrity. • Define the architectural boundary between database-layer computation (aggregation pipelines, indexing) and application-layer computation (Node.js post-processing, in-memory caching), and establish standards for which work belongs where. • Create and maintain comprehensive documentation including data architecture blueprints, indexing governance policies, query standards, and migration playbooks. • Own capacity planning and cost modeling for data infrastructure resources as Unqork scales. • Mentor and grow a team of data engineers and database engineers responsible for the health and performance of Unqork's data platform. • Establish data modeling best practices and enforce standardization across all environments — including schema conventions, index lifecycle management, and pagination contract design. • Oversee the design and operation of Unqork's database infrastructure — defining thresholds, coverage policies, write amplification limits, and manual override processes. • Drive data operational excellence by implementing and refining query performance monitoring, slow query alerting, explain plan review processes, and incident response playbooks for database degradation events. • Define and enforce data access governance — including RBAC data model standards, cache TTL policies, and the rules under which eventual consistency is acceptable vs. when strong consistency is required. • Comply with security regulations while working on data designs and patterns for Unqork platform. • Partner with Product to translate product requirements into data model decisions, and identify where relaxing a product constraint unlocks a disproportionate architectural improvement.
Job Requirements
- 10+ years of progressive experience in data architecture, database engineering, or a related field, with at least 3 years in a principal or architect-level role.
- Extensive experience designing and managing enterprise-grade, multi-tenant data infrastructure for SaaS platforms.
- Expert-level proficiency with MongoDB — including aggregation pipeline design, index strategy (B-tree, text, vector), replica sets, sharding, and query execution plan analysis (IXSCAN vs. COLLSCAN).
- Deep, hands-on expertise with our core data technology stack:
- MongoDB / MongoDB Atlas (aggregation pipelines, Atlas Search, Atlas Vector Search, sharding)
- Relational/SQL Databases (Operational and Business Intelligence schema and query partners)
- Redis (caching strategy, TTL design, cache invalidation, pub/sub)
- Node.js (application/database boundary, worker threads, event loop awareness)
- RBAC and access control data patterns (denormalization, write-time materialization, owner list caching)
- AI/ML data infrastructure (semantic search, LLM-friendly schema design, columnar database design)
- Proven ability to write architectural decision records that hold up over time — capturing not just the recommendation but the alternatives considered and the conditions under which the decision should be revisited.
- Proven ability to lead technical teams, manage complex data migration projects, and influence cross-functional stakeholders including Product and Engineering leadership.
- Strong understanding of data security principles, multi-tenant isolation patterns, and enterprise compliance requirements (SOC 2, ISO 27001).
Benefits
- 💻 Work from home with a remote-first community
- 🏝 Unlimited PTO (and the encouragement to use it)
- 📝 Student loan payback program
- 🏥 100% employer-covered medical, dental, and vision options available to you and your dependents
- 💸 Flexible Spending Account (FSA)
- 🏠 Monthly stipend toward your WFH setup, vacation, development and more
- 💰 Employer-sponsored 401(k) with contribution match
- 🏋🏻♀️ Subsidized ClassPass Membership
- 🍼 Generous Paid Parental Leave
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
• Lead a team that owns the AI self-service portal and the related set of microservices. • Work with a cross-functional team of engineers to contribute to our data platform. • Build and support a distributed platform supporting all ExParte data. • Work across our product, primarily on the data pipelines. • Interface directly with internal teams. • Evaluate software and implementation options and document them for technical teams. • Work with data analysts to collect insight on possible data collection efficiencies and identify automation potential for manual workflows. • Integrate best qualitative practices in program design and development. • Be a part of a distributed team (we’re in North America and Europe). • Work with Azure cloud and Databricks. • Develop technical architectures and specific implementations to meet business needs. • Guide the team’s software engineering best practices by documenting standards and completing code reviews. • Troubleshoot new and existing code and provide feedback and solutions to structural issues in the codebase as they arise. • Advise on the feasibility of nonfunctional requirements and ensure the successful implementation of features while meeting those requirements.
• Work directly with product owners and data experts to build products that solve complex client problems • Build and support a distributed platform supporting all ExParte data • Work across our product, primarily on the data pipelines • Interface directly with internal teams • Evaluate software and implementation options and document them for technical teams • Work with data analysts to collect insight on possible data collection efficiencies and identify automation potential for manual workflows • Integrate best qualitative practices in program design and development. • Be a part of a distributed team (we’re in North America and Europe) • Work with Azure cloud and Databricks • Develop technical architectures and specific implementations to meet business needs.
• Work directly with product owners and data experts to build products that solve complex client problems • Build and support a distributed platform supporting all ExParte data • Work across our product, primarily on the data pipelines • Interface directly with internal teams • Evaluate software and implementation options and document them for technical teams • Work with data analysts to collect insight on possible data collection efficiencies and identify automation potential for manual workflows • Integrate best qualitative practices in program design and development • Be a part of a distributed team (we’re in North America and Europe) • Work with Azure cloud and Databricks • Develop technical architectures and specific implementations to meet business needs • Guide the team’s software engineering best practices by documenting standards and completing code reviews • Troubleshoot new and existing code and provide feedback and solutions to structural issues in the codebase as they arise • Advise on the feasibility of nonfunctional requirements and ensure the successful implementation of features while meeting those requirements
ETL Developer
ZensarAt Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus. Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.
Development / ETL Developer The ETL Developer will play a critical role in designing, building, and maintaining integration process flows for the Digital Integration Hub (DIH), centralized integration platform for Trading and Asset Services. This role is focused on ETL development, data transformation, API integrations, and secure, scalable workflow design using industry leading tool, Adeptia. You will work closely with Product Owners, Business Analysts, QA, DevOps, and the Scrum Master to deliver highquality, secure, and reliable integration solutions that support DIH’s strategic roadmap. Position Responsibilities: - Design, develop, test, and maintain DIH integration connectors using ETL tool Adeptia. - Build and optimize ETL workflows that extract, transform, validate, and load data across internal and external systems. - Implement API integrations (REST/SOAP) using modern authentication methods (OAuth, JWT, API keys). - Map source and destination fields, define transformation logic, and ensure data accuracy and consistency. - Write clean, maintainable, and secure integration logic following development standards. - Create process flows, sequence diagrams, and technical documentation to support development and maintenance. - Assist engineering teams with design changes and architectural improvements. - Collaborate with QA engineers to define acceptance criteria, test strategies, and quality gates. - Support automated testing and CI/CD pipeline improvements. - Troubleshoot defects, identify root causes, and implement corrective actions. - Ensure all integration workflows follow secure coding practices and security standards. - Support security reviews, audits, and remediation activities throughout the development lifecycle. - Collaborate with DevOps on deployments, environment configuration, and pipeline automation. - Provide technical input for release notes, documentation, and training materials. Position Requirements: - Bachelor’s degree in software engineering, computer science or other related discipline or the equivalent combination of education, training, or work experience - Experience designing complex multi‑step ETL pipelines with branching logic, conditional flows, and error handling using tools such as Adeptia, Azure Data Factory, Informatica, or similar platforms (Adeptia preferred) - Strong SQL skills and familiarity with JavaScript, or equivalent programming language - Familiarity with secure coding practices, especially around data movement and API consumption - Knowledge of CI/CD pipelines, automated testing, and DevOps practices - Understanding of data modeling concepts, including schemas, transformations, and data lineage - Ideal candidate has previous experience in the FinTech industry with exposure to financial markets, private equity, or investment accounting - Knowledge of end-to-end software development life cycles, e.g., Agile, SAFeAgile - Strong interpersonal communication skills - Excellent written, verbal communication and presentation skills - Ability to collaborate with globally distributed teams. - Strong analytical, problem-solving, and time management skills About Digital Integration Hub Digital Integration Hub (DIH) team is structured horizontally across Trading & Asset Services business and aims to build and rebuild digital connectors between internal products as well as third-party partners. DIH seeks to integrate products and solutions using modern integration standards and best practices. DIH works with business/solution leaders responsible for key ecosystems to meet integration requirements aimed at linking products and solutions to provide a more automated, unified experience for our clients. DIH is a centralized home for strategic integrations, established to build, enhance, maintain, and support strategic integrations.
