Job Title: Snowflake Developer
Location: Dallas, TX
Long Term Contact
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.
Best Regards:
Bindu M
Phone:
Email: