Architect

Architect

Duties:

Strategic Cloud Data Modeling & Architecture Design: Design and maintain enterprise-wide

conceptual, logical, and physical data models utilizing Snowflake schemas to map

complex financial asset portfolios and core retail banking metrics in modern cloud-native

environments. 2. High-Volume AWS & Cloud Data Migration Management: Lead structural

end-to-end data migrations from legacy, on-premises core frameworks (specifically IBM

DB2 architectures) over to modern distributed cloud targets like AWS databases and

Snowflake data lakes. 3. Cloud Infrastructure Data Decoupling & Isolation: Pioneer

business architecture separations by building permanent cloud-native solutions using

Python and AWS to decouple specialized line-of-business metrics between FIS and TRP

systems with zero data loss or downstream system impact. 4. Advanced AWS ETL & Cloud

Data Pipeline Engineering: Construct, tune, and orchestrate robust, automated Change

Data Capture (CDC) and data ingestion pipelines utilizing AWS Glue, AWS Step Functions,

AWS Event Bridge, Python, and SSIS. 5. Massive-Scale Query Tuning & Optimization:

Conduct intensive system performance sweeps, statement refactoring, and query

execution profiling on massive multi-terabyte cloud data stores within Snowflake and DB2

to maximize processing speeds and eliminate system latency.

Requirements:

Requires Bachelor’s degree or foreign academic equivalent in Electronic &

Communications Engineering, Electronics Engineering, Computer Engineering,

Management Information Systems, Information Science or related field. Requires 5 years of

experience in the job offered or as Senior Data Analyst/Architect, Technical Lead, Analyst &

Designer, Sr. Software Engineer, Software Engineer or related field. Requires experience in

Hive Data Lake, Oracle Database (12c), SSIS, BSA-AML.

Position requires relocation to unanticipated client sites throughout the U.S with multiple

openings.