Description
You will manage data infrastructure and ETL processes within an AWS environment.
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.
- Update and integrate existing processes that utilize SailPoint.
- Build data transformations and task automation scripts using Python.
- Use SQL to query data for security metrics and reporting.
Required Skills
- 10+ years of professional experience.
- 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.
- Experience with cloud-native data management.
- 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.