This site uses cookies. To find out more, see our Cookies Policy

Data Warehouse/Database Analyst Modeler in Reston, VA at ManTech

Date Posted: 11/7/2018

Job Snapshot

Job Description

Group: MSS

Clearance Level Needed: Top Secret

Shift: Day

Category: Information Technology

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.

MUST BE A US CITIZEN AND ABLE TO OBTAIN AND MAINTAIN A CBP/BI CLEARANCE. POTENTIAL TO BE SPONSORED FOR A TOP SECRET CLEARANCE.

Job Requirements

• 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

MUST BE A US CITIZEN AND ABLE TO OBTAIN A CBP BACKGROUND INVESTIGATION













Requirements/Qualifications:









• Advanced knowledge of following technologies









• Oracle PL-SQL









• Query Optimization