Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Architect / Data Modeler with Amazon Exp

Anveta

Data Architect/Data Modeler Local Only 5 days a week onsite in NYC, NY eventually 5 days in the fall **Position Summary** The ideal candidate will reverse engineer, optimize, and modernize complex database environments. Responsibilities include analyzing undocumented database instances, inferring business logic from schema structures and production-representative data, reconstructing ER models, and redesigning architectures for maximum query efficiency, scalability, and maintainability. The candidate must also read and understand Java services that interact with and maintain the database schema, including ORM mappings and transactional behavior. **Key Responsibilities**

  • Reverse engineer database schemas, including tables, indexes, constraints, views, stored procedures, functions, and triggers.
  • Analyze representative production data to identify entities, relationships, cardinality, workflows, and usage patterns.
  • Reconstruct logical and physical ER models and document current-state architectures.
  • Read and analyze Java application/services code to understand database access patterns, ORM mappings, transaction logic, and schema maintenance behavior.
  • Redesign schemas and data models for efficient joins, query optimization, scalability, data integrity, and maintainability.
  • Optimize SQL, execution plans, indexing, partitioning, and storage strategies.
  • Administer enterprise databases including backup/recovery, replication, HA/DR, security, monitoring, upgrades, and migrations.
  • Produce technical documentation, ERDs, migration plans, and architecture recommendations.
  • Collaborate with engineering and infrastructure teams on database and application performance improvements.
**Required Qualifications**
  • 5+ years of experience in database administration, data architecture, or related roles.
  • Strong expertise in relational database design, SQL optimization, and performance tuning.
  • Proven experience reverse engineering undocumented databases and legacy systems.
  • Deep understanding of ER modeling, normalization, indexing, and join optimization.
  • Ability to infer business logic from schemas, data, and application behavior.
  • Read-level Java proficiency with the ability to understand Spring/Spring Boot, Hibernate/JPA, JDBC, and service-layer database interactions.
  • Experience with SQL Server, AWS RDS (Managed MS SQL Server), or similar DBMS platforms.
  • Familiarity with schema versioning, CI/CD, cloud database platforms, and monitoring tools preferred.
  • Strong analytical, investigative, and documentation skills.
**Desired Attributes**
  • Comfortable working independently with minimal documentation.
  • Detail-oriented with a focus on performance and scalability.
  • Effective communicator capable of translating technical findings into actionable architecture improvements. Anveta

