> Markdown version of [/jobs/ext/2021070-data-architect](https://www.wearedevelopers.com/jobs/ext/2021070-data-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Architect - **Company:** J-ram It Consulting Inc. - **Location:** New York, NY, United States - **Experience:** Expert - **Contract:** Temporary contract - **Skills:** Agile Methodology, Artificial Intelligence, Amazon Web Services, Architectural Patterns, ARM Architecture, Microsoft Azure, Backup Devices, Big Data, Databases, Data Architecture, Information Engineering, Data Governance, Data Infrastructure, Data Systems, Software Design Patterns, Disaster Recovery, Distributed Data Store, Graph Database, Information Lifecycle Management, Python (Programming Language), PostgreSQL, Machine Learning, Performance Tuning, Systems Development Life Cycle, Query Optimization, Power BI, Ansible, Search Technologies, SQL Databases, Talend, Transaction Data, Unstructured Data, Cloud Platform System, System Availability, Snowflake, Apache Spark, Generative AI, HybridCloud, Microsoft Fabric, Information Technology, Data Analytics, Data Management, Machine Learning Operations, Virtual Agents, Serverless Computing, Databricks - **Published:** August 11, 2026 - **Apply:** https://www.dice.com/job-detail/44d3e7d9-8f1c-4afd-9908-2f58b8471817 ## About the Role * Minimum 10 years of recent experience in data architecture, data engineering, or a similar field. * Hands-on expertise with PostgreSQL and Snowflake administration and performance tuning. * Strong scripting and automation skills (Python, Ansible, etc.). * Familiar with Cloud Based Architectures /Data-Warehousing Platforms, prior experience / knowledge in Snowflake Design Patterns and migration workflow would be a plus. * Prior exposure building ML and generative AI solutions using Snowflake Cortex Analyst, Search, AI SQL, Snowflake ML, and Snowpark Container Services. * Proven record of architecting and delivering large-scale data warehouse modeling and reporting solutions for enterprise systems. * A bachelor's degree from an accredited college or university is required. A master''s degree in computer science, engineering, or a related technical discipline is preferred. * Expertise in architecting cloud-native data ecosystems using platforms such as Snowflake, Databricks, Talend, SPARK, Power BI, and Microsoft Fabric. * Deep knowledge of designing solutions that incorporate Retrieval-Augmented Generation (RAG) and vector search (e.g., Azure AI Search). * In-depth understanding of architectural patterns for processing and modeling both structured transactional data and unstructured information. * Experience with transactional processing and AI/ML applications. * Demonstrated experience defining architectural principles, data governance policies, and technology standards within a large-scale, regulated, and Agile Software Development Life Cycle (SDLC) environment. * Exceptional problem-solving, communication, collaboration and leadership skills. * Ability to articulate strategic technical vision, influence executive-level stakeholders, and guide solutions for complex business problems. ## Description * Design, implement, and manage large-scale distributed database systems using Snowflake and Postgres. * Lead the architecture and deployment of database clusters across hybrid cloud environments (AWS, Azure). * Develop and maintain automation frameworks for provisioning, monitoring, and scaling database infrastructure. * Collaborate with data engineering, platform, and application teams to ensure high availability, security, and performance. * Drive adoption of best practices for schema design, query optimization, and data lifecycle management. * Implement robust backup, disaster recovery, and compliance strategies. * Mentor junior engineers and contribute to cross-training initiatives across database technologies. * Govern how both structured and unstructured data is ingested, processed, and engineered for context. * Ensure high availability, disaster recovery, and performance tuning across multi-region deployments. * Collaborate with senior product, engineering, and audit leadership to influence business strategy and ensure solutions are built on a sound architectural foundation. * Architect and oversee the design and development of data and context engineering capabilities using Snowflake and PostgreSQL. * Make critical design decisions that enable seamless integration into Data Analytics, Business Intelligence Reporting, and AI agent workflow capabilities. * Establish and enforce data governance, quality standards, and validation frameworks. * Guarantee the integrity, security, and reliability of all data solutions. * Drive modernization initiatives including cloud-native database adoption, serverless architecture, and AI/ML integration. * Evaluate and implement emerging technologies to improve platform efficiency and developer experience. * Drive the future of audit technology by leading architectural innovation. * Champion the evaluation and adoption of next-generation data platforms, knowledge graphs, and advanced data fabrics. * Act with integrity, professionalism, and personal responsibility to uphold Morgan Stanley's respectful and courteous work environment. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Dev & Test in the Cloud? Deploy your cloud environments with Ansible & Terraform](https://www.wearedevelopers.com/videos/1607-dev-test-in-the-cloud-deploy-your-cloud-environments-with-ansible-terraform) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Eclipse Che for Infrastructure Automation](https://www.wearedevelopers.com/videos/1611-eclipse-che-for-infrastructure-automation) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)