Apply on Employer Site

Coforge · 11 hours ago

Technical Data Architect with Data Vault and Snowflake experience

Oaks, PA

Full-time

Onsite

Senior Level, Lead/Staff

10+ years exp

Coforge is seeking a Technical Data Architect with experience in Data Vault and Snowflake. The role involves designing and implementing enterprise data platforms, with a focus on data warehousing, data engineering, and data architecture.

Artificial Intelligence (AI)Software

H1B Sponsor Likely

Hiring Manager

Arpan Chandra

Responsibilities

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

Qualification

Data Vault 2.0SnowflakeData WarehousingDimensional ModellingSQLPL/SQLData EngineeringPerformance TuningAzure CloudData AnalyticsServant LeadershipTeam Collaboration

Required

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