Opportunity Data Engineering work from LinkedIn, X, Reddit and Upwork, in one list. Find me work
dataroles

Solution Architect, Data Engineering (US)

Code and Theory Open
New York Mid-level Data Engineering

At a glance

Mid-level Data Engineering role at Code and Theory. New York · $160,000–$210,000 base.

SalaryStated by Code and Theory
$160,000 – $210,000
Base salary for this role, in USD per year, as published in the posting.
This role, from Code and TheoryOur estimate for the market: $130,375–$190,000Median $151,250
Above the market median of $151,250 for mid-level data engineering roles in New York.
Worked out from 32 postings that stated pay, median $151,250. Last updated Nov 3, 2026.
RoleData Engineering
SeniorityMid-level
LocationNew York
Base pay$160,000–$210,000
PostedNov 3, 2026
Role brief

dataroles summary, based on the employer's posting.

What you'll do

  • Shape data-platform architecture for client projects, covering pipelines, AI-enabled workflows and integration patterns
  • Create system diagrams, integration maps and architecture records, then explain decisions to technical and executive audiences
  • Run discovery sessions with client engineering, data and IT teams to turn requirements into system designs
  • Guide implementation, resolve architectural risks and set engineering practices while coaching engineers on design choices
  • Scope technical solutions for proposals and client presentations, including current-state reviews and future roadmaps

What you bring

  • At least seven years in software or data engineering, including two or more years focused on architecture or solution design
  • Deep knowledge of cloud data platforms, plus Python and SQL skills for processing data and building ETL
  • Experience connecting AI or machine-learning capabilities to data pipelines, with exposure to generative AI applications
  • A record of designing scalable distributed systems and API ecosystems, and explaining architecture to client technical teams

Who this fits

This role suits a hands-on architect who can advise clients, lead engineering implementation and build agreement among technical and business stakeholders. The listing places the job in New York and describes it at Associate Director level, while noting openness to hiring at a level suited to the candidate’s experience.

From the employer

As a Solution Architect at the Associate Director level, you’ll bridge technical depth and client strategy, translating complex requirements into elegant architecture decisions and guiding engineering teams through implementation. You’ll define the technical vision for large-scale data platforms, designing the systems, standards, and integration patterns that power data-driven insights and predictive and generative models for enterprise clients.

WHAT YOU'LL DO

  • Lead solution design and architecture decisions for mid-to-large scale client engagements, with a focus on data platforms, pipelines, and AI-enabled workflows
  • Produce and present architecture artifacts: system diagrams, integration maps, ADRs, and technical standards
  • Guide engineering teams through architecture implementation with hands-on involvement during critical phases
  • Facilitate technical discovery workshops and requirements sessions with client engineering, data, and IT stakeholders
  • Evaluate and recommend cloud data platforms, frameworks, and third-party integrations based on client requirements and constraints
  • Identify and mitigate architectural risk across the project portfolio
  • Contribute to pre-sales technical scoping, RFP responses, and solution presentations
  • Lead enterprise architecture discovery including current-state assessment, gap analysis, and future-state roadmapping
  • Define platform architecture patterns for data pipelines, composable stacks, and API-first ecosystems, including the integration of AI/ML capabilities into data flows
  • Architect data foundations that connect marketing data ecosystems (GA4, advertising platforms, CRMs, CDPs) to analytics and ML workloads
  • Partner with client and internal teams, including Machine Learning Engineering, to align architecture to enterprise security, privacy, compliance, and governance requirements
  • Establish engineering standards, documentation, and best practices, and mentor engineers on architectural decision-making
  • Represent technical strategy in client executive briefings and RFP/SOW processes

WHAT YOU'LL NEED

  • 7+ years of software or data engineering experience with 2+ years focused on architecture or solutions design
  • Strong breadth across the modern technology stack: cloud, APIs, data, and platform ecosystems
  • Experience with data governance, privacy compliance, and security best practices
  • Experience integrating AI/ML capabilities into data pipelines, with exposure to GenAI applications
  • Demonstrated ability to design scalable, maintainable systems and communicate them clearly
  • Experience working directly with client technical teams and translating business requirements into system design
  • Ability to operate as a trusted technical advisor to both client and internal stakeholders
  • Deep expertise in cloud data platforms (e.g., Snowflake, Databricks, BigQuery, Redshift), with clear, well-reasoned opinions on trade-offs
  • Proficiency in Python and SQL for data processing and ETL
  • Experience designing distributed systems and API ecosystems at enterprise scale
  • Hands-on experience with AI-powered coding, agentic engineering, and AI-enabled workflows
  • Experience producing and presenting architecture artifacts to both technical and executive audiences
  • Ability to navigate complex stakeholder environments and drive technical consensus across an organization that is 50/50 tech and creative

NICE TO HAVE

  • Experience across multiple domain verticals (commerce, content, data, infrastructure)
  • Formal architecture training or certifications (AWS, Azure, GCP, TOGAF)
  • Background in pre-sales technical consulting or solutions engineering
  • Familiarity with marketing data ecosystems and customer data platforms
  • Background in digital transformation or platform migration programs

ABOUT US

Born in 2001, Code and Theory is a digital-first creative agency that sits at the center of creativity and technology. We pride ourselves on not only solving consumer and business problems, but also helping to establish new capabilities for our clients. With a global client roster of Fortune 100s and start-ups alike, we crave the hardest problems to solve. We have teams distributed across North America, South America, Europe, and Asia. The Code and Theory global network of agencies is growing and includes Kettle, Instrument, Left Field Labs, Create Group, Current, and TrueLogic.

Striving never to be pigeonholed, we work across every major category: from tech to CPG, financial services to travel & hospitality, government and education to media and publishing. We value the collaboration with our client partners, including but not limited to Adidas, Amazon, Con Edison, Diageo, EY, J.P. Morgan Chase, Lenovo, Marriott, Mars, Microsoft, Thomson Reuters, and TikTok.

The Code and Theory network is comprised of nearly 2,000 people with 50% engineers and 50% creative talent. We’re always on the lookout for smart, driven, and forward-thinking people to join our team.

The compensation range for this role is $160,000 - $210,000 and spans multiple levels. We're open to hiring at the level that best matches the right candidate's experience. Actual compensation is influenced by a wide array of factors including but not limited to skill set, level of experience, budget, and location.

Opportunity

Data Engineering work from LinkedIn, X, Reddit and Upwork, in one list.

Each morning you get everything that fits, strongest first.

Data Engineering$160k+

Find me work

By the team behind dataroles.

Find me work
Opportunity

Data Engineering work from LinkedIn, X, Reddit and Upwork, in one list.

Each morning you get everything that fits, strongest first.

Find me work

By the team behind dataroles.