Data Warehouse Developer


Job Description
BAE Systems, Inc. is looking for a seasoned Data Warehouse (DW) Developer. The ideal candidate would have extensive experience developing and supporting a DW service comprised of multiple Data Warehouses and ETL applications. This role will participate in all aspects of the development lifecycle, from scoping and requirements to implementation and support. The Principal Data Warehouse Developer will contribute to the evolution of the processes and standards necessary to enable the development team to deliver quality, compliant, and timely solutions. The right candidate will have in-depth experience with DW tools, ETL process, Database Management Systems (DBMS) - relational and dimensional, and an innovative/energetic mindset focused on delivering business value through collecting, organizing, structuring and storing data as a strategic asset. Additionally, the candidate must possess exceptional written and verbal communication skills.

Major Responsibilities:
  • Management of multiple Data Warehousing tools, including Oracle Data Integrator (ODI), Microsoft SQL Server Integration Service (SSIS), etc.
  • Oversight of daily operations and maintenance, including system/content administration, server administration, data modeling (conceptual, logical, physical), change management, configuration management and all other applicable IT controls
  • Focus on successful delivery of O&M initiatives and Projects
  • Support development of technology Roadmaps - exploring unused capabilities of existing products as well as new products in the marketplace
  • Ensure Service Requests, Incidents, Application Availability, Project Delivery and Customer Satisfaction are addressed within Service Level Objectives
  • On-going maintenance of service documentation - e.g. Business Continuity /Disaster Recovery Plans, Architecture, Procedures, etc.
  • Ensure compliance with Defense Federal Acquisition Regulations Supplement (DFARS) requirements and adhere to defined corporate IT policies, procedures and guidelines (e.g. patching, upgrades, etc.)
  • Proactive identification and remediation of process gaps
  • Assist Data Warehouse Manager with forecasting demand, understand scope and requirements, and deliver as committed
  • Proactive monitoring of environments to reduce service disruptions - e.g. failed jobs, system performance, capacity, etc.
  • Mentor and lead junior developers
  • Design, develop, implement, and manage Interface/ETL framework for data movement through the enterprise
  • Acquire data from primary or secondary data sources
  • Identify, analyze, and interpret trends or patterns in complex data sets
  • Innovate new ways of managing, transforming and validating data
  • Establish and enforce guidelines to ensure consistency, quality and completeness of data assets
  • Apply quality assurance best practices to all work products
  • Analyze, design and code business-related solutions, as well as core architectural changes, using an Agile programming approach resulting in software delivered on time and in budget
  • Communicate risks or issues stemming from projects or tickets to core teams as well as assigned technical delivery managers
  • Develop solutions using scripting languages such as Jython, Groovy and/or Shell Scripting
  • Serve as expert resource within and across technology teams on matters related to DBMS technologies.
  • Coordinate with system DBAs and Change Management staff in the implementation of changes to database environments.
  • Manage existing data models and create/modify models to meet new functional requirements.
  • Generate and maintain data dictionaries.
  • Work with business analysts and various groups to collect requirements and translate those into logical database models
  • Troubleshoot problems reported by clients. Identify potential performance and process improvements


Required Education, Experience, & Skills
  • Bachelor's Degree in Computer Science, Computer Engineering, Information Technology or other related field
  • 12+ years overall experience in the IT field
  • 8+ relevant experience of working in a Data Warehousing field
  • 4+ years of experience using Oracle ODI 12c
  • 5+ years of experience with managing all aspects of Data Warehousing service and infrastructure - ETL development, Data cleansing/curation, data modeling, data archiving, installations, upgrades, patching, customizing, automating, etc.
  • 5+ years of experience with developing and managing PL/SQL packages, writing SQL queries - Oracle (SQL Server a plus) platforms; query performance tuning and advanced analytic functions.
  • Demonstrated independent problem solving skills and the ability to develop solutions to complex analytical/data-driven problems
  • Architect and design Enterprise Data Warehousing solutions - strong understanding of DW needs and propensity to develop and deliver solutions to improve operational efficiency
  • Ability to articulate, both verbally and in writing, in a clear, concise and professional manner.
  • Aptitude for working effectively under pressure, managing multiple priorities simultaneously, and working without direct supervision.
  • Must be comfortable dealing with changing priorities and timelines.
  • High attention to detail


Preferred Education, Experience, & Skills
  • Experience with Microsoft cloud DW technologies - Azure Synapse, Data Factory, Data Bricks, etc. Experience with Amazon AWS, Snowflake, Spark, NoSQL, etc. databases a plus.
  • Ability to influence others
  • Experience with Agile Project Management a plus
  • Experience with ServiceNow a plus


About BAE Systems, Inc.
BAE Systems, Inc. is the U.S. subsidiary of BAE Systems plc, an international defense, aerospace and security company which delivers 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 services. Improving the future and protecting lives is an ambitious mission, but it's what we do at BAE Systems. Working here means using your passion and ingenuity where it counts - defending national security with breakthrough technology, superior products, and intelligence solutions. As you develop the latest technology and defend national security, you will continually hone your skills on a team-making a big impact on a global scale. At BAE Systems, you'll find a rewarding career that truly makes a difference.

At BAE Systems, we celebrate the array of skills, experiences, and perspectives our employees bring to the table. For us, differences are a source of strength. We're laser-focused on high performance, and we work hard every day to nurture an inclusive culture where all employees can innovate and thrive. Here, you will not only build your career, but you will also enjoy work-life balance, uncover new experiences, and collaborate with passionate colleagues.