Powershell Data Jobs

1 job found

Today

Data Analyst

Software Technology Inc Charlottesville, VA

Charlottesville, VA

Today

Contract Analyst Analytics Azure Platform

Apply Now

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

View full job page →

Get Powershell Data Jobs alerts

New Powershell Data Jobs, daily.