Data Loading Analyst Jobs (NOW HIRING)

Job Summary:
Milestone Technologies, Inc. is seeking a Senior level Data Analyst/Data Architect to support a critical enterprise data migration initiative, transitioning their data platform from Microsoft SQL Server to Snowflake. The role involves designing scalable data architectures, building robust migration pipelines, and enabling modern self-service analytics through tools like Tableau and Power BI.
Responsibilities:
• 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
• Build and maintain ELT pipelines leveraging tools such as dbt, Azure Data Factory, Fivetran, or Informatica for automated data movement
• 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
Qualifications:
Required:
• 10 years minimum of relevant work experience
• SQL Server, Tableau and Power BI
• Understand how integrations work (how data is integrated through ETL and API)
• 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
• BS required in Computer Science or Engineering
Preferred:
• Data certifications are nice to have
Company:
Milestone Technologies is a global IT Services and Digital Solutions company based in Silicon Valley that helps hundreds of leading corporations deliver technology around the globe. Founded in 1997, the company is headquartered in Fremont, USA, with a team of 1001-5000 employees. The company is currently Late Stage.