Data Analyst / Data Architect

Responsibilities

• Migrate architecture and design lead end-to-end source-to-target mapping design for the SQL Server to Snowflake migration, including schema analysis, data profiling, and transformation logic documentation
• Architect Snowflake environments including database/schema structures, virtual warehouses, role-based access control (RBAC), and resource monitors
• Design and document data flow diagrams, lineage maps, and migration runbooks to ensure traceability and auditability throughout the migration lifecycle
• Define standards for naming conventions, data types, partitioning strategies, clustering keys, and time-travel/fail-safe policies in Snowflake
• Write and optimize complex T-SQL scripts to extract and transform data from SQL Server sources for ingestion into Snowflake
• Develop Snowflake SQL scripts, stored procedures, tasks, streams, and dynamic tables to implement transformation logic and incremental load patterns
• Implement data validation and reconciliation scripts to verify source vs. target row counts, aggregates, and business rules post-migration
• Tune query performance in Snowflake through execution plan analysis, clustering optimization, and materialized view strategies
• Design and maintain dimensional models (star/snowflake schemas), OBT structures, and data vault patterns appropriate for Snowflake's architecture
• Collaborate with data stewards and business stakeholders to define data dictionaries, business glossaries, and metadata standards
• Establish data quality frameworks and implement automated profiling, anomaly detection, and SLA monitoring
• Design and develop Tableau dashboards and published data sources connected to Snowflake, optimizing live and extract connections for performance
• Build Power BI datasets, reports, and dashboards with DAX measures, row-level security, and deployment pipelines
• Translate business requirements into semantic layer designs (e.g., Tableau Published Data Sources, Power BI datasets) to enable self-service analytics
• Collaborate with analysts and business users to validate reporting outputs against source systems and ensure data accuracy
• Partner with data engineering, analytics, and business intelligence teams to ensure seamless handoffs and alignment throughout the migration lifecycle
• Produce comprehensive technical documentation including mapping specifications, architecture decision records (ADRs), and operational runbooks
• Present migration status, risks, and architectural decisions to technical and non-technical stakeholders including senior leadership

Requirements

• 10 years minimum of relevant work experience
• Deep expertise in Microsoft SQL Server, including T-SQL, SSMS, SSIS, and performance tuning
• Hands-on experience with Snowflake, including data loading (Snowpipe, COPY INTO), Snowflake SQL, tasks, streams, and administration
• Proven experience designing and executing source-to-target data mapping documentation for large-scale migration projects
• Strong proficiency in Tableau (Desktop, Server/Online) including advanced calculations, LOD expressions, and performance optimization
• Experience with Power BI including Power Query (M), DAX, data modeling, and Report Server or Power BI Service deployment
• Familiarity with ETL/ELT orchestration tools (Azure Data Factory, dbt, Fivetran, Matillion, or equivalent)
• Solid understanding of dimensional modeling, data warehousing principles, and data lake architectures
• Strong written and verbal communication skills, with the ability to produce clear technical documentation and present to diverse audiences

Qualifications

• BS required in Computer Science or Engineering
• Data certifications are nice to have

Benefits

• Comprehensive benefits offered

Pay

The estimated pay range for this position is USD $70.00/hr - USD $83.00/hr. Exact compensation and offers of employment are dependent on job-related knowledge, skills, experience, licenses or certifications, and location.