Snowflake Developer - Dallas, Texas
Dallas, Georgia, United States of America
Contract
2 weeks ago
Key skills
PythonSQLAILLMELTData EngineeringData WarehousingAnalyticsBIBusiness IntelligencePower BISnowflakeRollupREST APIPerformance OptimizationSaaSCommunication
About this role
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