AI Data Architect
New
I
InnovativeData & AI Engineering
This can be a remote opportunity, with 2 weeks of travel into Rochester, NY per quarterFull-TimeSenior
Salary150,000 - 200,000 USD per year
Apply NowOpens the employer's application page
Job Details
- Experience
- 5+ years professional IT experience, 2+ years professional AWS experience
- Required Skills
- AWSPythonSQLSnowflakeNosqlData modelingRedshiftDatabricksPySpark
Requirements
- 5+ years professional IT experience.
- 2+ years professional AWS experience.
- At least one AWS Professional-level certification (Solutions Architect Professional or Data Engineer Specialty preferred).
- Proficiency in Python for data pipelines (Glue, Lambda, SageMaker).
- Expertise in PySpark for Glue Spark jobs.
- Strong knowledge of SQL and NoSQL on AWS (Aurora PostgreSQL, RDS, DocumentDB, DynamoDB).
- Advanced data modeling skills (conceptual, logical, physical).
- Experience with dimensional modeling and medallion architecture.
- Experience with AWS Glue ETL, Data Catalog, and crawlers.
- Proficiency in S3 data lake architecture including partitioning and encryption.
Responsibilities
- Design and build S3 data lakes with multi-zone organization, partitioning strategies, and lifecycle policies.
- Implement medallion architecture (bronze/silver/gold) for data warehouses on Redshift, Snowflake, or Databricks.
- Build AWS Glue ETL pipelines (Python Shell and Spark) with incremental extraction and Data Catalog management.
- Design star/snowflake schemas and materialized views optimized for BI consumption tools.
- Architect RAG systems using Bedrock Knowledge Base and document AI pipelines using Textract and Comprehend.
- Lead data discovery sessions with client stakeholders and present architecture recommendations.
- Mentor delivery team members on data architecture patterns and AWS data services.
View Full Description & ApplyYou'll be redirected to the employer's site
