No SCC Data WarehouseBI Developer 4

Richmond, VA - USA

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

Job Title/Req No - SCC - Data Warehouse/BI Developer 4

Interview Type - Both Webcam and In-Person Interview

Work Arrangement - Hybrid

Short Description-
*Deadline to submit: No later than 4 pm est on Thurs 10/16 (the earlier the better)
SCC - Datawarehouse /BI Dev
ON SITE: 2 days/week required. Parking not provided

Full Job Description -
*Deadline to submit: No later than 4 pm Est on Thurs 10/16 (the earlier the better)
*Initial IV will be Virtual but mgr. reserves the right to conduct a follow up IN PERSON IV if they deem necessary.
SCC - Datawarehouse /BI Dev
ON SITE: 2 days/week required. Parking not provided

ABOUT THE ROLE

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 process 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.

Skills Matrix -
Skill Required / Desired Amount of Experience
BS/MS degree in Computer Science Engineering or a related subject Required 4 Years
Proven work experience in software development/programming Required 8 Years
Proven work experience in using SQL SQL Server and related Microsoft products Required 8 Years
Proven work experience in developing ETL and using Microsoft Visual Studio Required 8 Years
Experience in using Python and one or more business intelligence tools Required 8 Years
Experience in leading a project Required 8 Years
Experience in writing clear concise and comprehensive documentation Required 8 Years
Experience in training team members with different experience levels on processes Required 8 Years
Experience in creating data quality checks Required 8 Years
Experience in developing a high level plan with estimates Required 8 Years
Strong analytical skills and attention to detail Required 8 Years
Strong communication skills to effectively collaborate with team members and other agency employees Required 8 Years
Ability to analyze data identify issues and validate data accuracy Required 8 Years
Ability to work under pressure and adhere to tight deadlines while maintaining high-quality work Required 8 Years
Experience using Census Geocoder Desired 8 Years
Experience using APIs Desired 8 Years

Questionnaires -
Question 1 Commonwealth of Virginia security policies prohibit the use of offshore IT contractors. Do you attest to the fact that your candidate will physically reside within the US for the duration of the assignment
Question 2 Please list the candidates email address.
Question 3 In what city and state does your candidate currently reside If you indicate they are in Richmond but phn# or resume locations/clients do not support this pls upload a copy of their drivers license to verify their local RVA address. Pls so this at time of submittal - under Reference Tab.
Question 4 If selected this role requires the candidate to be ON SITE 2 days on site each week (local Richmond area candidates preferred). Does your candidate agree to this arrangement
Question 5 Pls make sure to highlight (on your candidates resume) any of the required or desired skills so they stand out and support what is on the skills matrix. If they do not have any of the skills/exp in the matrix simply put n/a beside that skill. If you put them have exp (esp beside Desired exp) then we will start looking for add l details on the resume to support this; if we cannot find the exp in the resume then it looks misleading. Pls be careful when filling out the skills matrix!
Question 6 Initial IV will be Virtual but mgr. reserves the right to conduct a follow up IN PERSON IV if they deem necessary. Pls make sure your candidate is aware of this.

Job Title/Req No - SCC - Data Warehouse/BI Developer 4 Interview Type - Both Webcam and In-Person Interview Work Arrangement - Hybrid Short Description- *Deadline to submit: No later than 4 pm est on Thurs 10/16 (the earlier the better) SCC - Datawarehouse /BI Dev ON SITE: 2 days/week re...

Job Title/Req No - SCC - Data Warehouse/BI Developer 4

Interview Type - Both Webcam and In-Person Interview

Work Arrangement - Hybrid