ETL SPECIALIST — JIRA DATA MIGRATION / SNOWFLAKE ARCHIVAL

ETL SPECIALIST — JIRA DATA MIGRATION / SNOWFLAKE ARCHIVAL PROJECT DESCRIPTION Seeking an experienced ETL Specialist to support a Jira data migration initiative involving multiple source repositories being consolidated into a single staging Jira repository and loaded into a newly configured Jira environment. The role focuses on data extraction, transformation, normalization, deduplication, and loading, along with archival of source data into Snowflake for long-term reporting and audit needs. MANDATORY SKILLS Strong ETL development experience with Python, SQL, Snowflake, Informatica, Talend, dbt, Airflow, Azure Data Factory, or similar platforms Strong SQL skills for profiling, transformation, reconciliation, and validation Experience with Snowflake for data storage, archival, reporting, and analytical queries Experience with Jira data structures, Jira APIs, or similar enterprise ticketing/work management platforms Experience with data normalization, deduplication, merge rules, survivorship logic, and master-data-style matching Strong understanding of batch data processing, error handling, logging, and restartability Ability to work with semi-structured data formats — JSON, XML, and CSV Experience handling large data volumes and complex source-to-target mappings NICE-TO-HAVE SKILLS Experience with Jira Cloud, Jira Data Center, or Jira Service Management migrations Experience using Atlassian REST APIs Experience with Python libraries — pandas, requests, SQLAlchemy, PySpark, or Snowpark Experience with data governance, lineage, auditability, and archival strategies Experience with Azure, AWS, or cloud-based data platforms Familiarity with Agile delivery, sprint planning, and migration cutover activities