SENIOR DATA WAREHOUSE ANALYST / DEVELOPER

Location: QUANTICO, VA
Date Posted: 09-21-2017
 
IronArch Technology is searching for an IT Manager to provide Financial Improvement and Audit Readiness (FIAR) services to the Department of the Air Force. This position will focus on performing financial statement audits, performance audits, service provider audits, examination and financial management consulting services related to audit readiness and compliance engagements.

TITLE: SENIOR DATA WAREHOUSE ANALYST/DEVLOPER
CLEARANCE: Must be a US citizen and be eligible for a NACI clearance!!
LOCATION: QUANTICO
 
PRIMARY RESPONSIBILITIES:
  • Working with the various functional and technical teams is responsible for data design, warehouse data architecture, metadata and
  • assisting with the data integration layer’s repository creation.
  • Designs and assists in developing complex data migration processes for the data warehouse.
  • Works with the customer data warehouse counterparts to review data loaded into the data warehouse for accuracy.
  • Provides recommendations regarding technology alternatives for the Enterprise Data Warehouse and Data Integration Layer.
  • Assists in troubleshooting and tuning data warehouse data and processes.
  • Develops, maintains, and supports complex enterprise data warehouse systems and corresponding data marts.
  • Creates new or enhanced components of the data warehouse.
 
TECHNICAL SKILLS AND CORE COMPETENCIES REQUIRED:
  • Cognos
  • Oracle Data Integrator
  • Logical & Physical data modeling
  • Master data management
  • Data warehousing
  • Oracle and/or SQL Server
  • Data analysis
  • Understands Point of Sale data (e.g., Retail)
  • ERwin
  • Program design and development
  • APIs
  • Create complex SQL statements
 
MINIMUM QUALIFICATIONS:
  • Years of Experience Required: 3
  • Education Level: 4 Year Degree
 
IronArch, Inc. provides a competitive compensation package, including medical and dental insurance, life and disability insurance, PTO, holidays and 401(k) matching. We are an Affirmative Action/Equal Opportunity Employer. We do not discriminate on the basis of race, religion, color, sex, age, national origin or disability.
or
this job portal is powered by CATS

IronArch Technology is an Equal Employment Opportunity (EEO) employer and welcomes all qualified applicants. Applicants will receive fair and impartial consideration without regard to race, sex, color, religion, national origin, age, disability, veteran status, genetic data, religion or other legally protected status