GCP API Integration Developer (BigQuery, Jira)

Job Summary:
We are seeking a skilled and motivated Software Developer to design, develop, and implement a web service that integrates Jira with Google BigQuery. The primary function of this service will be to retrieve a console name from a specified Jira field, query a BigQuery database to find a list of customers associated with that console, and then populate another Jira field with this customer list. The ideal candidate will have strong experience in web service development, API integration, and working with both Jira and Google Cloud Platform (GCP) services, particularly BigQuery.
Key Responsibilities:

• Design, build, and maintain a robust and scalable web service to connect Jira and Google BigQuery.
• Develop functionality to extract specific data (console name) from Jira issue fields.
• Implement logic to construct and execute optimized SQL queries against Google BigQuery based on the extracted Jira data.
• Process and transform data returned from BigQuery.
• Update Jira issue fields with the processed data (list of customers) via the Jira API.
• Implement secure authentication and authorization mechanisms for accessing both Jira and BigQuery APIs.
• Write clean, well-documented, and testable code.
• Develop and maintain comprehensive documentation for the web service and its integration points.
• Troubleshoot and resolve any issues related to the integration.
• Collaborate with internal teams to understand requirements and ensure the solution meets business needs.
• Stay up-to-date with the latest Jira and GCP technologies and best practices.

Required Skills & Experience:

• Bachelor's degree in Computer Science, Engineering, or a related field, or equivalent practical experience.
• Proven experience in developing web services (e.g., RESTful APIs) using languages such as Python, Java, Node.js, or Go.
• Strong understanding of API design principles and best practices.
• Hands-on experience with the Jira REST API, including reading from and writing to Jira issue fields.
• Proficiency in SQL and experience working with Google BigQuery, including writing complex queries and understanding BigQuery's architecture.
• Experience with Google Cloud Platform (GCP), including authentication (e.g., service accounts, OAuth 2.0).
• Familiarity with data formats such as JSON and XML.
• Understanding of data security and privacy best practices.
• Experience with version control systems (e.g., Git).
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration skills.

Preferred Qualifications:

• Experience with Jira plugin development (e.g., Atlassian Connect or Forge).
• Knowledge of serverless architectures (e.g., Google Cloud Functions, AWS Lambda).
• Experience with CI/CD pipelines and automated testing.
• Familiarity with containerization technologies (e.g., Docker, Kubernetes).
• Understanding of Agile development methodologies.
• Experience with other data warehousing solutions.