Job Title:SQL Data Cleanup Specialist 761239
Client:Virginia Information Technology Agency
Location:Richmond Virginia 23219
NOTE:The individual will follow the VRS Hybrid work schedule including 2 days onsite per week (Tuesday and Wednesday). The individual may also be called to be onsite for critical meetings and datarelated discussions. Onsite work will be at the VRS central office at 1200 East Main Street Richmond Virginia 23219.
The Virginia Retirement System (VRS) Data Office team is seeking a skilled Structured Query Language (SQL) Data Cleanup Specialist to assist with cleansing and standardizing data across a largescale SQL Server database
Essential Duties and Responsibilities:
- Assist with data cleanup related to the Data Quality Enhancement initiative and other development efforts as needed.
- Maintain the confidentiality of all business data and adhere to VRS data security policies.
- Analyze and understand the structure and relationships within the database.
- Write and execute SQL update and insert statements to clean and optimize data.
- Utilize tools and techniques to automate and expedite the data cleansing process.
- Collaborate with the data team to ensure data integrity and accuracy.
- Document the data cleanup process and provide regular progress updates.
- Special projects at the direction of the Chief Operating Officer or Data Officer.
Required Skills and Experience:
- Minimum 5 years of handson experience in SQL Server SQL development including writing complex queries data manipulation statements stored procedures and tuning.
- Knowledge of indexing query optimization transaction handling for efficient data updates.
- Ability to analyze large datasets and pinpoint anomalies or inconsistencies.
- Familiarity with data cleansing tools and techniques.
- Ability to work independently and manage time effectively.
- Excellent problemsolving skills and attention to detail.
- Strong communication skills to collaborate with the data team and other business units.
Desired Skills:
- Experience in Pensions Benefit Management programs.
- Experience with data cleansing tools (SQL Server Data Quality Services Trifacta Talend Alteryx etc.
- Knowledge of programming languages such as Python.
- Familiarity with ETL and automated data transformation techniques.
- Other relevant certifications in SQL Data Analysis and database management.
Education and Experience:
- Bachelor s degree from a fouryear college or university preferred and 5 years experience with database technology or data organizations required.
- This will be a contract position starting with a period of 15 be effective this resource would need to be available within the next 4 weeks.
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:
Since 2000 TriForce Consulting Services has been an MBE/SDB certified IT Consulting
firm in the Philadelphia region. TriForce specializes in IT staffing software development (web and mobile apps)
systems integration data analytics system automation cybersecurity and cloud technology solutions for government
and commercial clients. TriForce works with clients to overcome obstacles such as increasing productivity
increasing efficiencies through automation and lowering costs. Our clients benefit from our three distinguishing
core values: integrity diligence and technological excellence.
TriForce is a sixtime winner among the fastestgrowing companies in Philadelphia and a fourtime winner on the
Inc. 5000 list of the nations fastestgrowing companies.
Desired Skills: Experience in Pensions Benefit Management programs. Experience with data cleansing tools (SQL Server Data Quality Services, Trifacta, Talend, Alteryx, etc. Knowledge of programming languages such as Python. Familiarity with ETL and automated data transformation techniques. Other relevant certifications in SQL, Data Analysis and database management.
Education
Bachelor s degree from a four-year college or university preferred and 5+ years experience with database technology or data organizations required.