Description
You will manage data infrastructure and ETL processes within an AWS environment, focusing on security tooling integrations and reporting frameworks.
This role is remote.
Responsibilities
- Design and execute ETL processes to ingest data from security tooling and corporate sources into standardized structures.
- Develop data pipelines, data warehouses, and reporting frameworks using cloud-native solutions.
- Build data transformations and task automation scripts using Python.
- Update and integrate existing processes that utilize SailPoint.
- Query data for security metrics and reporting using SQL.
Required Skills
- 10+ years of professional experience in data engineering or infrastructure.
- Proficiency in Python for data transformation and automation.
- Hands-on experience with AWS Glue, Athena, and AWS RDS.
- Strong SQL skills, including MS SQL and stored procedures.
- Experience with SailPoint integrations.
- Knowledge of data formats including JSON, XML, and CSV.
- Familiarity with ITIL frameworks including incident, change, and release management.
- Working knowledge of BI tools such as PowerBI, Tableau, and Excel.
Preferred Skills
- Experience using Alteryx for data workflows.