Data Warehousing BI Analyst

  • Full-time

Company Description

Dorkin Inc.

     Our employees are a reflection of our company and our goal is  to make this your “end all be all” through restoring job security and longevity in the American workplace. Our corp-culture is very friendly, upbeat, and fast-paced. We encourage feedback from our staff   and welcome the opportunity to hire energetic polished individuals with a mind frame of growth and customer service excellence. Join a leading edge company with whom you can be proud to represent and bring some stability back into your work-life balance. Every team member has a strong “drink the kool-aid” attitude towards being a successful employee of DORKIN inc.

Job Description

Provides technical team leadership support for the full systems development lifecycle (SDLC) data warehouse.
Proficient in design and maintenance of real time data warehousing and business intelligence platforms with real time data acquisition and reporting.
Work with clients to understand requirements and translate them into the appropriate technical solution.
Architect Data Warehouses/Marts by developing technical infrastructure designs, data mappings, flows and report dissemination mechanisms.
Design and implement data models for database applications using Oracle Designer (Star Schema/Dimensional Modeling).
Analyze source data of different types and design programs for extraction, transformation and loading into an Oracle database.
Create and manage database objects including tables, indexes and procedures.
Develop and test programs using SQL, PL-SQL and SQL*Loader for database applications.
Manage unit, system and integration testing for accuracy and performance.
Develop and generate standard and ad hoc reporting capabilities from new and existing data sources.
Develop and modify queries, programs and stored procedures to support standard and ad hoc reporting.
Perform data loading and manipulation using Oracle and Informatica software.
Meet or exceed targeted billing hours (utilization).
Assist with business development activities, such as proposals, capture, account teams, whitepapers, conferences, and/or other thought leadership materials.

Qualifications

Active Clearance: TS/SCI

Additional Information

All your information will be kept confidential according to EEO guidelines.