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.

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

Requirements:

• Bachelor's 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
• Experience with data validation/testing frameworks
• High-level understanding of Power BI consumption needs and data formats
• Ability to obtain and maintain DHS Suitability (EOD)
• Prior consulting or program support experience with DHS, CISA, or other federal cybersecurity organizations