• Location: McLean , Virginia
• Type: Contract
• Job #3207

Title: Data Integration Engineer
Location: McLean, VA
*Clearance: *Active TS/SCI w/ Polygraph needed to apply *
Company Overview:
Cornerstone Defense is the Employer of Choice within the Intelligence, Defense, and Space communities of the U.S. Government. Realizing early on that our most prized assets are our employees, we continually focus our attention on improving the overall work/life experience they have supporting the mission. Our Team is pushed every day to use their industry leading knowledge to provide end-to-end solutions to combat our nation's toughest and most secure problems. If you are looking for a place to not only be professionally challenged, but encouraged and supported by a company that cares, don't look any further than Cornerstone Defense.

Responsibilities include, but are not limited to:

Assembling large, complex sets of data that meet non-functional and functional business requirements.

Identifying, designing and implementing internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes.

Building required infrastructure for optimal extraction, transformation and loading of data from various data sources using AWS and SQL technologies.

Building analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics including operational efficiency and customer acquisition.

Working with stakeholders including data, design, product and executive teams and assisting them with data-related technical issues.

Establish advanced analysis and data visualization methodologies, models, and tools to derive/predict intelligence outcomes and impacts.

Implement data validation and cleaning techniques to find and fix or remove inaccurate and irrelevant data.

Develop and maintain a data warehouse populated with data from numerous sources and with varied formats.

Build, test, and maintain database pipeline architectures.

Identify ways to improve data reliability, efficiency, and quality.

Data pipeline and warehouse performance measurement and optimization.

Prepare data for predictive and prescriptive modeling in close partnership with in-house data science team.

Deliver updates to stakeholders based on analytics.

Ensure compliance with customer's data governance and security policies.

Design, develop and maintain scaled, automated, user-friendly systems that will support the needs of the business.

Be hands-on with ETL to build data pipeline to support automated reporting.

Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation.

2+ years of relevant work experience in data science or data engineering in big data environments.

2+ years of experience in data mining and data-set preparation using SQL

2+ years of experience using data visualization software, such as, Tableau Desktop or Power BI.

Experience with data modeling, data warehousing, and building ETL pipelines.

Active/Current TS/SCI with polygraph clearance

Bachelor's degree in Computer Science, Engineering, Mathematics or related technical field of study.

3+ years of experience in a data engineer or developer role with a technology company.

Experience working in large data warehouse environments.

Experience conducting large scale and complex data analysis to support data centric architecture

Experience using Python, R, Java, JavaScript, AngularJS, .NET, Hadoop, and Apache or related technologies & tools

Strong verbal and written communication and data presentation skills, including an ability to effectively communicate with both business and technical team, and senior management as required.