Data Architect

PROTAGONA LLC
United States
3 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
2 years minimum
Compensation
$135,000.0 - $145,000.0
Working hours
Regular working hours
Job source

Tech stack

Application Programming Interfaces (APIs) Airflow Amazon Web Services Cloud Engineering Computer Programming Data Architecture Data Migration Data Systems Python (Programming Language) PostgreSQL Machine Learning MySQL
+14 more
Migration Manager SQL Stored Procedures SQL Databases Sql Optimization Apache Spark Generative AI Infrastructure as Code (IaC) Cloudformation Pandas Amazon Relational Database Service Information Technology Integration Frameworks Terraform Data Pipelines

Job description

As a Data Architect, your primary role will be to lead the technical direction for an engagement as you align with the client’s goals and business objectives. You will play a critical role in architecting all aspects of the solution, including security, performance, availability, maintainability, and cost. All the while keeping the customer’s business objectives top of mind.

Candidates should have a solid understanding of data architecture best practices and the ability to communicate the proposed strategy to a client effectively. The architect will be involved in all phases of a client engagement, from discovery through implementation. They will serve as the primary technical mentor to the delivery team throughout the engagement. A Data Architect can translate business objectives into an actionable backlog of deliverables with clear alignment with project stakeholders. As the backlog is executed, they will be responsible for the overall quality of work being delivered and making sure design considerations are being followed.

Responsibilities

  • Facilitate, guide, and influence the client and teams towards an effective architectural pattern and becoming an interface between business leadership, technology leadership and the delivery teams.
  • Designing of solution architecture on AWS
  • Implementation of workloads at various levels of maturity, including Proof of Concept (POC), Minimal Viable Product (MVP) and Production-grade.
  • Designing data systems that generally consist of the following elements:
  • Data Pipelines
  • Process Orchestration
  • Users and Security
  • Migration of workloads
  • Implementation and training of GenAI models in AWS, including knowledge of RAG
  • Perform migration activities including:
  • Translation of DDL, Stored Procedures, and Queries into RedShift and Amazon RDS supported (Postgres and MySQL) syntax
  • Executing data migration analysis using standardized AWS tools
  • Planning for, and executing migration strategy in-line with Client expectations
  • Setup and configuration of relative AWS components through Infrastructure as Code (IaC) (CloudFormation, Terraform, etc)
  • Engage with customer teams as an AWS expert to provide:
  • Education Workshops
  • Architectural Recommendations
  • Technology reviews and recommendations

Requirements

Do you have experience in Schema design?, * 5 years of overall database management and IT experience

  • Cloud Architecture experience
  • Experience in designing data models leveraging AWS services such as RedShift, RDS, DocumentDB, and more
  • Experience in designing and building infrastructure in-line with AWS’ Well Architected Framework
  • Advanced programming skills, preferably in Python, including the ability to:
  • Utilize data processing frameworks like Spark, Beam, or Pandas
  • Utilize orchestration frameworks like Airflow or Step Functions
  • Create and implement API workflows

Nice to Haves

  • 2+ years of AWS experience
  • Advanced SQL skills, including the ability to:
  • Write, tune, and interpret SQL queries
  • Experience in utilizing SQL Frameworks like dbt
  • AWS Certification - Solutions Architect Pro or Data Specialty
  • Machine Learning experience
  • Advanced GenAI experience

Benefits & conditions

$135,000 - $145,000 a year - Full-time, Pulled from the full job description

  • Health insurance
  • Paid time off
  • Vision insurance
  • Dental insurance, The expected base salary range for this position is $135,000 - $145,000 USD annually, plus eligibility for an annual performance bonus.

Actual compensation will depend on experience, skill set, and location., We offer a comprehensive benefits package that includes medical, dental, and vision coverage, and paid time off.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:15 min

Empowering domain teams with an open data platform

Sandhya Menon Sandhya Menon · World Congress 2026 Europe

2:57 min

Core technical practices for robust data engineering

Sandhya Menon Sandhya Menon · World Congress 2026 Europe

2:03 min

Accelerating pandas dataframes using cudf module plugins

Ankit Patel Ankit Patel · World Congress 2024

2:18 min

Scaling MySQL databases for massive user growth

Johannes Nicolai Johannes Nicolai +1 · LIVE

3:05 min

Audience questions on AI agents and pipeline vectorization

Joy Joy · World Congress 2024

6:58 min

Analyzing production code coverage data using pandas

Markus Harrer Markus Harrer · World Congress 2021

Videos

See all

Related articles

See all