the smart solution for Reston jobs

Data Warehouse/Database Analyst Modeler

Company: ManTech Advanced Systems International
Location: Reston
Posted on: September 9, 2018

Job Description:

Req ID 101174BR Business Title Data Warehouse/Database Analyst Modeler Group MSS Location USA VIRGINIA Reston Clearance Level Needed None Category Information Technology Job Duties and Responsibilities

ManTech International Corporation is looking to hire experienced and skilled Data Warehouse/Database Analyst Modeler to provide Business Intelligence Support Services to assist the U.S. Government Customs Border Protection(CBP). The chosen candidate will look to effectively and efficiently help to provide analysis in identifying cargo, individuals, conveyances that may present additional risk to the United States. They will conduct terrorism analysis and global assessments that convey changes in terrorism threats and identify emerging threats, develop and evaluate CBP-wide intelligence-based targeting rules and intelligence driven special operations, and coordinate and enhance analysis and target efforts.
The analyst will be responsible for engaging with stakeholders and customers to gather requirements for the design and development of data models and design specifications using star schema techniques; analyze and create Extract-Transform-Load (ETL) specifications. Day to day responsibilities includes:
-- Responsible for data warehouse design and development including conceptual, logical and physical data models, data analysis, data profiling, and ETL design.
-- Working closely with client to assist in managing data needs, and supporting collection of data needed for various operational needs.
-- Data analysis, problem solving, investigation and creative thinking with massive amount of data supporting variety of operational scenarios
-- Respond to data queries/analysis requests from various groups within an organization. Create and publish regularly scheduled and/or ad hoc reports as needed.
-- Responsible for the analysis and design of data marts for the Enterprise Data Warehouse.
-- Analyzing source system data to understand the data structures, definitions and anomalies.
-- Researching and documenting data definitions for all subject areas and primary data sets supporting the core business applications.
-- Support development staff in their implementation of the reports and universes
-- Provide data analysis for understanding and interpreting various operational data for the organization.
-- Analyze and capture meaningful and operationally actionable information from very large scale relational database.

Location based on Customer Preference. Could be in Herndon, VA, Reston, VA or Alexandria, VA. Qualifications -- Bachelor's Degree in Information Technology, Computer Science or a related field is required, Masters preferred.

-- 4-5 years' experience in application development/full life cycle on Data Warehouse engagements

-- At least 3 years' experience in large (80TB+) and complex data warehousing architecture, design and implementation/migration.

-- 3-5+ years of experience in PL-SQL development using Oracle preferably in Exadata environment.

-- Proficiency in SQL programming and query development using SQL Developer or TOAD.

-- Expert knowledge of complex databases in Oracle environment - preferably running on Exadata

-- Experience with relational databases and knowledge of query tools and/or BI tools like Business Objects or OBIEE and data analysis tools.

-- Strong understanding of relational data models supporting transactional systems (OLTP) and dimensional data models.

Knowledge of query optimization and usage of Explain Plan

-- Expert knowledge of aggregating data using complex SQL code. i.e., using functions such as SUM, COUNT, CASE statements, etc.

-- Strong background in data management and analytics.

-- Experience with Big data technology a plus

-- Solid hands on experience with BI tools specifically SAP BO, Informatica and Oracle, Data Analysis, Architecting complex ETL process, Data Mapping, Unit Testing, Migration, and Conversions.

-- Solid Data Modeling skills using Erwin or other comparable tool

-- Experience in full life cycle implementation of data warehouses from gathering detail business requirements and translate them into technical requirements through implementation, data warehouse standards and procedures.

-- Proficiency with Oracle 11G running on Exadata.

-- Must have at least one year of experience with Informatica and SAP BO or OBIEE



-- Advanced knowledge of following technologies

-- Oracle PL-SQL

-- Query Optimization

Additional Qualifications -- Must work well in a team environment as well as independently.

-- Excellent verbal/written communication and problem solving skills; ability to communicate information to a variety of groups at different technical skill levels. Degrees Bachelor's Degree
Master's Degree
Master's Preferred
See Qualifications
Years of Experience 05-07 years w/Bachelors Degree
00-02 years w/Masters Degree
See Qualifications
Position Type Full-Time Shift Day Overview ManTech International Corporation is comprised of approximately 7,300 talented employees who use advanced technology to help government and industry meet some of their greatest challenges around the world. We adhere to the simple, no-nonsense values on which ManTech was founded more than four decades ago, aligning squarely with the mission objectives of our customers. As our customer base continues to expand and diversify, we continue to diversify our workforce and solutions. Nearly half our employees have a military background, and approximately 70 percent hold a government security clearance. As a leading provider of innovative technology services and solutions for the nation's defense, security, health, space, and intelligence communities; we hold nearly 1,100 active contracts with more than 50 different government agencies. - provided by Dice Analysis, Analyst, Architecture, BI Tools, Business Intelligence, Business Objects, Business Requirements, CASE, Data Analysis, Database, Data Modeling, Data Warehouse, Developer, Development, ERwin, Informatica, Management, Modeler, Modeling, OLTP, Oracle, Programming, SAP, Security, SQL, Testing

Keywords: ManTech Advanced Systems International, Reston , Data Warehouse/Database Analyst Modeler, IT / Software / Systems , Reston, Virginia

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Other IT / Software / Systems Jobs

Info Security Eng Sr Princ with Security Clearance
Description: Req ID 100061BR Business Title Info Security Eng Sr Princ Group MCIS Location USA MARYLAND Jessup Clearance Level Needed TS/SCI Category Cyber Job Duties and Responsibilities Become an integral part of (more...)
Company: ManTech International Corporation
Location: Jessup
Posted on: 09/23/2018

Technical Operations and Exploitation Officer with Security Clearance
Description: About Engility: Engility delivers innovative solutions to critical challenges facing the nation and the world. As a premier provider of integrated services for the U.S. government, we support the Department (more...)
Company: Engility
Location: Bethesda
Posted on: 09/22/2018

Electronic Security Systems Administrator with Security Clearance
Description: Tracking Code 2546 Job Description As a leading international services company for more than 65 years, IAP provides a broad spectrum of services and solutions to U.S. and international government agencies, (more...)
Company: IAP World Services, Inc
Location: Bethesda
Posted on: 09/22/2018

Chief Software Engineer with Security Clearance
Description: Raytheon Intelligence, Information and Services IIS is currently seeking a Chief Software Engineer to lead a large, complex program in support of a new effort with the Department of the Army Program (more...)
Company: Raytheon
Location: Springfield
Posted on: 09/22/2018

Software Requirements Analyst Mid with Security Clearance
Description: Job Number: R0031725 Software Requirements Analyst Mid Key Role: Perform as clients' most trusted advisor and essential partner. Serve as an overarching requirements SME and Scrum Master for a portfolio (more...)
Company: Booz Allen Hamilton
Location: Chantilly
Posted on: 09/23/2018

Technical Intelligence Officer (TIO) with Security Clearance
Description: About Engility: Engility delivers innovative solutions to critical challenges facing the nation and the world. As a premier provider of integrated services for the U.S. government, we support the Department (more...)
Company: Engility
Location: Chantilly
Posted on: 09/23/2018

Software Engineer I with Security Clearance
Description: Scientific Research Corporation is an advanced information technology engineering company that provides innovative products and services to government and private industry, as well as independent institutions. (more...)
Company: Scientific Research Corporation
Location: Baltimore
Posted on: 09/22/2018

Software Engineer with Security Clearance
Description: Rivera Group is seeking a senior software engineer who wants to be on the cutting edge of software engineering and has strong creative thinking skills. This position will require a committed individual (more...)
Company: Rivera Group
Location: Laurel
Posted on: 09/23/2018

Senior Programmer/Developer with Security Clearance
Description: OI LLC is looking for a Senior Programmer/Developer to support a DoD customer in Reston, VA. Requirements: -Current
Company: Operational Intelligence LLC
Location: Reston
Posted on: 09/22/2018

Telephony Field Support Specialist with Security Clearance
Description: Req ID 99869BR Business Title Telephony Field Support Specialist Group MCIS Location USA MARYLAND Hanover Clearance Level Needed TS/SCI Category Engineering Support Services Job Duties and Responsibilities (more...)
Company: ManTech International Corporation
Location: Hanover
Posted on: 09/22/2018

Log In or Create An Account

Find us on Facebook

Find us on LinkedIn

Get the latest Virginia jobs by following @recnetVA on Twitter!

Reston RSS job feeds