Overview
Remote
On Site
Hybrid
BASED ON EXPERIENCE
Contract - W2
Contract - Independent
Skills
Analytical Skill
Collaboration
Cloud Computing
Stored Procedures
Data Mapping
Data Validation
Quality Assurance
Migration
Optimization
Performance Tuning
Business Intelligence
Data Migration
3D Computer Graphics
Tableau
Dashboard
Snow Flake Schema
SQL
Access Control
Oracle Linux
Data Warehouse
Dimensional Modeling
Extract
Transform
Load
Agile
Communication
SANS
Management
Job Details
Job Summary:
We are seeking a highly skilled Data Specialist / Senior Data Analyst to support a strategic data platform migration from traditional SQL-based systems to Snowflake. This role will play a critical part in data mapping, transformation logic, validation, and performance optimization during the migration effort. The ideal candidate will be a SQL expert with a strong analytical mindset and hands-on experience in data warehousing and BI tools. Experience with Wherescape, Tableau, DBT, and Snowflake are considered strong advantages.
Key Responsibilities:
Must-Have Qualifications:
Nice-to-Have Experience (In Order of Priority):
Preferred Qualifications:
We are seeking a highly skilled Data Specialist / Senior Data Analyst to support a strategic data platform migration from traditional SQL-based systems to Snowflake. This role will play a critical part in data mapping, transformation logic, validation, and performance optimization during the migration effort. The ideal candidate will be a SQL expert with a strong analytical mindset and hands-on experience in data warehousing and BI tools. Experience with Wherescape, Tableau, DBT, and Snowflake are considered strong advantages.
Key Responsibilities:
- Collaborate with data engineers and stakeholders to support the migration of legacy SQL data systems to the Snowflake cloud data platform.
- Analyze existing SQL queries, stored procedures, and ETL processes to identify transformation logic and performance bottlenecks.
- Design and document data mapping specifications, data models, and transformation rules.
- Perform data validation, reconciliation, and quality assurance between source and target systems.
- Assist in building robust data pipelines and transformation layers using modern data tools where applicable (e.g., Wherescape, DBT).
- Work with BI teams to ensure Tableau dashboards and reports function as expected post-migration.
- Support troubleshooting, optimization, and performance tuning of SQL and Snowflake queries.
Must-Have Qualifications:
- Advanced proficiency in SQL (including complex joins, CTEs, window functions, and performance tuning).
- 5+ years of experience in a data-focused role (e.g., Data Analyst, Data Specialist, BI Developer).
- Proven experience in enterprise-scale data migrations or transformations.
Nice-to-Have Experience (In Order of Priority):
- Wherescape: Experience with Wherescape RED or 3D in data warehousing environments.
- Tableau: Ability to support and validate Tableau dashboards, including data source changes and visual validation.
- DBT (Data Build Tool): Familiarity with modular SQL transformation frameworks and version-controlled development practices.
- Snowflake: Understanding of Snowflake architecture, including virtual warehouses, Snowflake SQL, and role-based access controls.
Preferred Qualifications:
- Strong understanding of data warehousing concepts, dimensional modeling, and ETL best practices.
- Experience working in Agile environments or on cross-functional data teams.
- Excellent written and verbal communication skills.
- Ability to work independently and manage multiple priorities in a fast-paced environment.
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.