Data Warehouse BI Developer at Richmond, Virginia, USA |
Email: [email protected] |
From: karthik, RITWIK Infotech INC [email protected] Reply to: [email protected] Hello Associate, Hope you are doing well We have the below requirement open. Please send me your genuine candidate on my email ID [email protected] Data Warehouse/BI Developer - (719066) Start Date - 09/11/2023. End Date - 08/19/2024 Location - Richmond, VA 23233 Local to Virginia or Nearby Location. Interview Type - In Person Only Work Arrangement- Onsite IN PERSON Interviews required so must be local or willing to come to their facility and interview IN PERSON (no exceptions!) Complete Description: The effort will be a mix of onsite and remote work, with an initial assessment onsite, after which the hybrid arrangement would be defined. This effort could run at least 12 to 18 months and the onsite work would be at DPOR's 9960 Mayland Drive offices at the beginning until telework is determined and evaluated. No time limit on the remote piece - just when the mgr is comfortable. This will be determined during the assessment phase. Pls make sure your candidate is aware of this. ABOUT THE ROLE This resource will analyze current three IT systems in order to understand how the data is stored and related. This resource will leverage that knowledge in order to write SQL to extract (and possibly transform) that data. A major part of this project will be to convert data from existing systems to its new system. I don't believe that we will need someone with specific ETL tool experience. Rather I believe that we will need someone with the following skills: Require/Desire Skills Able to write complex SQL (joins, functions, stored procedures) to extract data and transform data from both Oracle and SQL Server databases Required 5 Years Able to analyze existing systems to understand how underlying data is stored and inter-related Required 5 Years Able to create, clear, concise and complete documentation related to the organization and use of data in existing systems Required 3 Years Able to accurately map data from source systems to target templates/systems and resolve issues stemming from the mapping efforts Required 5 Years Experience developing and testing data extraction and transformation routines Required 5 Years Strong working experience with Microsoft Power BI Nice to have 2 Years Able to perform data analysis and put together meaningful reports / dashboards using an agencies existing data Nice to have 2 Years Keywords: business intelligence information technology Idaho Virginia |
[email protected] View all |
Wed Aug 30 00:41:00 UTC 2023 |