Overview:
We are seeking a Snowflake Data Engineer & Platform Specialist to join our growing data and analytics team. This role is responsible for designing, optimizing, and maintaining our Snowflake data platform and DBT-based data modeling pipelines. You will collaborate with data analysts, engineers, business stakeholders, and governance teams to ensure high-quality, performant, and secure data systems that support analytics and reporting across the organization.
Location: Fully Remote
Status: Contract

QUALIFICATIONS:

• 3–6 years of hands-on experience with Snowflake, including environment and compute resource management
• Proficiency in SQL and performance tuning for large-scale analytical workloads
• Strong experience with DBT for data modeling and transformation
• Solid understanding of dimensional modeling, star/snowflake schemas, and semantic layer architecture
• Familiarity with Power BI, including data modeling best practices and DAX optimization
• Experience with data validation tools (e.g., DBT tests, Great Expectations)
• Strong collaboration and documentation skills.

• Snowflake Platform Management:
• Configure and maintain Snowflake environments (databases, schemas, roles, warehouses)
• Monitor usage, performance, and costs of compute resources
• Manage access controls and implement role-level security (RLS) in alignment with governance standards
• Design and maintain efficient data pipelines for ingesting structured/semi-structured data
• DBT & Data Modeling:
• Build modular, scalable DBT models using best practices for documentation, testing, and optimization
• Develop incremental models, snapshots, and custom macros/tests
• Design and implement dimensional models (star/snowflake schemas) to support self-service BI and enterprise reporting
• Structure and optimize DBT project layout for scalability and maintainability
• Performance Tuning & Optimization:
• Tune complex SQL queries for large-scale datasets using CTEs, joins, and window functions
• Use clustering, warehouse sizing, and caching strategies to improve query performance
• Analyze and optimize DAX measures using tools like DAX Studio and VertiPaq Analyzer
• Apply storage and compute efficiency techniques to control costs
• Data Quality, Governance & Testing:
• Implement and maintain automated data validation checks using DBT tests or Great Expectations
• Ensure consistency, lineage, and governance alignment across data models
• Partner with governance teams to apply data quality standards and documentation practices
• Analytics & Reporting Support:
• Provide curated datasets and optimized views to enable BI tools like Power BI
• Collaborate with business users to support analytical queries and dashboard development
• Deep understanding of Power BI data models (Import, DirectQuery, Composite) and incremental refresh strategies
• Query Diagnostics & Profiling:
• Use tools like SQL Profiler, Power BI Performance Analyzer, and DAX Studio to trace and improve slow-running queries
• Optimize query design at the source to reduce performance bottlenecks
• Collaboration & Documentation:
• Partner with cross-functional teams to align data solutions with business needs
• Document data models, workflows, permissions, and platform configurations for internal stakeholders
• Support & Operations Breakdown:
• Data Model Enhancement – Build and enhance datasets for reporting needs
• Data Validation Investigation – Troubleshoot discrepancies and questions around existing reports and data
• Tech Debt Management – Optimize legacy data pipelines, clean up unused assets, and improve platform efficiency
• Administrative Requests – Assist with permissions planning and access needs (though not directly executing them)
• Architecture & Design Support – Participate in solution design for new initiatives
• Proof-of-Concepts – Evaluate new tools, models, or platform capabilities
• Ad Hoc Support – Quick turnaround tasks such as logic exports or dataset queries
  Note: Some categories exceed 100% as multiple responsibilities may overlap or occur simultaneously depending on business priorities.