Need Data Warehouse/BI Developer 4 - Local to Richmond, VA

Overview Hope you\'re doing well. We have an open position for a

Data Warehouse/BI Developer 4 . Location: Richmond, VA (Hybrid). Client: SCC - State of Virginia. Job ID: 778616. Interview mode: Web Cam and In Person. Local candidates within 2 hours\' drive to Richmond preferred.

Role Supplement division staff by executing existing metric procedures for statutory and ad hoc reporting, 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.

Required Skills

BS/MS degree in Computer Science, Engineering, or a related subject — Required, 4 years of experience.

Proven work experience in software development/programming — Required, 8 years of experience.

Proven work experience in using SQL, SQL Server, and related Microsoft products — Required, 8 years of experience.

Proven work experience in developing ETL and using Microsoft Visual Studio — Required, 8 years of experience.

Experience in using Python and one or more business intelligence tools — Required, 8 years of experience.

Experience in leading a project — Required, 8 years of experience.

Experience in writing clear, concise, and comprehensive documentation — Required, 8 years of experience.

Experience in training team members with different experience levels on processes — Required, 8 years of experience.

Experience in creating data quality checks — Required, 8 years of experience.

Experience in developing a high-level plan with estimates — Required, 8 years of experience.

Strong analytical skills and attention to detail — Required, 8 years of experience.

Strong communication skills to collaborate with team members and agency employees — Required, 8 years of experience.

Ability to analyze data, identify issues, and validate data accuracy — Required, 8 years of experience.

Ability to work under pressure and adhere to tight deadlines while maintaining high-quality work — Required, 8 years of experience.

Experience using Census Geocoder — Desired, 8 years of experience.

Experience using APIs — Desired, 8 years of experience.

Questions

Question 1: Commonwealth of Virginia security policies prohibit offshore IT contractors. Do you attest that your candidate will physically reside within the US for the duration of the assignment?

Question 2: Please list candidate\'s email address.

Question 3: In what city and state does your candidate currently reside? If they are in Richmond but phone or resume locations do not support this, please upload a copy of their driver\'s license to verify their RVA address at submission (Reference Tab).

Question 4: If selected, this role requires the candidate be on-site 2 days per week (local Richmond area preferred). Does your candidate agree to this arrangement?

Question 5: Ensure the skills matrix is accurately reflected on the resume. If a skill is not present, mark as n/a. Be careful to avoid misleading information.

Question 6: Initial interview will be virtual; manager may request an on-site interview.

Seniority level

Mid-Senior level

Employment type

Contract

Job function

Business Development and Sales

Industries

Software Development

#J-18808-Ljbffr