Launch Your Career with Cook Systems
Ready to elevate your career? Cook Systems, a certified veteran owned IT consulting firm, has been transforming businesses and careers since 1990. Whether you're aiming to work with a Fortune 500 company or a small business, we've got you covered.
Our core values: integrity, investment, and innovation drive everything we do, ensuring you grow and succeed in a dynamic, supportive environment. We understand the importance of work life balance and personal growth. Our cutting edge IT consulting partners and FastTrack talent program are designed to help you excel.
Join our forward thinking team where excellence and creativity are valued every day. Check out what our associates have to say on Glassdoor. Ready to take your career to new heights? Cook Systems is where your journey to success begins!
2 Submittals - Market-rate compensation based on experience- Both Web Cam and In Person Interview
VRS Data Office team is seeking a skilled SQL Data Cleanup Specialist to assist with cleansing and standardizing data across a large-scale SQL Server database.
VRS Hybrid 2 days onsite per week (Tuesday and Wednesday)
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 large-scale SQL Server database
Minimum 5 years of hands-on experience in SQL Server development, writing complex queries, data manipulation statements, stored procedures and tuning
Required
5
Years
Knowledge of indexing, query optimization, transaction handling for efficient data updates
Required
5
Years
Ability to analyze large datasets and pinpoint anomalies or inconsistencies
Required
5
Years
Familiarity with data cleansing tools and techniques
Required
5
Years
Ability to work independently and manage time effectively
Required
5
Years
Excellent problem-solving skills and attention to detail
Required
5
Years
Strong communication skills to collaborate with the data team and other business units
Required
5
Years
Experience in Pensions Benefit Management programs
Desired
Years
Experience with data cleansing tools (SQL Server Data Quality Services, Trifacta, Talend, Alteryx, etc.).
Desired
Years
Knowledge of programming languages such as Python.
Nice to have
Years
Familiarity with ETL and automated data transformation techniques
Desired
Years
Other relevant certifications in SQL, Data Analysis and database management
Not Required
Years
Essential Duties and Responsibilities:
Assist with data cleanup related to the Data Quality Enhancement initiative and other development efforts as needed. Activities include:
? 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 hands-on 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 problem-solving 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 four-year 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 months. To be effective, this resource would need to be available within the next 4 weeks.
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 data related discussions. Onsite work will be at the VRS central office at 1200 East Main Street, Richmond, Virginia 23219.
Why Work with Us
Benefits
At Cook Systems, we don't just offer jobs we build futures. Our team is the heart of everything we do, and we're committed to supporting you with benefits that go beyond the basics. We want you to feel secure, valued, and empowered from the very beginning of your journey with us. When you join Cook Systems, here's what you can look forward to:
Your Health, Your Way: Choose from two comprehensive medical plans through Blue Cross Blue Shield, complete with dental and vision coverage. With access to one of the nation's largest networks, you'll get the care you need for yourself and your family wherever life takes you.
Peace of Mind, Every Step of the Way: Protect what matters most with life, critical illness, and accident insurance through Unum. Because your loved ones deserve security no matter what the future holds.
Flexibility for Life's Needs: Save money and plan ahead with a Flexible Spending Account and Daycare FSA through Navia, helping you manage healthcare and dependent care expenses on your terms.
Bridging the Gaps: Unexpected costs? No problem. Our Health Gap Insurance through Sunlife helps ensure you're covered when it counts.
Your Future Starts Now: Dream big with our 401(k) retirement plan through The Standard. After just six months, you will be eligible to participate, because your future deserves a strong foundation.
At Cook Systems, you're not just another employee you're family. Here, your ideas matter, your contributions shine, and your career will thrive. Together, we innovate, grow, and celebrate success every step of the way. Are you ready to be part of something bigger? Let's build the future together at Cook Systems.