Data ArchitectLocation: Oaks, PA. 3 days onsite. ContractThe 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.0Implement Data Vault 2.0 models, including Hubs, Links, Satellites, and downstream Information Marts, ensuring auditability, historization, and scalabilityDevelop and maintain Raw Vault and Business Vault layers, applying appropriate business rules and transformations where requiredDesign and implement dimensional data models (Star and Snowflake schemas) for analytics, reporting, and downstream consumptionOwn the end-to-end data modeling lifecycle, from source analysis through conceptual, logical, and physical modelsEnsure proper grain definition, conformed dimensions, and consistent business definitions across the data warehousePartner with business and technical stakeholders to translate requirements into scalable and maintainable data modelsArchitect, develop, and optimize ELT pipelines using Snowflake, Airflow, DBT, and Python, following modern cloud data warehousing best practicesImplement metadata-driven and reusable pipeline patterns to support scalability and faster onboarding of new data sourcesDesign and implement data quality checks, reconciliations, and validation frameworks to ensure accuracy, completeness, and consistency of warehouse dataMonitor and optimize data warehouse performance, including query execution, data volumes, and pipeline runtimesProactively identify and resolve data performance bottlenecks in ELT processes and analytical workloadsEnsure data pipelines support incremental loads, historization, and change data capture (CDC) patterns where applicableWork closely with Agile teams to deliver production-ready data solutions, from design through deploymentAnalyze data issues and defects, performing root-cause analysis across pipelines, models, and transformationsMentor engineers on data warehousing best practices, Data Vault modeling, and performance optimization techniquesEnsure quality for our customers by validating Performance, Stability, Scalability, and Reliability for all of our scrum initiativesGain a technical and functional understanding of our product architecture and become part of the ongoing improvement of the performance of our enterprise applicationWork proactively with members of an Agile team to find and fix defects in our product architectureAnalyze defects / test results and be able to deduct the chain of events leading to a failureCommunicate critical issues and status updates in a timely manner to Agile teamsMentor technical resources on performance best practicesDeep understanding of Application Performance Monitoring and ability to develop predictive and prescriptive solutions in the big data arenaWhat we need from you:BA/BS in a related technical field; or the equivalent in education and work experienceA minimum of 10 years of experience in Information TechnologyA minimum of 10 years of hands-on experience in Data Warehousing, Data Engineering, and Data Architecture, with proven delivery of production-grade enterprise data platformsExperience 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 SatellitesStrong knowledge of Raw Vault, Business Vault, and Information/Data Mart designSolid 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 needsAbility to hit the ground running with minimal ramp-up on DW conceptsExperience building and managing data pipelines using Snowflake, Airflow, DBT, and Python, following modern ELT patternsExpertise in performance tuning and optimization of data warehouse workloads, pipelines, and transformationsExperience 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 plusOracle Database performance tuning expertiseData Analytics and Data Visualization servicesKnowledge 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 environmentsStrong understanding of SAFeDisplays Servant Leadership SkillsWhat we would like from you:Experience in wealth management, investment processing, domestic and international Equity and / or Fixed Income workflows and analyticsExperience effectively interacting with large application development and delivery teams and application development managers who are providing full lifecycle application support in complex, heterogeneous environmentsExperience working with senior leadership, ability to work comfortably with a wide range of people and skill setsData 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.