Senior Data Architect

Job Summary: We are looking for a highly skilled Data Architect to design, develop, and optimize enterprise data architecture solutions that enable scalable analytics and efficient data management. The ideal candidate will have extensive experience in data modeling, cloud-based data platforms, and migration strategies, with a strong focus on AWS Redshift and Cloudera (or similar Big Data technologies). This role involves performing gap analysis, developing robust data models, and ensuring data integrity across various systems. Key Responsibilities: Design and implement enterprise data architecture strategies supporting business intelligence, analytics, and application needs. Lead the migration of data platforms from Cloudera to AWS Redshift, ensuring performance, scalability, and reliability. Conduct gap analysis between existing data systems and target architecture to identify optimization opportunities. Build and optimize data models using tools such as Erwin, ensuring consistency, normalization, and reusability. Develop and implement data integration strategies between AWS Redshift and data sources such as Aurora PostgreSQL. Define and enforce data governance, quality, and security standards across the organization. Collaborate with cross-functional teams including data engineers, BI developers, and solution architects to support enterprise data needs. Evaluate emerging data technologies and recommend solutions aligned with organizational goals. Document data architecture designs, metadata, and technical standards for maintainability and transparency. Required Skills & Experience: 8+ years of experience in Data Architecture / Data Engineering (focused on design and architecture rather than ETL development). 5+ years of experience in data modeling using tools like Erwin (preferred) or similar. Strong hands-on experience with Amazon Redshift for data warehousing and analytics. Experience with Cloudera or other Big Data/Hadoop technologies such as Snowflake, BigQuery, Databricks, or Azure Synapse. Strong understanding of data warehousing concepts, data lake architecture, and data pipeline frameworks. Expertise in SQL and query optimization for large datasets. Solid understanding of data integration and governance frameworks. Strong analytical, problem-solving, and communication skills. Preferred Qualifications: AWS Certified Data Analytics – Specialty or AWS Solutions Architect certification. Experience with AWS Aurora PostgreSQL or similar RDBMS. Familiarity with ETL/ELT tools (Glue, Airflow, Informatica, etc.). Experience in metadata management and data cataloging tools. Job Type: Contract Pay: $65.00 - $70.00 per hour Work Location: In person