| Data Warehouse-BI Developer - IN PERSON IVS ONLY! (719066)-VA-DPOR at Richmond, Virginia, USA |
| Email: [email protected] |
| From: Nagajyoti, INNOZA TECH LLC. [email protected] Reply to: [email protected] Position: Data Warehouse/BI Developer - IN PERSON IVS ONLY! (719066) Location: Richmond, VA Duration: 12 Months Client: DPOR Need local candidate Need 10+ years candidate IN PERSON Interviews required so must be local or willing to come to their facility and interview IN PERSON (no exceptions!) REQUIRED: 1. Able to analyze existing systems including screens and available documentation (e.g., data models or data dictionaries) to understand how the underlying data is organized, interrelated and stored in various databases as well as identify where there may be data anomalies / inconsistencies 2. Able to interact with and ask pertinent questions of system users to understand the organization and relationship of data in the systems and map data from source systems to target templates/systems 3. Able to create clear, concise and complete documentation (e.g., data models, data dictionaries) regarding the organization and use of data in existing systems 4. Able to accurately map data from source systems to target templates/systems and resolve issues stemming from the mapping efforts 5. Strong working knowledge in Oracle (predominantly) and SQL Server creating complex queries, views, functions and stored procedures that leverages knowledge gained from analyzing systems and underlying data organization to extract / transform data into a vendor defined (TBD) format 6. Experience developing and testing data extraction and transformation routines PREFERRED 7. (not a primary skill, but a strong secondary skill that would be used when the above skills are not being used) - Able to perform data analysis and put together meaningful reports / dashboards using an agencies existing data 8. (preference though not required) - Strong working experience with Microsoft Power BI DPOR would like to bring on a resource with the above skillset as soon as possible. The reason for the urgency is that DPOR would like to for this resource to have a little time to acclimate and learn DPOR's existing systems so that when the time comes to begin converting data, the resource is ready to meet the need. SKILLS Able to write complex SQL (joins, functions, stored procedures) to extract data and transform data from both Oracle and SQL Server databases Able to analyze existing systems to understand how underlying data is stored and inter-related Able to create, clear, concise and complete documentation related to the organization and use of data in existing systems Able to accurately map data from source systems to target templates/systems and resolve issues stemming from the mapping efforts Experience developing and testing data extraction and transformation routines Strong working experience with Microsoft Power BI Able to perform data analysis and put together meaningful reports / dashboards using an agencies existing data Keywords: business intelligence Virginia |
| [email protected] View all |
| Fri Sep 01 20:54:00 UTC 2023 |