Data Analyst

JOB DESCRIPTION

Overview:   
 
TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions to our clients world-wide. Our client provider of digital technology and transformation, information technology and services 
 
 
 
Position: Data Analyst  
 
Location: Bellevue, WA or Frisco TX, Atlanta GA  
 
Duration: 6 Months   
 
Job Type: Contract  
 
Work Type: Hybrid  
 
 
 
Job Description: 
 
 
 
We are seeking a highly skilled Data Analyst with expertise in SQL development, Power BI, SSRS, and Tableau to support a data migration project from SQL Server to Azure Data Lake Storage (ADLS). 
 
 
 
The ideal candidate will be responsible for data analysis, reporting, and documentation of data objects to ensure a smooth and efficient migration.  
 
 
 
Key Responsibilities:  
 
 
 
Analyze existing SQL Server databases, schemas, and data structures to support migration planning.  
 
 
 
Develop complex SQL queries, stored procedures, and scripts for data extraction, transformation, and validation.  
 
 
 
Utilize Power BI, SSRS, and Tableau to generate reports and dashboards that provide insights into data integrity, completeness, and migration status.  
 
 
 
Document data objects, data lineage, relationships, and transformations for migration reference.  
 
 
 
Collaborate with data engineers, architects, and stakeholders to ensure seamless migration and adherence to best practices.  
 
 
 
Perform data quality assessments, anomaly detection, and validation checks to ensure accuracy post-migration.  
 
 
 
Optimize SQL queries and performance-tune reports for efficiency in handling large datasets.  
 
 
 
Provide ongoing support and troubleshooting for reporting and data-related issues.  
 
 
 
Required Skills & Qualifications:  
 
 
 
5+ years of experience in SQL development with strong knowledge of T-SQL, stored procedures, indexing, and query optimization.  
 
 
 
Hands-on experience with Power BI, SSRS (SQL Server Reporting Services), and Tableau for data visualization and reporting.  
 
 
 
Experience with data migration projects, particularly from SQL Server to cloud-based storage solutions (Azure Data Lake Storage - ADLS preferred).  
 
 
 
Strong understanding of data modeling, ETL processes, and database structures.  
 
 
 
Proficiency in data documentation, lineage tracking, and metadata management.  
 
 
 
Ability to analyze and interpret complex data sets to drive business insights.  
 
 
 
Experience in working with large datasets and performance tuning for reporting solutions.  
 
 
 
Knowledge of Azure Data Services (ADLS, Synapse, Databricks) is a plus.  
 
 
 
Skill set : 
 
 
 
Data Analysis, Tableau, Power Bi, Sql Developer.  
 
 
 
  
 
TekWissen   Group is an equal opportunity employer supporting workforce diversity.