Data Warehouse Business Systems Analyst

Company Name:
Minimum salary: 32.00 USD
Maximum salary: 36.00 USD
Salary period: Hourly
Job Title: Data Warehouse Business Systems Analyst
Location: Glen Allen, VA
Salary: $32-36/hour
We have an immediate need for a Data Warehouse Business Systems Analyst for a long term contract in Glen Allen, VA. This contract will last a minimum of six months with a possibility of extending two years.
This role will be responsible for working with technical SME's from another Regional Company and/or a brand new Source System to document and map the differences between any new sources of data into the current Data Warehouse's logical and physical data models. This includes updating data dictionary, mapping diagrams, extending the current models, understanding outputs and identifying any changes or modifications needed to the Data Marts to achieve such.
This individual must have the skills to understand the logical data model as well as the business requirements for the data warehouse portion of the BI solution.
5+ years of experience creating models in 3rd Normal Form; Have worked with various modelling tools such as Embarcadero/Erwin/OpenModelSphere; Have modified physical data model for efficient data access paths; Have generated and executed DDL to create databases, tables, views, and the semantic layer; Have identified and created primary indexes, partitioned primary indexes, secondary indexes, join indexes, and all other needed indexes; Have identified statistics columns, and created and executed collect statistics statements; Have identified, defined, and created necessary associative tables, data constraints, and compression mechanisms; Have established standards, guidelines, and procedures for design and maintenance; Must have good communication skills and work well in a team environment; Must have experience interacting with end users, other developers, and/or other teams as part of the development process. Must have Insurance Services experience;
o Specific product experience in Business Property and Specialty Lines (Marine, Trucking/Motor Carrier, Education, Workers Comp, etc) in a multi-tier Company organization is beneficial.
Full job description upon request. Contact us today for additional information!

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.

More Jobs

Data Conversion Business/System Analyst - Mid/Sr
Reston, VA CACI International Inc.
Data Conversion Business/System Analyst - Senior
Reston, VA CACI International Inc.
Data Conversion Business/System Analyst
Reston, VA CACI International
Business Systems Analyst
Norfolk, VA Apex Systems
Business Systems Analyst II (Web portal focused)
Richmond, VA Virginia Premier Health Plan
AEM Business Systems Analyst
Richmond, VA Collabera