Overview
Skills
Job Details
Job Title: Data Warehouse/BI Developer
Location: 1 Richmond, VA (Hybrid/two days on site)
Yakshna Solutions, Inc., (YSI) is a CMMI Level 3 assessed, ISO 9001, 20000:1, 27001 certified, woman-owned small business enterprises, headquartered in Herndon, Virginia, USA. YSI provides professional IT solutions and services to business corporations and government organizations. YSI is committed to serve 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.
Our client is looking for Data Warehouse/BI Developer to support their Richmond office.
Job Responsibilities
Supplement division staff by executing existing metric procedures for statutory and ad hoc reporting as well as data discrepancy assessment and resolution.
Developend-to-end automation framework and documentation to load data and query results to SQL Server tables using standard Microsoft products.
Build, validate, document, and implement end-to-end processes using automation framework to load vendor-provided data and other division data, to calculate regulatory and division metrics, and to perform data quality checks and address geographies coding.
Train division staff on use and maintenance of automation framework.
Required skills and experience
BS/MS degree in Computer Science, Engineering or a related subject
Proven work experience in software development/programming
Proven work experience in using SQL, SQL Server, and related Microsoft products
Developing ETL and using Microsoft Visual Studio experience
Experience in using Python and one or more business intelligence tools, leading a project, in training team members with different experience levels in processes, creating data quality checks experience, and developing a high-level plan with estimates
Ability to work under pressure, adhere to tight deadlines while maintaining high-quality work, analyze data, identify issues, and validate accuracy.
Experience using Census Geocoder
Experience using APIs