Data WarehouseBI Developer 4
Share
Job Location:
Richmond, VA - USA
Monthly Salary:
Not Disclosed
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
Job Title: Data Warehouse/BI Developer 4 (778616)
Location: 1111 E Main St Richmond VA 23219 (Hybrid 2 Days/week) Parking not provided
Duration: 12 Months Contract with possibility to extension
Job Description:
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 they have exp (esp beside Desired exp) then we will start looking for addl 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!
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.
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.
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
Key Skills
- Business Intelligence
- Cognos
- SQL
- Power BI
- QlikView
- Microsoft SQL Server
- ssrs
- Tableau
- SSIS
- T Sql
- Data Modeling
- Data Warehouse
