Data Analyst

STI; Charlottesville (VA); Hybrid; USD 70,000 - 90,000; Full time

Benefits offered by this job

Free parking

Flexible work arrangements

Job summary

A technology solutions provider is seeking an experienced Data Analyst in Charlottesville, VA. This role involves creating and customizing SSRS reports, performing data analysis, and developing Business Intelligence solutions. The ideal candidate should have 4-6 years of experience, expertise with SQL Server, and strong skills in creating reports. Flexibility to work in-person and remotely is required, with a focus on delivering high-quality data integrations and visualizations.

Qualifications

• 4-6 years of experience in data analysis and reporting.
• Experience with ETL processes and data migration.
• Ability to work independently and as part of a team.

Responsibilities

• Create and customize SSRS reports based on mockups.
• Work on ETL processes to clean and load SQL data.
• Develop Business Intelligence reports and dashboards.

Skills

Designing SSRS reports

SQL Server proficiency

Complex queries and joins

Data analysis and profiling

Data modeling

Collaboration with stakeholders

Tools

SQL Server

Power BI

Azure ETL tools

Microsoft Fabric

Python

PowerShell

Job description

Job Title

Data Analyst

Location

Charlottesville, VA 22902

Duration

12+ Months

Work Hours

8am to 4.30pm

In‑Person Work Arrangement

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.

Additional in‑person days may be necessary for meetings with clients.

Parking is free at our facilities.

The employee cannot have billable hours on our government holidays.

Work Flexibility

Must work independently or as part of a small team on projects.

Years of Experience

4-6

Days on Site per week

1-2

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.

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.
• 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.