Snowflake Data Architect

• Job Title - Snowflake Data architect with AWS
• Location - Hybrid @ Dallas, TX
• Design enterprise grade data architectures that apply AWS and Snowflake SQL to support high volume cards and payments processing while meeting scalability and security objectives
• Develop robust data integration patterns that orchestrate ingestion transformation and publishing workflows to deliver consistent and trusted datasets for downstream analytics and operational reporting
• Optimize complex Snowflake SQL workloads by refining query structures clustering strategies and data modeling patterns to achieve predictable performance for mission critical transaction analysis
• Coordinate with cards and payments product teams to translate authorization clearing settlement and dispute processes into precise data requirements and reusable data assets
• Implement resilient data pipelines in Azure Data Factory that handle streaming and batch feeds from card networks banks and fintech partners while ensuring reliable error handling and recovery
• Establish data quality validation and reconciliation rules that safeguard transaction accuracy limit disputes and support compliance initiatives across multiple regulatory jurisdictions
• Create logical and physical data models that align payment transaction reference and master data structures with industry standards and internal governance practices
• Collaborate with risk fraud and compliance stakeholders to design data flows that detect anomalous card activity and enable timely interventions for customer protection
• Define security and data access patterns that apply role based controls encryption and monitoring to safeguard sensitive cardholder information across all data platforms
• Guide development and operations teams in adopting best practices for version control continuous integration and automated testing of Azure Data Factory pipelines and Snowflake SQL assets
• Produce clear architecture documentation data flow diagrams and design guidelines that enable consistent implementation and maintenance by distributed engineering teams
• Support capacity planning and cost optimization activities by analyzing workload patterns and proposing configuration adjustments for Azure and Snowflake environments
• Coordinate with enterprise architects to align cards and payments data architecture with broader digital transformation roadmaps and shared platform capabilities
• Possess extensive hands on experience in AWS including pipeline orchestration mapping data flows monitoring and integration with other Azure services for data driven applications
• Demonstrate advanced proficiency in Snowflake SQL covering schema design performance tuning query optimization and secure data sharing within large scale financial environments
• Bring deep functional understanding of cards and payments including transaction lifecycles settlement processes interchange fees chargebacks and fraud prevention practices
• Exhibit strong skills in dimensional and normalized data modeling with a track record of delivering maintainable models for financial transaction analytics and regulatory reporting
• Show proven experience in designing highly available data platforms that support near real time analytics for card spends merchant performance and customer behavior insights
• Apply solid knowledge of data governance master data management and metadata practices to ensure consistency and traceability of card transaction data across domains
• Demonstrate practical exposure to Agile delivery models and hybrid work environments with strong communication capabilities for working across global cross functional teams
• The annual salary for this position is between $120-160K depending on experience and other qualifications of the successful candidate.
• Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:

None flagged.