BAE Systems Data Warehouse Developer (Oracle, SQL Server) in Reston, Virginia

Job Description

BAE Systems is looking for a Senior Data Warehouse Developer with experience supporting large enterprise data warehouse/ analytics data-driven environment. This rolewill participate in all aspects of the development lifecycle from scoping and requirements through implementation and support. The Data Warehouse Developer will be contribute to the evolution of the processes and standards necessary to enable the development team to deliver quality, compliant, and timely solutions.

Typical Education & Experience

Typically a Bachelor's Degree and 6 years work experience or equivalent experience

Required Skills and Education

Technical Skills:

  • 4 years expertise with OWB and ODI

  • Strong experience with migrating from OWB to ODI

  • 5 years experience with DW design methodologies - Dimensional and relational

  • Strong foundation of dimensional data models and data warehouse design, with experience in developing both star schema and 3NF data marts

  • Must be able to design and modify database structures using established data warehouse rules and best practices, and provide documentation of new and modified system designs

  • 5 years of experience with SQL and PL/SQL, SQL query tuning, database performance tuning,

  • Exceptional Oracle SQL skills and PL/SQL skills

  • Experience in writing complicated SQLs, analyzing query performance, query tuning, database indexes/partitions, stored procedure development, data modeling on Oracle

  • Proficiency with Linux and shell scripting

  • Experience working with a large, multi-terabyte data warehouse

  • Experience in requirements analysis and system design

  • Proactively manage system uptime and incident resolutions

  • Is able to work in a 24x7 environment which requires on-call rotation

  • 5 years of experience in database architecture and development including analyzing, designing, documenting, coding, testing and implementing primarily SQL code

  • Define and enforce data warehouse best practices design and data integrity

  • Equally adept at working in Oracle and SQL Server environments using PL-SQL and/or T-SQL

Soft Skills:

  • Ability to communicate effectively and in a professional manner both written and orally

  • Be a team player with a positive attitude, enthusiasm, initiative, and self-motivation

  • Ability to multi-task and meet aggressive timelines

  • A strong work ethic and ability to self-start

  • A strong team player mentality with proven ability to work effectively cross-functionally

  • Strong organizational and multi-tasking skills

  • Ability to evaluate and learn new technologies quickly

  • Strong attention to detail and accuracy

  • The candidate should have a demonstrable record of being able to interact effectively with business stakeholders at all levels in all functional areas to gather and understand business requirements and data warehousing needs

Preferred Skills and Education

Bachelor's degree in Management Information Systems, Information Technology, Computer Science or related technical disciplines.

About BAE Systems, Inc.

BAE Systems is a premier global defense and security company with approximately 90,000 employees delivering a full range of products and services for air, land and naval forces, as well as advanced electronics, security, information technology solutions and customer support and services. People are the greatest asset in any Company. BAE Systems is committed to hiring and retaining a diverse workforce. Equal Opportunity Employer/Females/Minorities/Veterans/Disabled/Sexual Orientation/Gender Identity/Gender Expression

Data Warehouse Developer (Oracle, SQL Server)

BAE1US21276

EEO Career Site Equal Opportunity Employer. Minorities . females . veterans . individuals with disabilities . sexual orientation . gender identity . gender expression