Description

You will design, build, and support ETL pipelines to extract, transform, and load data from multiple Jira source repositories into a target instance and Snowflake.

This role is on-site.

Responsibilities

• Ingest Jira data from APIs, database extracts, and CSV/JSON/XML files.
• Transform and normalize Jira entities, including issues, users, and workflows.
• Implement deduplication logic to identify and merge duplicate records across repositories.
• Archive source data into Snowflake using structured, queryable data models.
• Build reusable ETL scripts, jobs, and data quality checks while troubleshooting load failures.

Required Skills

• Strong ETL development experience with Python, SQL, or platforms like Informatica, Talend, Matillion, dbt, Airflow, or Azure Data Factory.
• Proficient in Snowflake for data storage, archival, and analytical queries.
• Deep understanding of Jira data structures, APIs, and exports.
• Experience with data normalization, deduplication, merge rules, and survivorship logic.
• Strong SQL skills for profiling, transformation, reconciliation, and validation.
• Ability to handle semi-structured data formats (JSON, XML, CSV) and large data volumes.
• 5+ years of relevant experience.

Preferred Skills

• Experience with Jira Cloud, Data Center, or Service Management migrations.
• Familiarity with Azure or AWS cloud platforms.

Key Skills

Education

Bachelor's degree