Lafayette Group · 18 hours ago
Cybersecurity Analytics Engineer
Lafayette Group is seeking experienced professionals to provide advanced consulting support for federal cybersecurity programs. The Cybersecurity Analytics Engineer will provide thought-leadership, technical support, and data analytics services across a broad portfolio of cybersecurity and risk management programs.
AssociationCyber SecurityGovernmentInformation Technology
Responsibilities
Design, build, and maintain modular, maintainable data pipelines for data ingestion and transformation in Python
Develop and maintain data pipelines for analytics and reporting in Python, SQL, or Power Query
Optimize data storage and retrieval by leveraging Paraquets columnar format using Python
Utilize Jupyter Notebooks to accomplish tasks such as exploratory data analysis, prototyping data transformations, and validating data pipeline outputs
Query data using Python and SQL to support ad-hoc business requests and identify actionable insights
Work with diverse data formats including relational databases, structured files, and unstructured data
Analyze and manage diverse data sets to improve federal and national risk insights; understand how partner organizations receive and use information from the client to drive down cyber risk
Develop and deliver high-quality products (e.g., reports, briefings, demos, presentations) for data projects, tailored to the stakeholder audience
Provide reports that organize data analysis in a consumable format for stakeholders, including interactive data visualizations and infographics
Provide advice and guidance on data analysis, processing, and data cleansing activities using innovative tools and approaches to organize qualitative and quantitative data for analysis
Ability to take initiative and work independently while maintaining excellent communication with project leadership
Qualification
Required
Bachelor's or Masters' degree in computer science, information systems management, mathematics, engineering, or other relevant discipline
6+ years of professional experience in business intelligence, data analytics, or similar roles
Advanced Python skills for building modular, maintainable ETL pipelines purely in Python
Experience with Jupyter Notebooks
Experience writing and reading Parquet files using Pandas and PyArrow or FastParquet
Ability to understand and translate SQL/Postgres-based logic into Python-based workflows
Ability to work with a variety of structured and unstructured data formats
Strong grasp of data architecture and performance optimization (partitioning, compression, schema design)
Experience collaborating with BI teams to deliver data models that meet reporting requirements
Ability to query created data and provide ad-hoc reporting
Possession of excellent oral and written communication skills; demonstrated ability to clearly communicate technical concepts to both technical and non-technical users
Preferred
Experience with data validation/testing frameworks
High-level understanding of Power BI consumption needs and data formats
US citizenship with the ability to obtain and maintain DHS Suitability (EOD)
Prior consulting or program support experience with DHS, CISA, or other federal cybersecurity organizations
Company
Lafayette Group
Lafayette Group focus on the public safety and national security needs of Federal, State, and local government agencies.