Job ID: Data Warehousing Specialist Senior *** ).
(Rate may vary depending on candidate preference for either w-2 (benefits or no benefits) or must have a ‘LLC’ –limited liability corporation.
Location: Washington, DC
Years of experience: 11-16+ years’ experience.
Duration: *** + possible extensions.
Number of positions:1
11-15 years of experience. Coordinates the data administration technical function for both data warehouse development and maintenance.
DCPS - Data warehouse specialist
DCPS is seeking an experienced data warehouse specialist to support the implementation of a data warehouse that drives timely and accurate downstream reporting and analytics. Working alongside DCPS staff, the specialist will be responsible for developing data warehouse technical requirements, physical data model(s) and schema to support the implementation of the data warehouse solution. The specialist will work with source system developers to design and implement ETL approaches to pull data from systems of record into data warehouse. The developer will also support report development by directing SQL queries and create reports on K12 related data in a business-intelligent manner for internal clients. The specialist will also work with DCPS staff to review and update pre-existing report applications and SQL reports and underlying dataset queries to improve performance.
The specialist will be expected to balance immediate needs with future direction and ensure that work for one project can be leveraged for other purposes as much as possible. In addition to technical skill they must have a strong sense of curiosity and a focus on outcomes as critical parts of the role will be to help come up with the future long-term vision for data systems in DCPS and plan out what should be built to implement that vision.
1. Translates data warehouse business requirements into physical data model and schema. Works with technical staff and program teams to develop understanding of reporting requirements as needed. Reviews and makes recommendations about how to transition current state reporting platform to data warehouse.
2. Designs ETL approach to pull data from systems ...