Snowflake Data Architect

Job Opportunity: Snowflake Data Architect Location: Hybrid, 3 days hybrid in Oaks, PA Duration: Contract The focus will be around building out a new DW from scratch with Snowflake, PL SQL, SQL and Azure for cloud. Key Responsibility • Ensure quality for our customers by validating Performance, Stability, Scalability, and Reliability for all of our scrum initiatives • Ensure validations are in place for the proper level of instrumentation and monitoring to proactively detect performance and scalability • Design and Develop automated Performance, Stability, Scalability, and Reliability tests • Discover thresholds and data impact on delivery • Participate in the constant improvement of our Performance Test Automation practices • Architect and develop custom tools to facilitate and enhance Performance Testing, Testing at the System, Sub-System, and Component level • Gain a technical and functional understanding of our product architecture and become part of the ongoing improvement of the performance of our enterprise application • Work proactively with members of an Agile team to find and fix defects in our product architecture • Analyze defects / test results and be able to deduct the chain of events leading to a failure • Communicate critical issues and status updates in a timely manner to Agile teams • Mentor technical resources on performance best practices • Deep understanding of Application Performance Monitoring and ability to develop predictive and prescriptive solutions in the big data arena What we need from you: • BA/BS in a related technical field; or the equivalent in education and work experience • A minimum of 7 years of experience in Information Technology • A minimum of 7 years of Architecture experience in object-oriented design and programming methodologies; Java, JavaScript, SQL. • Fair experience with Azure Cloud architecture, deployment, and optimization. • Experience in data pipelines using Snowflake, Airflow, and DBT. • Experience in working with Bit Bucket, Azure DevOps, GitLab, Jira, and Confluence. • Proficiency in analysis, design, and build of SQL and PL/SQL packages. • Proficiency in source control solutions such as GIT/GitLab and the Git flow process • Ability to identify performance bottlenecks from issues – complement development team in speedy analysis/root cause of performance issues is preferred. • Ability to lead performance optimization efforts with a strong command of complex performance issues and the ability to direct component owners is a plus • Oracle Database performance tuning expertise • Data Analytics and Data Visualization services • Knowledge of Performance trouble shooting (heap dump & thread dump analysis) is preferred. • Experience effectively interacting with large development and delivery teams and application development managers who are providing full lifecycle application support in complex, heterogeneous environments • Strong understanding of SAFe • Displays Servant Leadership Skills • What we would like from you: • Experience in wealth management, investment processing, domestic and international Equity and / or Fixed Income workflows and analytics • Experience with any of the following: CPM, Portfolio Management, Auto Loss Harvesting, Tax Managed Investment, Settlement System, Order Processing, Custody Services, Reconciliation, Corporate Action, Currency Processing • Experience effectively interacting with large application development and delivery teams and application development managers who are providing full lifecycle application support in complex, heterogeneous environments • Experience working with senior leadership, ability to work comfortably with a wide range of people and skill sets • Knowledge of core investment processing / wealth management transaction processing, trade flow, custody & accounting, cash processing, etc. • Ability to work effectively in a team environment, with a singular commitment to the accomplishment of team results