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