Hybrid || Data Architect with Data Vault experience | Oaks ,PA
Hybrid in Oaks, PA, US • Posted 2 hours ago • Updated 2 hours agoContract W2
Hybrid
$50 - $70/hr


Techridge, Inc.
Fitment
Dice Job Match Score™
🫥 Flibbertigibetting...
Job Details
Skills
- data vault
- data vault 2.0
- ETL
- DBT
- DW concept
Summary
HI
Role: Data Architect
Location : Oaks ,PA (Hybrid)
The Technical Data Architect is a leadership role. They are responsible for ensuring the use of common client architecture patterns and best practices and providing direction to the systems architects and scrum teams. The role involves leveraging cutting-edge cloud and data engineering technologies to drive high-quality and scalable solutions.
Location : Oaks ,PA (Hybrid)
The Technical Data Architect is a leadership role. They are responsible for ensuring the use of common client architecture patterns and best practices and providing direction to the systems architects and scrum teams. The role involves leveraging cutting-edge cloud and data engineering technologies to drive high-quality and scalable solutions.
What you will do:
- Design, build, and maintain enterprise data warehouse solutions using modern data warehousing methodologies, with a strong focus on Data Vault 2.0
- Implement Data Vault 2.0 models, including Hubs, Links, Satellites, and downstream Information Marts, ensuring auditability, historization, and scalability
- Develop and maintain Raw Vault and Business Vault layers, applying appropriate business rules and transformations where required
- Design and implement dimensional data models (Star and Snowflake schemas) for analytics, reporting, and downstream consumption
- Own the endtoend data modeling lifecycle, from source analysis through conceptual, logical, and physical models
- Ensure proper grain definition, conformed dimensions, and consistent business definitions across the data warehouse
- Partner with business and technical stakeholders to translate requirements into scalable and maintainable data models
- Architect, develop, and optimize ELT pipelines using Snowflake, Airflow, DBT, and Python, following modern cloud data warehousing best practices
- Implement metadatadriven and reusable pipeline patterns to support scalability and faster onboarding of new data sources
- Design and implement data quality checks, reconciliations, and validation frameworks to ensure accuracy, completeness, and consistency of warehouse data
- Monitor and optimize data warehouse performance, including query execution, data volumes, and pipeline runtimes
- Proactively identify and resolve data performance bottlenecks in ELT processes and analytical workloads
- Ensure data pipelines support incremental loads, historization, and change data capture (CDC) patterns where applicable
- Work closely with Agile teams to deliver productionready data solutions, from design through deployment
- Analyze data issues and defects, performing rootcause analysis across pipelines, models, and transformations
- Mentor engineers on data warehousing best practices, Data Vault modeling, and performance optimization techniques
- Ensure quality for our customers by validating Performance, Stability, Scalability, and Reliability for all of our scrum initiatives
- 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 10 years of experience in Information Technology
- A minimum of 10 years of handson experience in Data Warehousing, Data Engineering, and Data Architecture, with proven delivery of productiongrade enterprise data platforms
- Experience with data warehousing tools and technologies.
- Strong, handson 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.
- Handson experience designing scalable, auditable, and historized data models that support enterprise reporting and analytics needs
- Ability to hit the ground running with minimal rampup 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
What we would like from you:
- 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
Thanks and regards
Sonali Silswal
Email: Sonali.silswal
Contact : Phone: , Ext - 109
Address: 2591 Dallas Pkwy, Ste 300, Frisco, TX 75034
Website:
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: 10125172
- Position Id: 8893166
- Posted 2 hours ago
Company Info
About Techridge, Inc.
We believe we have the know-how to do it right the first time and we also understand that our client focus will always be on
-High Quality
-Cost Effectiveness
-Total Convenience
-Continuous Training
-Emphasis on Security
-Industry recognized SDLC
-Intelligent Communication
Technology and business knowledge go hand in hand in today s digital age, it very important to remember that technology will always remains a support mechanism for business. The greatest resource that makes any business successful is people, people who understand your business needs and technology. Techridge s hiring processes allows us to hire the right people based technical expertise on Attitude, Communication, Technical and Industry knowledge. Most of our employees have post graduate degrees.
At Techridge, we satisfy your need to keep up with lightning fast technology, manage constant system updates and control ongoing work by providing qualified IT professionals. People with the expertise to help you charge ahead of industry trends and the competition.
Careers
-High Quality
-Cost Effectiveness
-Total Convenience
-Continuous Training
-Emphasis on Security
-Industry recognized SDLC
-Intelligent Communication
Technology and business knowledge go hand in hand in today s digital age, it very important to remember that technology will always remains a support mechanism for business. The greatest resource that makes any business successful is people, people who understand your business needs and technology. Techridge s hiring processes allows us to hire the right people based technical expertise on Attitude, Communication, Technical and Industry knowledge. Most of our employees have post graduate degrees.
At Techridge, we satisfy your need to keep up with lightning fast technology, manage constant system updates and control ongoing work by providing qualified IT professionals. People with the expertise to help you charge ahead of industry trends and the competition.
Careers

Create job alert
Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs