Snowflake Developer
Job Location:
Dallas, IA - USA
Monthly Salary:
Not Disclosed
Posted on:
3 hours ago
Vacancies:
1 Vacancy
Job Summary
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: