• Senior Data Warehouse Developer

    Posted Date 1 month ago(9/18/2019 3:52 PM)
    ID
    2019-40356
    Job Location
    USA-AZ-Scottsdale
    Required Clearance
    No clearance
    Category
    Information Technology
    Employment Type
    Full Time
    Hiring Company
    General Dynamics Mission Systems
  • Basic Qualifications

    Bachelor's degree in Engineering, a related specialized area or field is required (or equivalent experience) plus a minimum of 8 years of relevant experience; or Master's degree plus a minimum of 6 years of relevant experience.

     

    Due to the nature of work performed at our facilities, US citizenship is required.

    Responsibilities for this Position

    Senior Data Warehouse Developer

     

    General Dynamics Mission Systems has an immediate opening for a Senior Data Warehouse Developer.  This position provides an opportunity to further advance the cutting-edge technology that supports some of our nation’s core defense/intelligence services and systems by consolidating disparate data sources across multiple departments into one centralized Enterprise Data Warehouse to enhance the critical decision making abilities of the entire organization.  This role will leverage technical expertise in data warehouse concepts, database and developed applications, reporting technologies, ETL processes, and process automation.

     

    REPRESENTATIVE DUTIES AND TASKS: 

    • Consults and collaborates with business leaders, end user, IT staff, and other third parties in the development and implementation of the Enterprise Data Warehouse
    • Consolidate and migrate multiple Oracle and SQL Server data marts into one enterprise level data warehouse
    • Develop complex data extracts, ETL and stored procedures as required to implement the data warehouse strategy and support existing BI/Business Analytics team
    • Drive continuous improvement through data as an IT advocate to business leaders
    • Research, troubleshoot, and resolve data issues impacting Data Warehouse delivery
    • Optimize large complicated SQL statements, procedures, and functions
    • Collaborate on the definition, development, and maintenance of standards and processes relating to the enterprise data landscape at GD
    • Collaborate with a team of IT professionals to set data specifications for new applications and analytics development

     

     

    KNOWLEDGE SKILLS AND ABILITIES: 

    • 8+ Years of hands-on development in Database and/or Data Warehouse environments with focus on Data Integration (ETL)
    • 8+ Years of focused experience in developing Data Warehouse and ETL in SQL Server or Oracle databases and ETL environment
    • Expert level demonstrated experience in full data warehouse implementation
    • Proficient with SQL, Complex SQL Tuning, Stored Procedures, SQL Server Data Warehousing or Oracle best practices etc.
    • Collaboration across multiple teams to research, architect, engineer and configure complex database solutions
    • Document database designs, solutions, configurations, and teach/mentor other support tiers, team members and vendors including onboarding and knowledge transfer
    • Ability to advice senior IT management on Data Warehouse and ETL trends
    • Demonstrated understanding of business stakeholder requirements, gain a thorough understanding of their desired business outcomes, and how they translate to data structures in a warehouse
    • Evidence of ability to act highly independently on large and unique tasks and wide-ranging initiatives
    • Strong organizational skills including: superior ability to lead initiatives and cross functional projects; a facility to handle multiple tasks and deliverables simultaneously; a track record of exercising independent judgment appropriately; and the ability to quickly understand and execute complex assignments when working on high profile outcomes with inherent risk
    • Strong experience developing solutions to extremely complex, cross-domain, problems requiring significant business acumen, technical knowledge, ingenuity, creativity, and innovation

    Company Overview

    General Dynamics Mission Systems (GDMS) engineers a diverse portfolio of high technology solutions, products and services that enable customers to successfully execute missions across all domains of operation.  With a global team of 13,000+ top professionals, we partner with the best in industry to expand the bounds of innovation in the defense and scientific arenas.  Given the nature of our work and who we are, we value trust, honesty, alignment and transparency.  We offer highly competitive benefits and pride ourselves in being a great place to work with a shared sense of purpose.  You will also enjoy a flexible work environment where contributions are recognized and rewarded.  If who we are and what we do resonates with you, we invite you to join our high performance team!

     

    General Dynamics is an Equal Opportunity/Affirmative Action Employer that is committed to hiring a diverse and talented workforce.  EOE/Disability/Veteran

    Apply

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed