onsite
Data Engineer - Guidehouse Careers
Data Engineer
Data Engineer role focused on building scalable data pipelines, integrating cloud platforms, and delivering analytics solutions using Python, SQL, ETL tools, and modern data warehouses.
About the role
Key Responsibilities
- Design, develop, and maintain robust data pipelines to ingest, transform, and load large‑scale datasets from diverse sources.
- Implement cloud‑based data solutions on AWS, leveraging services such as S3, Redshift, and Glue.
- Build and optimize data models in Snowflake or similar data warehouses to support analytics and reporting.
- Automate workflow orchestration using Apache Airflow, ensuring reliable scheduling and monitoring of ETL jobs.
- Collaborate with data scientists and business analysts to provide clean, well‑documented data sets for machine‑learning and visualization projects.
- Apply best practices for data security, governance, and performance tuning in a defense‑focused environment.
Requirements
- 3+ years of hands‑on experience in data engineering, preferably in consulting or government sectors.
- Proficiency in Python and SQL for data manipulation and scripting.
- Strong background with ETL frameworks and cloud platforms, especially AWS and Snowflake.
- Experience with workflow orchestration tools such as Apache Airflow.
- Ability to translate business requirements into scalable data solutions and communicate technical concepts to non‑technical stakeholders.
Skills
pythonsqlawssnowflake