Data Architect OLTP Data Modelling
Overview
You will own the canonical data model for a large-scale platform modernization, migrating a legacy monolith to a cloud-native, API-first, event-driven architecture. You will design OLTP schemas and data flows for Spec-Driven Development, where AI coding agents generate code under human review. You will work with cross-functional teams to ensure data integrity and performance across distributed systems. This role stands out because it combines deep data modeling with cutting-edge AI-assisted software delivery.
What You'll Do8
- 1Design OLTP data models for a cloud-native platform, ensuring scalability and transactional integrity.
- 2Define canonical data schemas for API-first and event-driven interactions.
- 3Collaborate with architects and developers to translate business requirements into logical and physical models.
- 4Optimize SQL queries and indexing strategies for high-throughput workflows.
- 5Drive data migration from legacy schemas to modern PostgreSQL or Amazon RDS.
- 6Implement data validation and governance rules using Spec-Driven Development principles.
- 7Review and refine data models with AI coding agents, ensuring alignment with specifications.
- 8Own the data dictionary and metadata repository to support team agility.
Requirements7
- 15+ years in data architecture with focus on OLTP systems.
- 2Expertise in ERWin, Lucidchart, or similar modeling tools.
- 3Strong SQL skills, including complex joins and performance tuning.
- 4Experience with PostgreSQL or Oracle, and cloud databases like Amazon RDS.
- 5Knowledge of event-driven architectures and Kafka or RabbitMQ.
- 6Familiarity with API design and JSON schemas.
- 7Bachelor's degree in Computer Science or related field.
Salary Insight
Salary not disclosed in listing
Similar open positions
Explore active roles that match your skills and interests.
Sabio infotech
VerifiedData Architect, Enterprise Data Solutions & Analytics
As a Data Architect, you will own the end-to-end architecture for data solutions from source systems through analytics and downstream consumption. You design and govern logical, physical, and semantic data models, including facts, dimensions, metrics, and hierarchies. You apply domain-driven and data-solutions design principles to ensure consistency and reusability. You establish and govern data contracts to maintain data quality and integrity. This role stands out for its hybrid flexibility across Pittsburgh, Dallas, and Cleveland.
EXTEU-AC-CareerSite
VerifiedPrincipal Data Architect, Data Engineering & AI
You will own the enterprise data architecture and strategy, enabling scalable AI/ML, telemetry analytics, and business intelligence across a global organization. You will lead the design of cloud-native data platforms on AWS and Azure, from ingestion to insights, and set the blueprint for data storage, integration, and governance. Collaborating with Data Science and AI teams, you will industrialize ML pipelines and drive data as a strategic asset. This role combines deep technical leadership with executive influence, shaping the future of data-driven decision making.
J-RAM IT Consulting Inc.
VerifiedData Architect, Snowflake & Postgres, NYC
Own distributed database platform deployments for the Assurance & Legal Technology department, driving data from source to gold for analytics. Architect Snowflake and Postgres schemas, tune performance, and lead data curation. Collaborate with engineering and analytics teams to enable advanced reporting. This role shines in a legal tech environment with a hybrid NYC schedule (3 days onsite).
Hierarch Soft Technologies, Inc.
VerifiedSnowflake Data Architect, Warehousing & Analytics
You will own the Snowflake and Postgres data platform for the Assurance & Legal Technology department, designing schemas and tuning performance to support enterprise analytics. You will work with a team of data engineers and analysts to source, sanitize, and curate data into a gold data layer. This role gives you direct influence over data architecture decisions and visibility with business stakeholders. You will build scalable data pipelines and models that power critical reporting and analytics.
Bain & Co.
VerifiedPrincipal Data Architect, Enterprise Data & AI
Shape enterprise data architecture for global clients. You will own the technical vision and roadmap for data platforms at scale, spanning cloud, hybrid, and multi-cloud environments. Collaborate with a multidisciplinary team of architects and consultants to modernize tech strategy, align systems with business goals, and integrate AI for end-to-end digital transformation. Your designs will influence C-Level executives and drive multi-million-dollar transformation programs. This role offers a unique blend of technical leadership, client advisory, and team mentorship in a top-ranked consulting firm.
Bain & Co.
VerifiedPrincipal Data Architect, Enterprise Data & AI
You will own enterprise data architecture for multi-year client transformations, shaping strategy and roadmaps across cloud, hybrid, and multi-cloud environments. You will join the Enterprise Technology team within Bain's digital capabilities practice, collaborating with experts to modernize tech strategy and systems. You will architect scalable data platforms, integrate AI, and advise senior leaders, driving efficiency and innovation. This role stands out for its impact on large-scale, multi-million-dollar programs and its focus on building sustainable Data Office capabilities.