Albemarle County - Data Analyst 2 - REPLACING 742704

Engagement Type

Contract

Short Description

REPLACING: 742704. See below.

Data Analyst needed to create customize SSRS reports analyze clean and load SQL data for migration project create Business Intelligence reports and dashboards.

ON SITE requirement see below

Complete Description

REPLACING REQ: 742704. Mgr unable to find the mix of technical and communication skills they were looking for. If you candidate was forwarded under 742704 OR they interviewed and were not chosen please do not resubmit them!! You will be losing a spot!

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 inperson 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: 46

Days on Site per week: 12

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

Required/Desired Skills

Skill Required/Desired Amount of Experience Proficiency with SQL Server Required 5 Years Expertise in designing developing and deploying SSRS reports Required 4 Years Strong knowledge of SQL for querying relational databases Required 4 Years Experience with complex queries joins subqueries and data manipulation Required 4 Years Perform data analysis data profiling SQL coding/query turning data modeling and data validation Required 4 Years Work with partner and internal stakeholders to develop reports or address data access and visualization needs Required 3 Years Experience in data modeling with strong and demonstratable data management skills Required 3 Years Power BI report development Highly desired 3 Years Experience with Azure data warehouse solutions Highly desired 3 Years Experience with Azure ETL (Extract Transform Load) processes and tools Highly desired 3 Years Experience with Microsoft Fabric Highly desired 1 Years Proficiency in scripting languages (e.g. Python PowerShell) for automation and data manipulation. Desired 3 Years

Questions

Description Question 1 Commonwealth of Virginia security policies prohibit the use of offshore IT contractors. Do you attest to the fact that your candidate will physically reside within the US for the duration of the assignment Question 2 Please list candidates email address. Question 3 In what city and state does your candidate currently live Question 4 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. 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. If selected does your candidate agree to this arrangement