Overview
Hybrid
$65 - $70
Accepts corp to corp applications
Contract - Independent
Contract - 12 Month(s)
Skills
Microsoft SQL Server
Ad Hoc Reporting
Data Warehouse
Data Quality
Documentation
Python
Computer Science
Job Details
Title: SCC - Data Warehouse/BI Developer 4 (778616) Duration: 12 Months Location: Richmond, VA 23219 Client: Virginia Information Technology Agency
Note: Hybrid role
- Job Description:
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 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
Proven work experience in software development/programming
Proven work experience in using SQL, SQL Server, and related Microsoft products
Proven work experience in developing ETL and using Microsoft Visual Studio
Experience in using Python and one or more business intelligence tools
Experience in leading a project
Experience in writing clear, concise, and comprehensive documentation
Experience in training team members with different experience levels on processes
Experience in creating data quality checks
Experience in developing a high level plan with estimates
Strong analytical skills and attention to detail
Strong communication skills to effectively collaborate with team members and other agency employees
Ability to analyze data, identify issues, and validate data accuracy
Ability to work under pressure and adhere to tight deadlines while maintaining high-quality work
Experience using Census Geocoder
Experience using APIs
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.