Data Analyst

Job Title: Data Analyst Location: Charlottesville, VA 22902 Duration: 12+ Months Hours: 8am to 4:30pm 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. Mgr agrees to initial Virtual interviews but reserves the option to request an IN PERSON interview if needed. Candidate must work IN PERSON (ON SITE) for the first full week (5 days) of the engagement, then at least one day a week ON SITE thereafter. Access to broadband internet and a home office free from distractions is required for remote work. Optional in-person work allowed. Additional in-person days may be necessary for meetings with clients. Parking is free at our facilities. The employee cannot have billable hours on government holidays. Must work independently or as part of a small team on projects. Years of Experience: 4-6 Days on Site per week: 1-2 Day-to-day responsibilities Initial workload focuses heavily on creation of SSRS reports, customizing vendor-provided reports based on mockups. Work on ETL processes to clean and load data into on‑prem and cloud databases, SQL Server scripting and querying, and Business Intelligence report creation. Collaborate with 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 (Python, PowerShell) for automation and data manipulation #J-18808-Ljbffr