Technical Data Architect with Data Vault and Snowflake experience

Role:                    Technical Data Architect with Data Vault and Snowflake experience

Location:            Oaks, PA

Mode Of Hire:   Full Time

Skills Required

•            BA/BS in a related technical field; or the equivalent in education and work experience

•            A minimum of 10 years of experience in Information Technology

•            A minimum of 10 years of hands on experience in Data Warehousing, Data Engineering, and Data Architecture, with proven delivery of production grade enterprise data platforms

•            Experience with data warehousing tools and technologies.

•            Strong, hands on experience with Data Vault 2.0 in enterprise data warehouses, including practical implementation of Hubs, Links, and Satellites

•            Strong knowledge of Raw Vault, Business Vault, and Information/Data Mart design

•            Solid grounding in dimensional modelling (Kimball) including Star and Snowflake schemas, fact and dimension table design along with slowly changing dimensions and hybrid DW architectures.

•            Hands on experience designing scalable, auditable, and historized data models that support enterprise reporting and analytics needs

•            Ability to hit the ground running with minimal ramp up on DW concepts

•            Experience building and managing data pipelines using Snowflake, Airflow, DBT, and Python, following modern ELT patterns

•            Expertise in performance tuning and optimization of data warehouse workloads, pipelines, and transformations

•            Experience in working with Bit Bucket, Azure DevOps, GitLab, Jira, and Confluence.

•            Proficiency in analysis, design, and build of SQL and PL/SQL packages.

•            Ability to develop and implement strategies for data archiving, purging, and lifecycle management to maintain optimal performance in data warehousing environments.

•            Fair experience with Azure Cloud architecture, deployment, and optimization.

•            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 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

•            Experience in wealth management, investment processing, domestic and international Equity and / or Fixed Income workflows and analytics

•            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

•            Data Vault 2.0 certification (e.g., Certified Data Vault 2.0 Practitioner – CDVP2 or Data Vault Alliance certification)

•            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