Note: The job is a remote job and is open to candidates in USA. Lafayette Group is seeking experienced professionals to provide advanced consulting support for federal cybersecurity programs. The Senior Data Engineer (Power BI & Python) is responsible for designing and maintaining data pipelines, optimizing data storage, and delivering high-quality data products to improve federal and national risk insights.
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
Skills
- Bachelor's degree in computer science, information systems management, mathematics, engineering, or other relevant discipline. Masters' degree preferred
- 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
Company Overview