Snowflake Developer - Dallas, Texas

Job Title: Snowflake Developer
Location: Dallas, Texas

Can do Only W2, No C2C

Job Summary:

• We are seeking an experienced Snowflake Developer with strong expertise in designing, developing, and optimizing enterprise-scale data warehouse solutions using Snowflake.
• The ideal candidate will possess hands-on experience in advanced SQL development, data pipeline architecture, multi-source data integration, Python-based data engineering, and Power BI optimization.
• Experience with Snowflake Cortex, AI capabilities, and intelligent automation within the Snowflake ecosystem is highly desirable.

Key Responsibilities:

• Design, develop, and maintain scalable data warehouse solutions using Snowflake.
• Build and optimize normalized ELT/data transformation pipelines for enterprise data platforms.
• Design dimensional data models optimized for business intelligence and analytics.
• Develop advanced SQL queries utilizing PIVOT, GROUPING SETS, ROLLUP, and CUBE.
• Manage Snowflake environments, including warehouse sizing, performance tuning, and cost governance.
• Integrate data from multiple heterogeneous sources including relational databases, REST APIs, SaaS platforms, and event streams.
• Develop Python-based data engineering solutions for automation, orchestration, API integration, and custom connectors.
• Design Snowflake data structures optimized for Power BI reporting and analytics.
• Improve DirectQuery performance and optimize fact/dimension models.
• Implement best practices for data quality, scalability, and performance.
• Leverage Snowflake Cortex, LLM functions, and AI agent capabilities to build intelligent data-driven automation solutions.
• Collaborate with business stakeholders, architects, and BI teams to deliver enterprise analytics solutions.

Required Skills:

• Expert-level experience with Snowflake Data Warehouse
• Hands-on production experience designing Snowflake schemas
• Advanced SQL development (PIVOT, GROUPING SETS, ROLLUP, CUBE)
• Snowflake environment administration
• Warehouse sizing and cost optimization
• ELT/Pipeline design and implementation
• Dimensional data modeling
• Multi-source data integration
• Relational database integration
• REST API integration
• SaaS platform integration
• Event stream ingestion
• Power BI data modeling optimization
• Fact and Dimension modeling
• Aggregation table design
• DirectQuery performance optimization
• Python programming for data engineering
• Pipeline orchestration
• Data transformation
• API client development
• Automation scripting
• Custom connector development
• Snowflake Cortex
• LLM Functions
• AI Agents within Snowflake

Preferred Qualifications:

• Experience implementing enterprise-scale cloud data warehouse solutions.
• Experience designing high-performance analytical data models.
• Knowledge of AI-powered data engineering and intelligent automation.
• Experience supporting enterprise reporting and analytics environments.
• Strong understanding of modern ELT architecture and best practices.

Soft Skills:

• Excellent analytical and problem-solving skills.
• Strong communication and interpersonal abilities.
• Ability to work independently and within cross-functional teams.
• Strong organizational and documentation skills.
• Ability to manage multiple priorities in a fast-paced environment.
• Proactive approach toward performance optimization and continuous improvement.

Mandatory Skills:

• Snowflake
• Advanced SQL
• Schema Design
• Data Warehousing
• ELT / Data Pipelines
• Data Modeling
• Python
• Power BI
• REST APIs
• Multi-Source Data Integration
• Snowflake Cortex
• LLM Functions
• AI Agents
• Warehouse Sizing
• Cost Governance

Best Regards:

Peerbhi SK
Phone:
Email: peerbhi