Senior Data Engineer

Northrop Grumman Monterey , CA 93942

Posted 3 days ago

Are you interested in expanding your career through experience and exposure, all while supporting a mission that seeks to ensure the security of our nation and its allies? If so, then Northrop Grumman is the place for you. As a leading global security company, we provide innovative systems, products and solutions to our customers worldwide. We are comprised of diverse professionals that bring different perspectives and ideas, understanding that the more experiences we bring to our work the more innovative we can be. As we continue to build our workforce we look for people that exemplify our core values, leadership characteristics, and approach to innovation.

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 Engineer to 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 U.S. Citizenship is required for most positions.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Data Engineer


Posted 2 weeks ago

VIEW JOBS 4/5/2019 12:00:00 AM 2019-07-04T00:00 Overview Under the direction of Business Intelligence (BI) Manager, the Senior Data Engineer works closely with business leaders, managers, staff and vendor to accurately gather and interpret requirements, specifications. Develop technical specifications and recommend, design, develop, test, implement, and support innovative and optimal data solutions. Serves as a coach and mentor to BI team Responsibilities Lead on all aspects of a modern and flexible SDLC approach, applied to data engineering, analytics and data science efforts Provide business guidance and steer efforts toward desired outcomes; partner with internal stakeholders and external vendors to meet strategic data warehouse goals Research, evaluate and formally recommend third party software and technology package Drive the technical design of large scale data platforms, utilizing modern and open source technologies, in a hybrid cloud environment Set standards for data engineering functions; design templates for the data management which are scalable, repeatable, and simple Defines and develops appropriate controls to monitor quality of the enterprise data warehouse process Set standards for data engineering functions; design templates for the data management which are scalable, repeatable, and simple Preparation of technical specification Perform all other related duties as assigned Qualifications Minimum 9 years' experience in a complex data engineer or similar role; Health Care industry experience highly desired Bachelor's degree in Computer Science or similar or equivalent 8 years of industry experience 3 years paid development experience using Python, PySpark, Spark, Hadoop, Kubernetes highly desired. 3 years hands on experience with SQL and RDBMS systems such as Microsoft SQL Server Deep understanding of how Spark processes data and how workloads are distributed with Kubernetes highly desired. Experience building solutions with NoSQL database. Proficiency and experience in architecting big data platforms on the public cloud highly desired. Experience in implementing a ata architecture with separation between storage and compute preferred. Altamed Monterey Park CA

Senior Data Engineer

Northrop Grumman