Data Analyst
Analyst
Analytics
Azure Platform
Business Analytics
Business Intelligence
Data
Data Analysis
Data Analytics
Data Integration
Data Operations
Data Pipeline
Data Platform
Data Processing
Data Visualization
Data Warehouse
Data Warehousing
Database
Databases
ETL
Information Technology (IT)
Microsoft Fabric
MS SQL
Power BI
Powershell
Reporting and Analytics
Reporting Tools
SQL
Sql Reporting Services
SQL Server
SSRS
Job Description
Contract Data Analyst position in Charlottesville, VA focusing on SSRS reporting, SQL data migration support, and BI dashboards, with initial on-site work and potential remote options.
Responsibilities
- Design and tailor SSRS reports using configuration team mockups to modify standard vendor reports.
- Analyze, clean, and load SQL data to support migration projects.
- Develop Business Intelligence reports and dashboards.
- Support ETL processes to cleanse and load data to on-premises and cloud databases, including SQL Server scripting and querying, and BI report creation.
- Collaborate with ACIT team members, department stakeholders, vendors, and partners to design, develop and implement reporting, integration, and data analytics solutions.
Requirements
- Proven expertise in designing, developing, and deploying SSRS reports.
- Proficiency with SQL Server.
- Strong SQL querying skills for relational databases.
- Experience with complex queries, joins, subqueries, and data manipulation.
- Ability to perform data analysis, data profiling, SQL coding and query tuning, data modeling, and data validation.
- Capability to partner with internal stakeholders to develop reports or address data access and visualization needs.
- Experience in data modeling with solid data management skills.
Technologies
- SSRS
- SQL Server
- Power BI
- Azure data warehousing solutions
- Azure ETL processes and tools
- Microsoft Fabric
- Python
- PowerShell
Benefits
- Free parking on site at facilities.
Location
- Charlottesville, VA 22902
Duration
- 12+ Months
Description
Data Analyst duties include creating and customizing SSRS reports, processing and loading SQL data for a migration project, and building BI reports and dashboards. Initial interviews may be virtual, with the possibility of an in-person interview. The selected candidate must be able to work on site for the first full week (5 days) and on-site at least one day per week thereafter.
Day to Day Responsibilities
- Initial workload prioritizes SSRS report creation using mockups to tailor standard vendor reports.
- Work on ETL processes to clean and load data to on-premises and cloud databases, along with SQL Server scripting and BI report creation.
- Collaborate with ACIT team members, stakeholders, vendors, and partners to design and implement reporting, integration, and data analytics solutions.
Experience
- 4-6 years
On-site Schedule
- 1-2 days on site per week
Required Skills
- Expertise in designing, developing, and deploying SSRS reports.
- Proficiency with SQL Server.
- Strong SQL querying skills for relational databases.
- Experience with complex queries, joins, subqueries, and data manipulation.
- Data analysis, profiling, SQL coding, query tuning, data modeling, and data validation.
- Ability to work with internal stakeholders to develop reports or address data access and visualization needs.
- Experience in data modeling with strong data management skills.
Desired Skills/Experience
- Power BI report development
- Azure data warehousing solutions
- Azure ETL processes and tools
- Microsoft Fabric
- Proficiency in scripting languages such as Python or PowerShell for automation and data manipulation
Similar Jobs
