Data Analyst 2

Location: Charlottesville, Virginia, USA

Duration: 10 Months (Hybrid)

Visa Status: USC,GC, GCEAD, H1b, C2C

Job Description:

Day to day responsibilities
Initial workload will be heavily focused on creation of SSRS reports, utilizing mockups provided by a configuration team to customize standard vendor provided reports.
Working on ETL processes to clean and load data to on-prem and cloud databases, SQL Server scripting and querying, and Business Intelligence report creation are other likely duties.
The Data Analyst will work with other ACIT team members, department stakeholders, vendors, and partners in the design, development and implementation of reporting, integration and data analytics solutions.
Required Skills
Expertise in designing, developing, and deploying SSRS reports.
Proficiency with SQL Server
Strong knowledge of SQL for querying relational databases
Experience with complex queries, joins, subqueries, and data manipulation.
Perform data analysis, data profiling, SQL coding/query tuning, data modeling, and data validation
Work and partner with internal stakeholders to develop reports or address data access and visualization needs
Experience in data modeling with strong and demonstratable data management skills
Desired Skills/Experience
Power BI report development
Experience with Azure data warehousing solutions
Experience with Azure ETL (Extract, Transform, Load) processes and tools
Experience with Microsoft Fabric
Proficiency in scripting languages (e.g., Python, PowerShell) for automation and data manipulation.
Required 5 Years. Proficiency with SQL Server
Required 4 Years. Expertise in designing, developing, and deploying SSRS reports
Required 4 Years. Strong knowledge of SQL for querying relational databases
Required 4 Years. Experience with complex queries, joins, subqueries, and data manipulation
Required 4 Years. Perform data analysis, data profiling, SQL coding/query turning, data modeling, and data validation
Required 3 Years. Work with partner and internal stakeholders to develop reports or address data access and visualization needs
Required 3 Years. Experience in data modeling with strong and demonstratable data management skills
Highly desired 3 Years. Power BI report development
Highly desired 3 Years. Experience with Azure data warehouse solutions
Highly desired 3 Years. Experience with Azure ETL (Extract, Transform, Load) processes and tools
Highly desired 1 Years. Experience with Microsoft Fabric
Desired 3 Years. Proficiency in scripting languages (e.g., Python, PowerShell) for automation and data manipulation.


#Data #Analyst #2 #SparkleGenius #SparkleGeniusJobs #SparkleGeniusOpenings #Spark #Sparkle #OpenPosition #NewJob #Job #Career #Hiring #Recruitment #NowHiring #HiringNow #Employment #Work #JobSearch #JobHunt #JobAlert #HumanResource #Staffing #Vacancy #JobSeeker #NewOpenings #Jobs #NewJobs #JobsinUSA #Richmond #Virginia #OpentoWork #Open #FullTime #PartTime #ContractWork #Freelance #JobOpening #Hiring #JobListing #Career #Employment #JobOpportunity #TechJobs #IT #ITjobs #nonITjobs