Snowflake Architect
Contract W2
12 Months
No Travel Required
Hybrid
Depends on Experience
Midasis Technologies LLC
Fitment
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- Extract, Transform, Load
- Data Engineering
- Data Quality
- Data Warehouse
- DevOps
- Continuous Delivery
- Development Testing
- Dimensional Modeling
- Documentation
- Continuous Improvement
- Continuous Integration
- Data Modeling
- Git
- Analytics
- Change Data Capture
- Cloud Computing
- Collaboration
- Root Cause Analysis
- Performance Tuning
- Data Loading
- ELT
- Macros
- Mentorship
- Requirements Analysis
- Snow Flake Schema
- Technical Drafting
- Testing
- Microsoft Azure
- Optimization
- Python
- Query Optimization
- SQL
- Warehouse
- Workflow
Summary
Roles & Responsibilities
- Lead the design, development, optimization, and maintenance of scalable data pipelines using Snowflake and dbt.
- Own data engineering solutions end-to-end, from requirements analysis and data modeling through development, testing, and production deployment.
- Design efficient data models and transformation frameworks supporting enterprise analytics and business consumption.
- Develop and optimize complex SQL transformations, incremental processing, CDC, and ELT workflows.
- Troubleshoot complex data issues, perform root cause analysis, and implement sustainable engineering solutions.
- Establish engineering best practices around code quality, modularity, reusability, performance optimization, and cost efficiency.
- Build robust data quality, reconciliation, monitoring, and validation frameworks.
- Collaborate with architects, business stakeholders, and engineering teams to translate business requirements into scalable technical solutions.
- Lead technical design reviews, mentor engineers, and ensure high-quality deliverables.
- Identify opportunities for automation, simplification, and continuous improvement.
Required Technical Skills
- Snowflake: Strong hands-on expertise in Snowflake architecture, performance tuning, query optimization, warehouse sizing, Snowpark, and data loading strategies.
- dbt: Advanced experience with dbt models, incremental strategies, macros, Jinja, testing, snapshots, documentation, and CI/CD integration.
- SQL: Expert-level SQL skills, including complex joins, window functions, query optimization, and troubleshooting.
- Python: Strong programming skills for data engineering, automation, and integration.
- Data Modeling: Experience with dimensional modeling, medallion architecture, data warehousing, and enterprise data models.
- Data Engineering: Strong understanding of ETL/ELT, batch and incremental processing, CDC, data quality, and reconciliation.
- Cloud Platforms: Experience with Azure data services.
- DevOps: Experience with Git, CI/CD pipelines, deployment automation, and engineering standards.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: 91173393
- Position Id: 9132464
- Posted 2 hours ago
Company Info
About Midasis Technologies LLC
At Midasis Consulting LLC, we are more than just a consulting firm, we are your trusted partner in transforming the way businesses leverage technology to drive success. With a deep commitment to innovation, integrity, and excellence, we stand at the forefront of IT staffing and project augmentations, delivering tailored solutions that empower businesses to thrive in today’s fast-evolving landscape.
At Midasis, our mission is to empower businesses with innovative IT solutions, expert talent, and unparalleled service. We are committed to delivering excellence in every engagement, fostering success for our clients, partners, and employees alike.
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.