Northrop Grumman Senior Data Engineer in Monterey, California

At Northrop Grumman, innovation isn't just an idea----its a way of life. Our employees have incredible opportunities to work on revolutionary systems in air and space that impact peoples lives around the world today, and for generations to come. Our work preserves freedom and democracy, and advances human discovery and our understanding of the universe.

We look for people who have bold new ideas, courage and a pioneering spirit to join forces to invent the future. Northrop Grumman is seeking a Senior Data Engineerto become part of Northrop Grumman's organization supporting the Army Analytics Group's Research Facilitation Laboratory located in Monterey, California.

Roles and Responsibilities:

  • Gather and document data, user, and system business requirements

  • Produce comprehensive and usable technical and business database specifications

  • Lead the data analysis and development efforts for new client implementations and system enhancements

  • Maintain and optimize ETL configuration and baseline

  • Troubleshoot issues with ETL connections, performance, or other errors

  • Update, compile, test, and deploy changes in response to problem reports

  • Develop, test, and deploy ETL modifications based on new customer requirements

  • Execute and monitor ETL processes to ensure all components function properly

  • Communicate with clients, developers and other team members

  • Interface with vendor technical resources to resolve data transfer issues

  • Replace existing manual processes with automated and more reliable versions

  • Mentor and provide technical guidance to junior members of the team

Basic Qualifications:

  • Bachelor's degree in Engineering, Computer Science, Information Systems, Applied Mathematics or other scientific/technical discipline and a minimum of 14 years of industry experience

  • 2+ years of relevant technology architecture consulting or industry experience

  • Experience with ETL concepts and tools

  • Experience with data dictionaries, data analysis, data warehousing, and relational databases

  • Understand the benefits of data warehousing, data architecture, data quality processes, data warehousing design and implementation, table structure, fact and dimension tables, logical and physical database design, data modeling, reporting process metadata, and ETL processes

  • Experience defining a data warehouse solution, multidimensional model, logical and physical models design, data types, staging process and its benefits, and different data warehouse design approaches and schemas

  • Familiarity with Oracle 11g/12c/18c

  • 2 years of experience designing and executing complex data queries utilizing diverse data sources as well as both structured and unstructured data

  • 2+ years of strong programming/development skill using PL/SQL (package, procedures, functions, triggers) and batch coding skills such as Bulk collections, dynamic SQL, and parallel processing

  • Ability to hold a DoD Secret Clearance (US Citizenship is required)

Preferred Qualifications:

  • Detail driven and possesses an intellectual curiosity to go deeper into data

  • Ability to work on several complex projects with general direction and minimal guidance

  • Ability to develop professional relationships

  • Strong oral and written communication skills, including presentation skills

  • Knowledge of Microsoft Visio, Team Foundation Server, Project and Office

  • Strong expertise in an object oriented language (e.g. Python or Java)

  • Experience with big data tools such as Hadoop, Hive, Spark, etc.

  • Experience delivering data pipelines and managing resulting data stores using managed cloud services

  • Knowledge of machine learning tools and concepts

  • Experience supporting and/or migrating data from other sources

  • 2+ years of experience with software development methodologies including Agile delivery

  • 1+ years of hands on experience with Informatica PowerCenter and/or other tools such as Amazon Redshift, SQL Server Integration Services (SSIS), SAP Data Services, SAP BW/HANA, SAS Data Management, Oracle Warehouse Builder and Oracle Data Integrator (ODI) SAP Data Services

  • Experience in developing logical and physical data models using data modeling tools such as Rational Data Architect, Erwin, Oracle Developer, other tools

Northrop Grumman is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Opportunity/Affirmative Action Employer, making decisions without regard to race, color, religion, creed, sex, sexual orientation, gender identity, marital status, national origin, age, veteran status, disability, or any other protected class. For our complete EEO/AA and Pay Transparency statement, please visit www.northropgrumman.com/EEO . U.S. Citizenship is required for most positions.