Title: Data Analyst - Hybrid
Location: Charlottesville, VA, USA
Length: Long term
Restriction: W2 or C2C

Description:

*** Both Web Cam and In Person Interview *** Long term *** *** Hybrid *** 1/2 Days on Site per week***

*** Mgr agrees to initial Virtual IVs but reserves the option to request an IN PERSON IV if needed. ***

*** The selected candidate must be able to work IN PERSON (ON SITE) for the first full week (5 days) of the engagement then a minimum of one day a week ON SITE thereafter REQUIRED. The candidate must have access to broadband internet and a home office free from distractions to qualify for remote work. The candidate can optionally work in person if preferred. Pls do not submit if they cannot agree to this arrangement. ***

Short Description:

Data Analyst needed to create and customize SSRS reports, analyze, clean and load SQL data for migration project, and create Business Intelligence reports and dashboards.

Job Description:

Additional inperson days may be necessary for meetings with clients.
Parking is free at our facilities.
The employee cannot have billable hours on our government holidays.
Must work independently or as part of a small team on projects.
Years of Experience: 4/6

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:

Proficiency with SQL Server 5 Years
Expertise in designing, developing, and deploying SSRS reports 4 Years
Strong knowledge of SQL for querying relational databases 4 Years
Experience with complex queries, joins, subqueries, and data manipulation 4 Years
Perform data analysis, data profiling, SQL coding/query turning, data modeling, and data validation 4 Years
Work with partner and internal stakeholders to develop reports or address data access and visualization needs 3 Years
Experience in data modeling with strong and demonstratable data management skills 3 Years

Highly Desired Skills:

Power BI report development 3 Years
Experience with Azure data warehouse solutions 3 Years
Experience with Azure ETL (Extract, Transform, Load) processes and tools 3 Years
Experience with Microsoft Fabric 1 Years

Desired Skills:

Proficiency in scripting languages (e.g., Python, PowerShell) for automation and data manipulation. 3 Years