Senior Data Architect

EPAM Systems; Chicago (IL); Remote; USD 170,000 - 210,000; Full time

Benefits offered by this job

Medical, Dental and Vision Insurance (

Health Savings Account

Flexible Spending Accounts (Healthcare

Job summary

EPAM Systems seeks a visionary Senior Data Architect to lead data modeling, integration patterns, and semantic datasets. You will bridge traditional data engineering with AI, partnering with AI Engineers to design agent-ready datasets and MCP data-access patterns.

You will collaborate with Data Engineers to ensure robust ingestion, quality, monitoring, and scalable analytics in Google Cloud BigQuery, focusing on multi-cloud cost and performance optimization.

Qualifications

• Strong background in data engineering, data architecture or analytics engineering.
• Deep expertise in conceptual, logical, physical, dimensional and canonical data modeling.
• Advanced SQL skills and BigQuery experience for large-scale analytics.
• GCP knowledge including BigQuery, Cloud Storage, IAM, Pub/Sub, and GKE.
• Experience producing source-to-target mappings and data contracts.
• Proficient in Python for data services and API integrations.
• Governance, data quality, reconciliation, and least-privilege access patterns.

Responsibilities

• Define target data architecture for cost, usage, revenue, and metadata datasets.
• Create source-to-target mappings, transformation rules, and data contracts.
• Establish canonical domain models and semantic datasets for AI-use cases.
• Design integration patterns for APIs, files, databases, and streams.
• Partner with AI engineers to design safe, agent-ready BigQuery datasets.
• Review queries and pipelines for performance, cost and scalability.
• Lead governance, ownership, retention, and data quality standards.

Skills

Data architecture

Data modeling

BigQuery

GCP

Python

APIs

Data integration

Governance

Security

Job description

We are looking for a visionary and hands‑on Senior Data Architect to lead our data modeling, integration patterns, and semantic dataset initiatives. In this role, you will be the bridge between traditional data engineering and cutting‑edge AI systems. You will work side‑by‑side with our AI Engineers to design agent‑ready datasets and Model Context Protocol (MCP) data‑access patterns, while partnering with Data Engineers to establish robust, scalable ingestion, transformation, quality, and monitoring standards.

If you are passionate about multi‑cloud cost, usage, resource, and financial datasets, and love architecting clean, scalable analytical engines in Google Cloud (GCP) / BigQuery, we want to hear from you.

Req# 1104608458

Responsibilities

• Data Architecture & Modeling: Define the target data architecture for multi‑cloud cost, usage, resource, contract, financial, metadata, and operational datasets. Design conceptual, logical, and physical data models optimized for BigQuery analytical workloads
• Documentation & Governance: Create source‑to‑target mappings, transformation rules, data contracts, lineage documentation, and business definitions. Define clear ownership boundaries across raw, standardized, curated, and analytics‑ready data layers
• Semantic & Domain Modeling: Establish canonical entities, domain models, semantic datasets, and reusable dimensions for traditional reporting as well as modern AI‑agent use cases
• Integration & Ingestion Design: Design integration patterns for APIs, files, databases, event streams, and semi‑structured enterprise data. Ensure data is properly mapped, normalized, and reconciled
• AI & Agent Readiness: Partner with AI Engineers to design safe, discoverable, read‑only BigQuery datasets and MCP tools for agent access. Define query and schema standards that enable reliable agent reasoning, structured responses, analytics, and recommendations
• Performance & Cost Optimization: Review SQL queries, data pipelines, schemas, and integration designs for quality, scalability, maintainability, performance, and cost efficiency. Define BigQuery best practices for partitioning, clustering, materialized views, and query optimization
• Data Governance & Leadership: Establish governance standards for lineage, ownership, access control, retention, data classification, quality, and freshness. Participate in architecture and code reviews, offering technical leadership across the data domain

Requirements

• Experience: Strong professional background in data engineering, data architecture, analytics engineering, or backend/data platform development
• Data Modeling: Deep expertise in conceptual, logical, physical, dimensional, canonical, and domain‑oriented data modeling
• Cloud Data Warehousing: Advanced SQL skills and hands‑on experience designing large‑scale analytical datasets, data marts, and multi‑source integration pipelines, specifically using Google Cloud BigQuery (or similar cloud data warehouses)
• GCP Ecosystem: Strong GCP knowledge, including BigQuery, Cloud Storage, IAM, service accounts, Pub/Sub, and GKE integration patterns
• Mapping & Specifications: Proven ability to produce source‑to‑target mappings, transformation specifications, data contracts, and lineage documentation
• Performance Tuning: Expertise in BigQuery partitioning, clustering, performance tuning, and cost‑efficient query design
• Programming & Integration: Hands‑on Python experience for data services, Proofs of Concept (POCs), transformations, or API integrations. Experience with REST APIs, event‑driven integration, batch processing, and semi‑structured data
• Governance & Security: Strong understanding of data governance, data quality, reconciliation, schema evolution, and least‑privilege access patterns
• Collaboration & Review: Experience conducting architecture reviews, mentoring engineers, and driving consensus across cross‑functional technical teams

We offer

• Medical, Dental and Vision Insurance (Subsidized)
• Health Savings Account
• Flexible Spending Accounts (Healthcare, Dependent Care, Commuter)
• Short‑Term and Long‑Term Disability (Company Provided)
• Life and AD&D Insurance (Company Provided)
• Employee Assistance Program
• Unlimited access to LinkedIn learning solutions
• Matched 401(k) Retirement Savings Plan
• Paid Time Off – the employee will be eligible to accrue 15-25 paid days, depending on specific level and tenure with EPAM (accrual eligibility may change over time)
• Paid Holidays - nine (9) total per year
• Legal Plan and Identity Theft Protection
• Accident Insurance
• Employee Discounts
• Pet Insurance
• Employee Stock Purchase Program
• If otherwise eligible, participation in the discretionary annual bonus program
• If otherwise eligible and hired into a qualifying level, participation in the discretionary Long‑Term Incentive (LTI) Program

This Remote Position Cannot be Performed in New York City.

This posting includes a good faith range of the salary EPAM would reasonably expect to pay the selected candidate. The range provided reflects base salary only. Individual compensation offers within the range are based on a variety of factors, including, but not limited to: geographic location, experience, credentials, education, training; the demand for the role; and overall business and labor market considerations. Most candidates are hired at a salary within the range disclosed. Salary range: $170,000 - $210,000. In addition, the details highlighted in this job posting above are a general description of all other expected benefits and compensation for the position.

In accordance with the LA County Fair Chance Ordinance, you may find a copy of the Notice containing a summary of the Ordinance’s key provisions here: Concept FCO Posting 8 27 24 (lacounty.gov)

EPAM Systems, Inc. is an equal opportunity employer. We recognize the value of diversity and inclusion in creating success for our customers, business partners, shareholders, employees and communities. We are committed to recruiting, hiring, developing and promoting employees without discrimination. As a global employer, this commitment includes complying with all laws in the countries in which we operate. Nevertheless, we believe equal employment practices should not be limited to what the law requires. Equal opportunity and inclusion are essential to motivate, empower and recognize the best in everyone.

At EPAM, employment actions are based on individual qualifications, without regard to race, color, religion, creed, gender, pregnancy status, sexual orientation, gender identity, gender expression, marital or familial status, national origin, ancestry, genetics, age, disability status, veteran status, citizenship status when otherwise legally able to work, or any other characteristic protected by law.