| 778616 |
SCC - Data Warehouse/BI Developer 4 |
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.
State Corporation Commission (SCC) 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.
- Develop end-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
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.
|