Data Analyst

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

Benefits offered by this job

Free parking

Job summary

STI in Charlottesville, VA is seeking a Data Analyst to design, build, and optimize SSRS reports and BI dashboards. The role involves ETL work to load data into on‑prem and cloud systems, plus SQL scripting and data validation. You'll collaborate with the ACIT team and stakeholders to deliver accurate analytics and insights.

The position requires 4–6 years of experience, on-site/off-site flexibility during the initial week, and a hybrid work arrangement with remote options after onboarding.

Qualifications

• 4–6 years of experience in data analytics and BI.
• Expertise in SSRS report design and deployment.
• Strong SQL skills for querying and data manipulation.
• Experience with ETL, data cleaning, and data loading.
• Ability to work with stakeholders on reporting and analytics.

Responsibilities

• Create and customize SSRS reports based on mockups from the configuration team.
• ETL: clean and load data to on‑prem and cloud databases; SQL scripting and querying.
• Develop BI reports and dashboards to support stakeholders.
• Collaborate with ACIT team, vendors and partners on reporting solutions.
• Perform data validation and ensure data quality across projects.

Skills

SSRS reports

SQL Server

SQL querying

Data analysis

Data modeling

Stakeholder collaboration

Tools

Power BI

Azure Data Warehouse

Azure ETL

Microsoft Fabric

Python

Job description

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 Title: Data Analyst
Location: Charlottesville, VA 22902
Duration: 12+ Months
8am to 4.30pm

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

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.

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 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 toolsli>
• Experience with Microsoft Fabric
• Proficiency in scripting languages (e.g., Python, PowerShell) for automation and data manipulation.