Title: Data Analyst 2
Location: Charlottesville VA (Hybrid)
Duration: 12 Months
Client: Virginia Information Technology Agency (VITA)
Note: This is a Hybrid Position
The applicant is the center of our universe.
Job Description:
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 after that 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 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 sub queries 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 demonstrable data management skills.
Desired Skills:
- 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.
"If you are: bright motivated skilled a differencemaker able to get things done work with minimum direction enthusiastic a thinker able to juggle and multitask communicate effectively and lead then we would like to hear from you. We need exceptionally capable people for this role for our client so get back to us and tell us why you think you are a fit."
About Us:
TriForce is one of the fastest growing companies in Philadelphia region by receiving the award 5 times and 3 times(Ranked #) on Inc. 5000 fastest growing companies in the USA. TriForce Consulting Services Inc. is an established consulting services firm offering innovative solutions to Government and Commercial sectors. We specialize in building customized software applications solutions such as knowledge management systems business intelligence data analysis database support and maintenance data warehouse implementation and support systems architecture and systems integration for our clients. Our technical competencies are in Java.NET SharePoint PHP Business Intelligence (Cog nos Data Warehouse) mobile applications platforms (iPhone iPad Android Blackberry) and various other technologies. We also specialize in providing resources to manage infrastructure projects. TriForce is one of the fastest growing companies in the Philadelphia region by receiving the award 5 times and 2 times on Inc. 5000 fastest growing companies in the USA.
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