Vacancy posted 1 day ago
Similar jobs that could be interesting for youBased on the Data Architect / Data Modeler with Amazon Exp in New York, NY vacancy
  •  ...Enabled Services.Job DescriptionThe Data Lake engineer should come from the background of a Big Data Architect. The position will be in...  ...knowledge of Hive is required with understanding of partitioning/reducer...  ...a plus.They should of 1 year exp. in these technologies... 
    Suggested
    Permanent employment
    Full time
    H1b
    Flexible hours

    Sonsoft

    New York, NY
    3 days ago
  • $132.23k - $176.31k

     ...powered world, connecting people, data, and applications through our...  ...Lead Marketing Data Platform Architect is responsible for defining,...  ...role requires close partnership with engineering, analytics, Adobe,...  ...platform standards for data modeling, ingestion, orchestration, observability... 
    Suggested
    Full time
    Temporary work

    Lumen

    New York, NY
    1 day ago
  •  ...Job Title- Data Architect Job Type- Full Time Location- New York City Mandatory Skills Data Architecture & Data...  ...experience designing scalable data architectures, data models, hands on experience with ingestion frameworks and ETL/ELT pipelines for structured... 
    Suggested
    Full time

    Maveric Systems Limited

    New York, NY
    1 day ago
  • $165k

     ...Tech works in close partnership with the broader industry,...  ...build, and scale high-performance data pipelines from disparate datasources...  ...pipelines. Key Focus: Architect an AI-ready greenfield platform...  ...frameworks (e.g., feature stores, model training data pipelines) to... 
    Suggested
    Full time

    FIA Tech

    New York, NY
    3 days ago
  • ~ Assessing the existing systems, data sources, and pipelines and developing a practical...  ...implementing, and maintaining scalable data models, data stores, and pipelines to ensure...  ...architectural documentation ~ Collaborating with stakeholders across business departments and... 
    Suggested

    Robert Half

    New York, NY
    4 days ago
  •  ..., leveraging our Disruptive Talent Solution. Role: Data Architect / Data Modeler Location: Midtown New York City, NY Work Mode...  ...Schema, and Data Vault modelingtechniques. Partner with business stakeholders, data engineers,and technical teams... 
    Contract work

    Alignity

    New York, NY
    2 days ago
  • $130k - $185k

     ...Lead Data Architect Fractal is a strategic AI partner to Fortune 500 companies with a vision to power every human decision in the enterprise. Fractal is building a world...  ...with experience in data architecture, data modeling, and modern data platforms to design... 
    Hourly pay
    Full time
    Local area

    Fractal

    New York, NY
    1 day ago
  • $175k - $205.9k

    Are you ready to make an impact?As a Data Architect at West Monroe, you will lead the design, implementation...  ...Leadership: Collaborate with senior leadership and stakeholders to define...  ..., including architecture diagrams, data models, and operational procedures.Incident... 
    Work at office
    Local area
    Immediate start
    Flexible hours

    West Monroe Partners

    New York, NY
    22 hours ago
  •  ...leadership role. Drive impactful projects with cutting-edge data and AI solutions. Collaborate directly...  ...industry leaders.Job DescriptionData Architect OverviewThe Data Architect will lead...  ...design and implementation of the data model for the client’s innovative operations... 

    Green Key Resources

    New York, NY
    1 day ago
  •  ...timePosted: 2026-09-02Title: Data ArchitectReports To: Director...  ...are seeking an experienced Data Architect to lead the design and implementation...  ..., collaborating closely with business stakeholders, product...  ...architecture, pipelines, and modeling strategies that power our enterprise... 
    Full time
    Part time
    Summer work
    Casual work
    Local area
    Immediate start

    American Eagle Outfitters

    New York, NY
    22 hours ago
  • $106k - $159k

     ...technology consulting company that leads with outcomes to bring more value, in all...  ...build better tomorrows for all.Job Title: Data Architect Who You'll Work WithOur Data Architecture...  ...Data management disciplines including data modeling, governance, metadata, quality, security... 
    Temporary work
    Work at office
    Local area

    Slalom

    New York, NY
    4 days ago
  • $130k - $145k

     ...Digital, Cloud & DevOps, Data, and Software...  ...Blockchain to Data Science models, Digital Underwriting,...  ...company has been honored with multiple employer awards...  ...experienced Enterprise Data Architect to define target-state...  ..., Glue Data Catalog, Amazon DataZone) when comparing... 
    Full time
    Contract work
    Temporary work
    Flexible hours

    Synechron

    New York, NY
    3 days ago
  •  ...understanding of NoSQL databases like HBase, Mongo, Cassandra etcRequirements Gathering, designing and developing scalable big data solutions with HadoopStrong technical skills on Spark, HBase, Hive, Sqoop, Oozie, Flume, Java, Scala, Pig, Python etcPractical experience of... 

    Sonsoft

    New York, NY
    22 hours ago
  • $145k - $217.4k

    OverviewMcGuireWoods LLP is seeking a Data Architect to join our IT team. The Data Architect is...  ...initiatives. The position works closely with the Database Platform Lead, business stakeholders...  ...and applies appropriate data modeling, transformation, integration, performance... 
    Remote work

    McGuireWoods

    New York, NY
    2 days ago
  • $168.5k - $206k

    General Information Job Title Principal Data Architect Job ID 108701 Work Areas...  ...inclusive work environment. We hire people with exceptional talent and create an...  ...organizational strategies and operating models for a modern Data Office, including governance... 
    Permanent employment
    Full time
    Work at office
    Local area

    Bain & Company

    New York, NY
    1 day ago
  •  ...Consultancy and Information Technology Enabled Services.Job DescriptionJob Description:-The candidate should be an expert on Data masking, especially with Informatica DM tool and should have experience in multiple DM implementations. Responsibilities include: Assessment of... 
    Full time
    H1b

    Sonsoft

    New York, NY
    22 hours ago
  • $126.5k - $149.6k

     ...the global financial services sector. With more than 5,000 clients and hundreds of...  ...comAbout the role:Comply is looking for a Data Platform Architect to define the architecture and...  ...products, APIs, event streams, semantic models, analytics capabilities, and AI-native... 
    Work at office
    Remote work
    Work visa
    3 days per week

    ComplySci

    New York, NY
    4 days ago
  • $175k - $205.9k

     ...make an impact?West Monroe is seeking a Data Architect, Google Cloud Platform (GCP) to design and...  ...high-performing data platforms on GCP, with BigQuery as a core analytics and data...  ...data ingestion, transformation, storage, modeling, governance, orchestration, and consumption... 
    Local area
    Immediate start
    Flexible hours

    West Monroe Partners

    New York, NY
    22 hours ago
  • Company Overview:With an annual budget of $2.3 billion and more than 7,000 employees throughout...  ...: The Center for Population Health Data Science (CPHDS)- launched in October of 2...  ...the Data Confidentiality and Privacy Architect will:In the context of the New York City... 
    Temporary work
    Work at office
    Local area
    Monday to Friday
    Flexible hours

    Public Health Solutions

    New York, NY
    4 days ago
  •  ...the right time.We are seeking a Data Architectto design the...  .... You will be responsible for architecting data environments that serve massive...  ...management of an enterprise data model that integrates complex...  ...monitor data quality and lineage with strict traceability back to source... 
    Full time
    Remote work

    Tempus

    New York, NY
    3 days ago
  •  ...be hybrid in New York** I am partnered with a global, data-driven organization to hire an experienced Data Architect to lead the design and delivery of scalable,...  ...Responsibilities Own and drive the data architecture models Design reusable architecture patterns such... 
    Full time

    Next Ventures

    New York, NY
    19 days ago
  • Hiring For Sr Enterprise Data Warehouse Developer Location: NYC (hybrid) W2-Only Exp:8+ Note: I Need local candidates within the NY Must-haves: Data Warehousing expert Sourcing data, transforming data, star schema, landing, dimensions, data governance, data quality, running... 
    Local area
    Immediate start

    Kaav Inc.

    New York, NY
    1 day ago
  •  ...delivers AccuWeather's data and services to more than...  ...are looking for a Data Architect I who combines strong...  ...platform design expertise with the judgment to assess...  ...modifying code, data models, schemas, and supporting...  ..., Samsung, LG, and Amazon Freevee. AccuWeather For... 
    Local area
    Remote work

    AccuWeather Careers

    New York, NY
    1 day ago
  • Role:- Senior Data Architect Location:- Manhattan, NY (Hybrid) Technical Skills & Requirements...  ...Advanced hands-on expertise in designing and modeling enterprise data architectures (cloud-...  ..., real-time). Deep experience with data management, advanced data modeling... 

    United IT Solutions

    New York, NY
    1 day ago
  • Senior Data Architect New York, New York, United States Job Description Experience level: Mid-senior...  ...query, Relational, Json, AVRO, Data Modeling, Erwin, Hadoop, HDFS, Hive, Query...  ...solutions teams data scientists, business users with NoSQL and Big Data platforms, hybrid... 
    Relocation package
    Flexible hours

    VS Tech Solutions

    New York, NY
    1 day ago
  • $185.4k - $344.4k

     ...Job Description Join Lockheed Martin's Data and AI Enablement organization and accelerate...  ...is for you. Key Responsibilities Work with functional partners to create enterprise...  ...Optimize the work experience of our team's architects and engineers, and enable them to grow... 
    Full time
    Temporary work
    Work experience placement
    Flexible hours

    Lockheed Martin Corporation

    New York, NY
    1 day ago
  • $110k - $155k

    Data Architect Are you looking for a highly rewarding opportunity that provides extensive career...  ...architectures while ensuring alignment with enterprise strategy, standards, and roadmaps...  ...and data architecture, including data modeling, governance, information management,... 
    For contractors
    Work at office
    Remote work

    Gilbane Building Company

    New York, NY
    1 day ago
  • $100k - $130k

    Data Architect New York, NY or Remote Overview Position Type Full Time Description Senior Data...  ...Engineer / Data Architect Bright Power works with forward thinking owners and developers...  ...with Data infrastructure, complex data modeling, AWS environments, ETL workflows, and... 
    Full time
    Local area
    Remote work

    Bright Power

    New York, NY
    1 day ago
  • $114.04k - $185.42k

     ...12/2/2026 3:00 PM Central MN Data Practices: The Metropolitan Airports...  ...is required to be shared with a representative union. Position...  ...Summary This is a hands-on architect role with real influence. You'...  ...data quality enablement, data modeling and integrations, data classification... 
    For contractors
    Remote work
    Monday to Friday
    Flexible hours
    2 days per week
    3 days per week

    Metropolitan Airports Commission

    New York, NY
    1 day ago
  • Data Architect We are seeking a highly skilled and forward-thinking Data Architect who combines strong strategic vision with hands-on technical expertise. This role will be responsible for defining...  ...Big Data ecosystems. Define data models (conceptual, logical, physical)... 

    United IT

    New York, NY
    1 day ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Architect / Data Modeler with Amazon Exp. Be the first to apply!