Job Description
Summary
HII - Technical Solutions Division is seeking a Sr. Database Engineer to join the Business Intelligence / Data Warehouse team in developing advanced solutions for the customer. This person can work remotely from anywhere in the U.S. Hours for this position will be regular work day hours no matter the time zone.
This team provides DoD decision-makers with actionable data so this person will need to have experience in developing and maintaining data warehouses. This person will not be a database architect but rather a member of an established database engineering team.
What you will do
- Work with business analysts to determine database and data processing requirements.
- Design, build, and test data processing programs.
- Contribute to architecture, code, and program reviews.
Want more jobs like this?
Get Data and Analytics jobs in Fairfax, VA delivered to your inbox every week.
What you must have
- 9+ years relevant experience with Bachelors in related field; 7 years relevant experience with Masters in related field
- Bachelor's degree is required, preferably in computer science, information systems, or engineering program.
- Minimum 10 years of experience in systems analysis, quality assurance, and/or engineering support in data-intensive software engineering environments, with at least 8 years of specialized experience in data warehousing.
- Work experience in writing complex SQL queries to manipulate and extract data from Microsoft SQL Server, and in building stored procedures and views.
- Experience required in designing, modeling, and building Extract Transform and Load (ETL) data flow processes (preferably in SSIS) from data extraction, through source, staging, relational, and dimensional databases.
- Demonstrated experience in and commitment to developing under a formal software development process as part of a collaborative team is expected.
- Proven capacity to be productive while working remotely from the rest of the team.
- CLEARANCE: Must have an active SECRET security clearance.
Bonus points for
- In-depth knowledge of semantic layer design and development (such as OLAP cube or similar in a BI tool).
- Experience modeling dimensional databases.
- Demonstrated experience with HIPAA requirements.
- Knowledge of operating system internals, database backup and replication, middleware, web interfaces, and client tools.
This opportunity resides with Defense & Federal Solutions, a business group within Huntington Ingalls Industries' Technical Solutions division, helps solve tough national security challenges for the Department of Defense, the intelligence community and federal civilian agencies. Our expert capabilities include intelligence, surveillance and reconnaissance (ISR), and cyber; secure enterprise IT engineering and operations; military training and simulation; logistics management and integrated product support; and fleet maintenance, modernization, repair and sustainment.
Huntington Ingalls Industries is America's largest military shipbuilding company and a provider of professional services to partners in government and industry. For more than a century, HII's Newport News and Ingalls shipbuilding divisions in Virginia and Mississippi have built more ships in more ship classes than any other U.S. naval shipbuilder. HII's Technical Solutions division supports national security missions around the globe with unmanned systems, nuclear and environmental services, and defense and federal solutions. Headquartered in Newport News, Virginia, HII employs more than 42,000 people operating both domestically and internationally. For more information, visit: www.huntingtoningalls.com .
Huntington Ingalls Industries is an Equal Opportunity/Vets and Disabled Employer. U.S. Citizenship may be required for certain positions.