staff-sql-engineer

Name: staff-sql-engineer
Availability: InStock
Author: waynebanksy

Develop optimized SQL queries and data models for financial data in Snowflake and PostgreSQL.

1|Updated Apr 27, 2026

Search Tags:#postgresql #optimization #financial data #data modeling #sql #query performance #snowflake

Ready to run

npx skills add https://github.com/WayneBanksy/wayneys_claude --skill staff-sql-engineer

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: staff-sql-engineer
Source: https://github.com/WayneBanksy/wayneys_claude/tree/main/skills/staff-sql-engineer
Command: npx skills add https://github.com/WayneBanksy/wayneys_claude --skill staff-sql-engineer

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill enables precise construction, optimization, and modeling of SQL queries tailored for Snowflake and PostgreSQL, addressing common challenges in financial data environments.

Core Features & Use Cases

Query Writing and Optimization: Create efficient SQL queries, enhance performance, and troubleshoot slow-running statements.
Data Modeling: Design star schemas, implement Slowly Changing Dimensions (SCD Type 2), and structure complex data models.
Use Cases: Automate query tuning for large datasets, develop incremental models in dbt, and apply Snowflake-specific features like VARIANT handling and clustering to improve data retrieval times.

Quick Start

Write a SQL query to calculate daily account balances using CTEs and window functions.

Frequently Asked Questions about staff-sql-engineer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I optimize slow SQL queries for large-scale financial analytics in Snowflake?▼

To optimize slow SQL queries in Snowflake, apply platform-specific features like clustering keys and VARIANT handling to improve data retrieval. Structuring efficient queries with CTEs and window functions ensures performance and correctness for large-scale financial analytics.

What is the best way to model Slowly Changing Dimensions (SCD Type 2) in PostgreSQL financial databases?▼

Modeling Slowly Changing Dimensions (SCD Type 2) in PostgreSQL involves designing star schemas and structured data models to maintain historical financial data integrity. This approach tracks historical changes accurately while ensuring optimized query performance across large datasets.

Can I use dbt to develop incremental data models for financial data in Snowflake and PostgreSQL?▼

Yes, you can develop incremental models in dbt for financial data in Snowflake and PostgreSQL. This automates query tuning for large datasets, leveraging platform-specific features to maintain data integrity and enhance retrieval performance.

How do I calculate daily account balances using SQL window functions and CTEs?▼

Calculating daily account balances using SQL involves writing queries with Common Table Expressions (CTEs) and window functions. This technique structures complex financial analytics logic clearly, ensuring query correctness and optimized performance for large-scale data retrieval.

Does this SQL query optimization approach handle VARIANT data types in Snowflake?▼

Yes, handling VARIANT data types in Snowflake is supported as a platform-specific feature. It structures semi-structured financial data correctly within data models, ensuring data integrity and improving retrieval times during complex analytical query execution.

When should I use star schemas for financial data modeling in PostgreSQL?▼

You should use star schemas for financial data modeling in PostgreSQL when structuring complex data for large-scale analytics. This design organizes financial metrics and dimensions efficiently, ensuring query performance and supporting accurate historical tracking.