Senior Big Data - Data Modeler, Secret Clearance!

American Systems Chantilly , VA 20151

Posted 2 months ago

WANTED: a Data Modeler with a Secret Clearance!

As a Data Modeler, you will:

  • Provide critical support to National Priority programs

  • Receive a competitive compensation and benefits package, to include our Employee Stock Ownership Plan!

  • Be part of an empowered culture where you are a key contributor to the success of the company

  • Join a team of highly skilled, driven, and supportive professionals

  • Continue growing your technical skills and knowledge

A week in the life of a Data Modeler:

  • Work with a small team and be responsible to the Data Architect for development/implementation of a new Department of Defense (DoD) project in an Amazon Web Services (AWS) environment.

  • Perform modeling and mapping data transitions (full migrations, batch/real-time ETL) from Legacy SQL (Oracle, SQL Server, etc.) to Big Data unstructured database models.

  • Provide hands-on relational and analytic experience (using RDBMS and unstructured data platform technologies, and ETL and data ingestion protocols).

Founded in 1975, AMERICAN SYSTEMS is one of the largest employee-owned companies in the United States. We are a government services contractor focused on delivering Strategic Solutions to complex national priority programs with 100+ locations worldwide. Our employee-owners are encouraged to make a difference, implement new ideas in a collaborative environment, and focus on mission critical success. Through our focus on quality, strong cultural beliefs and innovation we deliver excellence every day. AWARDED BEST OF THE BEST by U.S. Veterans Magazine and TOP 10 MILITARY FRIENDLY COMPANY by MilitaryFriendly.com, Join us!

Job Requirements

Required Knowledge, Skills and Abilities:

  • Modeling experience with Big Data unstructured databases (e.g. NoSQL, AWS DynamoDB, MongoDB, or CouchbaseDB) as well as SQL Databases (e.g. Oracle, PostgreSQL)

  • Knowledge of state-of-the-art software engineering tools and methodologies related to NoSQL databases. Particularly in the AWS environment

  • Experience utilizing data modeling tools (e.g. erwin Data Modeler, Hackolade) with unstructured databases

  • Experience with data warehouse, data lake, and enterprise big data platforms

  • Must be able to work individually or as a team member with minimum supervision

  • Ability to blend creativity, problem solving, and technical skills for refining existing process or developing new approaches

  • Ability to establish and maintain a high level of customer trust and confidence

Highly Desirable Knowledge, Skills and Abilities:

  • Experience with the DoD Socium project

  • Experience with PostgreSQL

  • AWS Certification: Associate Level (Solutions Architect or Developer) with Big Data specialty

  • Previous experience as a database developer

Training and Experience:

  • 3+ years working with SQL and unstructured databases as a data architect, modeler, or developer

  • Secret Clearance (SSBI) or Top Secret Clearanc

  • DoD 8570 IAT II Certification (e.g. Security +)

EOE M/F/Disability/Veterans


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Data Engineer Big Data Warehouse Integrator

Proven Staffing Solutions

Posted 3 days ago

VIEW JOBS 1/16/2020 8:33:07 AM 2020-04-15T08:33 <b>Job Title</b>: Data Engineer - Big Data Warehouse Integrator<br /> <b>Clearance</b>: TS/SCI<br /> <b>Location</b>: Chantilly, VA<br /> <b>Compensation</b>: Excellent Benefits and Salary<br /> <br /> <b>Job Description:</b><br /> As part of a technology architecture team, Candidate will support a DIA sponsored project in support of functional correlation to each of the main data collection and delivery functions.  As the project grows and becomes integrated across operational and tactical elements of the DoD, this team will identify established capabilities that can meet use cases as well as missing capabilities that need to be added in order to provide common data usage models.  Successful candidate will identify "Value" data and create a strategy for integration into the warehouse that includes transforming data into community standard formats and common relational or other structured stores.<br />  <br /> <b>Required:</b> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">3 years experience handling data transformation</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"> Experience with information transformation in preparation for delivery</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"> Understanding of commercial data wrangling and normalization tools</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Experience in configuration management associated with transformation processes</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"> Understanding of scaling for transformation processes</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"> Ability to integrate customer workflow into work products</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Knowledge of DOD standards</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Excellent communication and collaboration skills</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">BSc/BA in computer science or relevant field or 5 years industry experience</li> </ul> Also, candidate should have a working knowledge of the following:<br />  <br /> <b>Data</b> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Identifies unique datasets within applications</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Captures formatting</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Identifies expected volumetrics</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Identifies all current sharing mechanisms</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Makes initial recommendations on polyglot storage for each dataset</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Identifies expected resource needs for each dataset</li> </ul> <b>Application</b> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Identification of datasets </li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Identify transfer mechanisms in existence today</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Characterize API's in order to verify CAN (controller area network) support</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Identifies changes that need to be made in order to remove user identity requirements for access by other systems</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Provides guidance on integration tasks regarding API's and ingest  </li> </ul> <b>Mission</b> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Network capacity between sites and mission partners</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Bandwidth utilization</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Cross domain</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Evaluates information to determine nearest node usage and failover / COOP</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Identifies changes that need to occur in the data architecture to ensure no operational impact to warfighters during integration</li> </ul> <b>Desired:</b> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Familiarity with DoD, military and intelligence operations</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Demonstrated ability to decompose a complex problem into an executable plan</li> </ul>  <br /> <strong>Benefit Summary:</strong><br /> Volant Associates provides an industry-leading benefits package to attract and retain the very best talent within a very competitive recruiting environment and support its employees and their dependents.<br /> <br /> <u>100% Volant Paid Standard Benefits:</u> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">200% Matching on employee 401k contributions (on up to 5% of employee salary deferral)</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">20.5 days (164 hours) of Paid Time Off </li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">7 paid holidays per year</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Health care insurance for employee and dependents thru UHC</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Dental care insurance for employee and dependents thru UHC</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Vision care insurance for employee and dependents thru VSP</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Life and Personal Accident Insurance ($50k coverage) thru CIGNA</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Additional Life and Personal Accident Insurance (1 x salary up to $170k) thru MOO</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Short term disability Insurance (60% of earnings up to $2,308 per week) thru CIGNA</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Long term disability insurance (60% of earnings up to $10k per month) thru CIGNA</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Educational assistance (up to $3,500 per calendar year)</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Adoption assistance</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Commuter benefits</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Training and development opportunities</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Cell phone stipend (up to $50 per month)</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Corporate laptop computer</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Gym access (for Chantilly-based employees)</li> </ul> <strong>Additional programs available to all employees:</strong> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Heath Savings Account (HSA)</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Health care Flexible Spending Account (FSA)</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Dependent care Flexible Spending Account (FSA)</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Voluntary additional levels of Life and Personal Accident Insurance</li> </ul> Proven Staffing Solutions Chantilly VA

Senior Big Data - Data Modeler, Secret Clearance!

American Systems