Data Analyst

Seeking a Data Analyst for a contract role with a State Government organization in Charlottesville, VA.
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.