Data Analysis Job at Acess Global, Washington DC

RUJyaHdpY2pCT2psNTVpNTZhS25sdXJYOXc9PQ==
  • Acess Global
  • Washington DC

Job Description

Job Description :



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.

Job Tags

Similar Jobs

Peregrine Team

CT Tech- Travel Job at Peregrine Team

Peregrine Team is hiring for CT Techs in Fort Bragg, CA. This is a travel position with 16-week-long contracts (able to extend). Weekly Rate: $2,657.00/week Taxed Weekly Rate: $1,152.00/week Weekly Stipend (M&IE, Lodging): $1,505.00/week Qualifications... 

MatrixRecruiters.com

Remote Junior Marketing Support Assistant | Entry-Level | No Experience or Degree Needed Job at MatrixRecruiters.com

 ...Remote Junior Marketing Support Assistant | Entry-Level | No Experience or Degree Needed Want to support real marketing teams without writing content, doing sales, or managing customer service? This entry-level remote role is ideal for beginners who want to learn the... 

ContacLink Solutions

Spanish US-Based Freelance Interpreter Job at ContacLink Solutions

 ...WE ARE HIRING INTERPRETER!!! LANGUAGE : Spanish US-Based Interpreter As a remote interpreter, you play a significant role...  ...Additional information: Remote position, interpreter works from his/her home office Ongoing training and competency opportunities... 

Blue Compass RV Des Moines

RV Sales Associate Job at Blue Compass RV Des Moines

Start your journey with Blue Compass RV as we are looking for Sales Associates to join our team and manage the sales process from start to finish. In this role you will help clients with product selection, negotiate terms, and ultimately finalize sales. The Role: The... 

Stellar IT Solutions LLC

Sr. Jira Admin Job at Stellar IT Solutions LLC

 ...Job Title: Sr. Jira Admin Interview: Virtual Job Location: Remote Job Duration: 6+ Months Role Overview: We are seeking a highly skilled Sr. Jira Administrator to join the team. The ideal candidate will have hands-on experience with Rally to Jira...