What are the responsibilities and job description for the MS SQL Server Developer / Data Analyst position at Vector Consulting, Inc?
Job Details
Our government client is looking for a MS SQL Server Developer / Data Analyst on a hybrid 12 months renewable contract role in Richmond, VA
Position – MS SQL Server Developer / Data Analyst
Job Description:
The agency 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.
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.
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.
Required/Desired Experience:
- Minimum 5 years of hands-on experience in SQL Server development, writing complex queries, data manipulation statements, stored procedures and tuning Required
- 5 years of Knowledge of indexing, query optimization, transaction handling for efficient data updates Required
- 5 years of Ability to analyze large datasets and pinpoint anomalies or inconsistencies Required
- 5 years of Familiarity with data cleansing tools and techniques Required
- 5 years of Ability to work independently and manage time effectively Required
- 5 years of Excellent problem-solving skills and attention to detail Required
- 5 years of Strong communication skills to collaborate with the data team and other business units Required
- Experience in Pensions Benefit Management Programs Desired
- Experience with data cleansing tools (SQL Server Data Quality Services, Trifacta, Talend, Alteryx, etc.) Desired
- Knowledge of programming languages such as Python Nice to have
- Familiarity with ETL and automated data transformation techniques Desired
- Other relevant certifications in SQL, Data Analysis and database management Not Required
About Vector:
Vector Consulting, Inc., (Headquartered in Atlanta) is an IT Talent Acquisition Solutions firm committed to delivering results. Since our founding in 1990, we have been partnering with our customers, understanding their business, and developing solutions with a commitment to quality, reliability and value. Our continuing growth has been and continues to be built around successful relationships that are based on our organization's operating philosophy and commitment to ** People, Partnerships, Purpose and Performance - THE VECTOR WAY
www.vectorconsulting.com
“Celebrating 30 years of service.”
____________________________________
