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