HTAP Architect
Paradigm Technology - dallas, TX
Apply NowJob Description
HTAP Architect Job Overview:As a HTAP Architect for clients of Paradigm, you will be filling the role of a hands-on technical Architect expected to have specialized working knowledge in Snowflake and Space & Time. In this role, you'll be working as part of Paradigm's Digital Solutions group, where we are looking for someone who has the necessary technical expertise to build and maintain sustainable Data Integration Solutions to support identified needs and expectations from the client.Prefer to have Insurance background as well. Delivery ResponsibilitiesDesigning, developing, and maintaining a data warehouse in Snowflake (and other HTAP databases such as Space & Time) including landing, curated, and semantic zonesUnderstanding and experience in most of the following architectural styles: Layered Architectures, Transactional applications, Data warehousing applications, PaaS-based architectures, and SaaS-based applications; Experience designing ETL-based Cloud PaaS and SaaS solutions.Understand, design, and articulate capacity planning and sizing details based on needs from several internal and external use cases.Focus on ETL aspects including performance, scalability, reliability, monitoring, and other operational concerns of data warehouse solutionsArchitect and Design type 2 SCD and type 1 SCD componentsDesign reusable assets, components, standards, frameworks, and processes to support and facilitate end to end ETL solutionsDesign virtual warehouses using Snowflake for data-sharing needs for both internal and external customers.Create Snowflake data-sharing capabilities that will create a marketplace for sharing files, datasets, and other types of data in real-time and batch frequenciesGathering requirements and defining the strategy for 3rd parties data ingestion methodologies such as SAP Hana, and Oracle, Teradata, SQL ServerUnderstand the security requirements and apply RBAC, PBAC, ABAC policies on the data.Build data pipelines in Snowflake leveraging Data Lake (S3Blob), Stages, Streams, Tasks, Snowpipe, Time travel, and other critical capabilities within SnowflakeMust use Informatica Cloud (CDQ and CDG) to build ETL, Data Catalog, and other Data Governance componentsData modeling, Master and Operational Data Stores, Data ingestion & distribution patterns, ETL ELT technologies, Relational and Non-Relational DB's, DB Optimization patternsRequired QualificationsAbility to collaborate, influence, and communicate across multiple stakeholders and levels of leadership, speaking at the appropriate level of detail to both business executives and technology teamsExcellent communication skills with a demonstrated ability to engage, influence, and encourage partners and stakeholders to drive collaboration and alignment15+ years of hands-on experience in Snowflake, Informatica, and other cloud-based solutions with an ability to deal with sophisticated projects, critical timelines, and hands-on clients who need to be engaged in design discussionsExcellent knowledge of RDBMS topics, SQL, OLAP, OLTP, NO-SQL databases, JSONMust have at least 3+ years of hands-on experience in SnowSQL, JavaScript Stored Procedures, performance tuning, Streaming Ingestion, and StreamsMust have hands-on working knowledge of ETL tools developing pipelines, workflows supporting Snowflake EDW implementationOptional knowledge of DBT and other Snowflake-specific technologiesMust be a curious self-starter with minimal directions and support the client in various initiatives turning into their trusted lieutenantDemonstrated learning agility, ability to make decisions quickly and with the highest level of integrityDemonstrable experience in driving meaningful improvements in business value through data management and strategyMust have a positive, collaborative leadership style with colleagues and customer first attitudeShould be a self-starter and team player, capable of working with a team of architects, co-developers, and business analystsOutstanding oral and written communication skills including formal presentations for all levels of management combined with strong collaborationinfluencing.Preferred Qualifications:Experience with Azure Cloud, DevOps implementationAbility to work as a collaborative team, mentoring and training the junior team membersPosition requires expert knowledge across multiple platforms, data ingestion patterns, processes, datadomain models, and architectures.Candidates must demonstrate an understanding of the following disciplines: enterprise architecture, business architecture, information architecture, application architecture, and integration architecture.Ability to focus on business solutions and understand how to achieve them according to the given timeframes and resources.Recognized as an expertthought leader. Anticipates and solves highly complex problems with a broad impact on a business area.Experience with Agile Methodology Scaled Agile Framework (SAFe).Outstanding oral and written communication skills including formal presentations for all levels of management combined with strong collaborationinfluencing.Preferred EducationSkills: Prefer Master's degreeBachelor's Degree in Computer Science with a minimum of 15+ years relevant experience or equivalent.
Created: 2024-10-03