VDH T-SQL Programmer Analyst - Yakshna Solutions : Job Details

We strive to attract and retain the brightest people and offer different job experiences with a full range of challenges and rewards.We help companies realize and implement IT solutions strategically. Yakshna Solutions supports our client's mission and goals by sharing our know-how, skills and knowledge. We take pride in being an equal opportunity employer.Working with Yakshna gives you the opportunity to develop your knowledge, skills, and abilities. Additionally, you can build a network of peers, mentors and advance your career! We offer exciting opportunities to work with leading industry experts, business consultants and IT specialists across large government and private sector companies. The people who work in Yakshna are as diverse as our services. We recognize the crucial importance of each individual to our success and offer competitive compensation, comprehensive benefits and innovative training.Opportunities here exist across many services and across many US states. Don't forget to refer your friends to earn cash for qualified referrals! Based on your relevant profile and our current requirements, our recruitment team will contact you as soon as possible.Open Jobs Jul 17 2024ID: 742187Job Title: VDH T-SQL Programmer AnalystYakshna Solutions, Inc (YSI) is a CMMI Level 3 assessed, ISO 9001, 20000:1, 27001 certified, woman-owned small business enterprise, headquartered in Herndon, Virginia, USA. YSI provides professional IT solutions and services to business corporations and government organizations. YSI is committed to serving its business communities as a leading IT vendor providing innovative, quality, and cost-effective IT business solutions and services.We offer a competitive benefits package that includes the following: 401(k), health, dental, and vision insurance, life insurance, short-term and long-term disability insurance, paid time off, training, and professional development assistance.YSI is seeking a highly qualified T-SQL Programmer Analyst. The selected candidate will be able to communicate effectively (written/verbal), possess strong interpersonal skills, be self-motivated, and be innovative in a fast-paced environment.*Local candidates strongly preferred*Remote work is available now but needs to be able to come onsite when requested, NO exceptionsExplore and understand the data structure and contents in the data repositories.Assist in the review of data quality, troubleshooting, and data cleanup process.Manage and maintain large volumes of data using manual and automated techniques for investigation and resolution of data quality issues. Assist in gathering and documenting data needs and migration requirements for use in the migration tool design, as well as other reporting measures.Develop, automate, and maintain data management and data improvement processes using MS SQL SSMS, MS SQL Server Jobs, SSIS, and Tableau.Utilize SQL server environment for all SQL development activities including data extraction, data quality, transformation and formatting, testing, modification and validation.Participate in the development of effective solutions and enhancements to increase efficiency of system operations, availability and reporting of high-quality data. Routinely review SQL scripts and processes to optimize performance.Develop QA and performance dashboards measuring data quality dimensions including integrity, validity, accuracy, consistency, and completeness using Tableau or similar software.Extensive experience implementing relevant, trend-based data quality measurements and assessing scope, frequency and severity of data anomalies using advanced SQL scripts within MS SQL Server Management Studio.Maintain documentation of processes, procedures and manuals.Assist in managing and maintaining the confidentiality and security of the data at all times.Assist in responding to data requests, data analysis using SQL and automation/generation of ad-hoc reports.Provide assistance in various data management activities as assigned.Collaborate with VDH peers to ensure formatted data received meets reporting and system requirements within the Office of Epidemiology (OEPI).May write reports or facilitate data access by other means as needed, to include SSIS, SSRS, Tableau, etc.Participate in internal and external meetings.YSI is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.#J-18808-Ljbffr