Snowflake DBA

Snowflake DBA

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 Responsibilities

• Designing, developing, and maintaining a data warehouse in Snowflake (and other HTAP databases such as Space & Time) including landing, curated, and semantic zones
• Understanding 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 solutions
• Architect and Design type 2 SCD and type 1 SCD components
• Design reusable assets, components, standards, frameworks, and processes to support and facilitate end to end ETL solutions
• Design 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 frequencies
• Gathering requirements and defining the strategy for 3rd parties data ingestion methodologies such as SAP Hana, and Oracle, Teradata, SQL Server
• Understand the security requirements and apply RBAC, PBAC, ABAC policies on the data.
• Build data pipelines in Snowflake leveraging Data Lake (S3/Blob), Stages, Streams, Tasks, Snowpipe, Time travel, and other critical capabilities within Snowflake
• Must use Informatica Cloud (CDQ and CDG) to build ETL, Data Catalog, and other Data Governance components
• Data modeling, Master and Operational Data Stores, Data ingestion & distribution patterns, ETL / ELT technologies, Relational and Non-Relational DB's, DB Optimization patterns

Required Qualifications

• Ability 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 teams
• Excellent communication skills with a demonstrated ability to engage, influence, and encourage partners and stakeholders to drive collaboration and alignment
• 15+ 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 discussions
• Excellent knowledge of RDBMS topics, SQL, OLAP, OLTP, NO-SQL databases, JSON
• Must have at least 3+ years of hands-on experience in SnowSQL, JavaScript Stored Procedures, performance tuning, Streaming Ingestion, and Streams
• Must have hands-on working knowledge of ETL tools developing pipelines, workflows supporting Snowflake EDW implementation
• Optional knowledge of DBT and other Snowflake-specific technologies
• Must be a curious self-starter with minimal directions and support the client in various initiatives turning into their trusted lieutenant
• Demonstrated learning agility, ability to make decisions quickly and with the highest level of integrity
• Demonstrable experience in driving meaningful improvements in business value through data management and strategy
• Must have a positive, collaborative leadership style with colleagues and customer first attitude
• Should be a self-starter and team player, capable of working with a team of architects, co-developers, and business analysts
• Outstanding oral and written communication skills including formal presentations for all levels of management combined with strong collaboration/influencing.

Preferred Qualifications:

• Experience with Azure Cloud, DevOps implementation
• Ability to work as a collaborative team, mentoring and training the junior team members
• Position requires expert knowledge across multiple platforms, data ingestion patterns, processes, data/domain 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 expert/thought 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 collaboration/influencing.

Preferred Education/Skills:

• Prefer Master’s degree
• Bachelor’s Degree in Computer Science with a minimum of 15+ years relevant experience or equivalent.