ComTec Information Systems (IT) · 20 hours ago
Senior AWS Data Architect
Houston, TX
Full-time
Hybrid
Senior Level
5+ years expComTec Information Systems is seeking a highly skilled Data Architect to design and implement scalable, high-performance data solutions that integrate data from SAP and Salesforce into AWS Redshift. This role will serve as the bridge between business requirements and technical implementation, translating strategic data needs into detailed design documents and data models.
Information TechnologySoftware
Responsibilities
Collaborate with business stakeholders and data teams to analyze and translate business requirements into scalable, maintainable data architecture designs
Design and document data ingestion pipelines from SAP /Salesforce/other source into AWS Redshift, ensuring performance, reliability, and data integrity
Design, build, and optimize ETLs using Python, PySpark, lambda, Airflow and other AWS services
Develop conceptual, logical, and physical data models, applying best practices in dimensional modeling (Star and Snowflake schemas)
Architect and oversee data integration and transformation workflows using AWS Glue, Step Functions, and related AWS services
Build automations to ingest, transfer, move, upload, and manipulate data
Implement and optimize data storage, partitioning, and indexing strategies in Redshift to support analytical workloads
Collaborate with engineering teams to implement data governance, cataloging, and lineage tracking using AWS DataZone
Define and enforce data architecture standards, ensuring alignment with enterprise data strategy and security best practices
Troubleshoot performance issues and identify opportunities for optimization within data pipelines and warehouse structures
Qualification
Required
5+ years of experience in data architecture or data engineering roles, with strong exposure to cloud-based data warehousing
Proven expertise in dimensional modeling (Star and Snowflake schemas)
Understanding of data modelling principles and techniques
Knowledge of data security best practices and compliance requirements
Experience with data lake architectures and integration with Redshift (e.g., S3, Lake Formation)
Must have experience with Airflow and Snowflake
Strong hands-on experience with AWS Redshift, AWS Glue, and AWS Step Functions
Experience designing data ingestion and ETL frameworks
Familiarity with AWS DataZone or equivalent tools for data lineage, governance, and cataloging
Strong SQL skills and understanding of data quality, metadata management, and performance tuning
Excellent communication skills to work with both technical and non-technical stakeholders
Experience/knowledge of SAP and Salesforce data sources is a plus
Preferred
AWS Certified Solutions Architect – Professional (or Associate)
AWS Certified Data Engineer – Associate
Company
ComTec Information Systems (IT)
ComTec Information Systems is an information technology company specializing in JAVA, Oracle Fusion, and software application solutions.
501-1000 employees
Funding
Current Stage
Late StageCompany data provided by crunchbase