Lorven Technologies
Albemarle County - Data Analyst 2
Lorven Technologies, Charlottesville, Virginia, United States, 22904
Position:
Albemarle County - Data Analyst 2 - REPLACING 742704 (744695)
Location: 401 McIntire Rd Charlottesville, VA 22902 - Hybrid
Contract Position
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 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 SkillsExpertise in designing, developing, and deploying SSRS reports.Proficiency with SQL ServerStrong knowledge of SQL for querying relational databasesExperience with complex queries, joins, subqueries, and data manipulation.Perform data analysis, data profiling, SQL coding/query tuning, data modeling, and data validationWork and partner with internal stakeholders to develop reports or address data access and visualization needsExperience in data modeling with strong and demonstratable data management skillsDesired Skills/Experience
Power BI report developmentExperience with Azure data warehousing solutionsExperience with Azure ETL (Extract, Transform, Load) processes and toolsExperience with Microsoft FabricProficiency in scripting languages (e.g., Python, PowerShell) for automation and data manipulation.
Albemarle County - Data Analyst 2 - REPLACING 742704 (744695)
Location: 401 McIntire Rd Charlottesville, VA 22902 - Hybrid
Contract Position
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 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 SkillsExpertise in designing, developing, and deploying SSRS reports.Proficiency with SQL ServerStrong knowledge of SQL for querying relational databasesExperience with complex queries, joins, subqueries, and data manipulation.Perform data analysis, data profiling, SQL coding/query tuning, data modeling, and data validationWork and partner with internal stakeholders to develop reports or address data access and visualization needsExperience in data modeling with strong and demonstratable data management skillsDesired Skills/Experience
Power BI report developmentExperience with Azure data warehousing solutionsExperience with Azure ETL (Extract, Transform, Load) processes and toolsExperience with Microsoft FabricProficiency in scripting languages (e.g., Python, PowerShell) for automation and data manipulation.