Title: Cyber Security Data Engineer – Senior
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.
Cyber Security Data Engineer:
The Cyber Security Data Engineer will design, build, and optimize systems for data collection, storage, access, and analytics at scale, and is responsible for creating data pipelines used by data scientists, data-centric applications, and other data consumers. This is a highly technical position, requiring experience and skills in areas such as programming, mathematics, and computer science.
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.
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.
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.
Active 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 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 and other related technologies
Equal Opportunity Employment
Cornerstone Defense is proud to be an Equal Opportunity Employer. We are committed to creating an inclusive working environment for all employees and to upholding diversity in our recruiting and hiring processes. All qualified applicants will receive equal consideration for employment without regard to sex, gender identity, sexual orientation, race, color, age, religion, national origin, physical or mental disability, protected Veteran status, or any other characteristic protected by law.