This Position Requires **Active Secret Clearance**
Senior Level Database Analyst
This Database Analyst will have a strong knowledge of relational database, data warehouse (dimensions/facts) and operational data store design concepts. Their experience will be utilized supporting business intelligence solutions/applications and experience in managing large data environments. They will be responsible for writing and tuning complex queries using SQL/PL SQL. They will be working to design and create stored procedures, triggers, views and indexes. They will have experience in database administration including performance tuning, environment availability, and capacity planning. Working knowledge of SQL best practices (e.g. schema management, index optimization, etc.). They will be developing conceptual, logical and physical data models and, using experience with ErWin.
Experience Required: Approximately 5 years of work related experience, 4 years if holding a graduate degree. External client delivery and solution knowledge spanning data management, data warehousing and reporting/analytics domains. A minimum of 4-years of experience in providing complex consultative services in the following ISM focus areas: information strategy, data architecture, information/data governance, master data management, data quality, data integration. Desktop and server development and integration with very large (10s of TB) Oracle RDBMS, SQL/PL SQL. Informatica PowerCenter (v9 and above) - creating mappings, transformations, sessions, and workflows.