Data Warehouse/BI Developer

Overview

On Site
Full Time
Part Time
Accepts corp to corp applications
Contract - W2
Contract - Independent

Skills

Data Warehouse
Business Intelligence
Organized
SQL
Stored Procedures
Oracle
Microsoft SQL Server
Database
Documentation
Mapping
Testing
Data Extraction
Microsoft Power BI
Data Analysis
Dashboard
SANS
Technical Direction

Job Details

W2 Only

for W2 Candidates

REQUIRED:

  • 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
  • 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
  • Able to create clear, concise, and complete documentation (e.g., data models, data dictionaries) regarding 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
  • 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
  • Experience developing and testing data extraction and transformation routines


Skill

Required / Desired

Years Used

Last Used

Able to write complex SQL (joins, functions, stored procedures) to extract data and transform data from both Oracle and SQL Server databases

Required

Able to analyze existing systems to understand how underlying data is stored and inter-related

Required

Able to create, clear, concise, and complete documentation related to the organization and use of data in existing systems

Required

Able to accurately map data from source systems to target templates/systems and resolve issues stemming from the mapping efforts

Required

Experience developing and testing data extraction and transformation routines

Required

Strong working experience with Microsoft Power BI

Required

Able to perform data analysis and put together meaningful reports/dashboards using an agency's existing data

Required

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.