Data Architect

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

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

$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.