Software Application Engineer II

The Software Application Engineer II will help design and implement solutions to extract data from different sources like Salesforce, Jira, NetSuite, Logisense using API’s/Python in Google Cloud Platform (GCP) using data pipelines and ensure seamless access to data for business intelligence and data science tools. They will support a wide range of projects while collaborating closely with management teams and business leaders. The ideal candidate will have a strong understanding of data extraction, data warehousing concepts, and the ability to document technical knowledge into clear processes and procedures.

Include following language: This position is based out of one of the offices of our affiliate Acqueon Technologies in India, and will adopt the hybrid work arrangements of that location. You will be a member of the Acqueon team with responsibilities supporting Five9 products, collaborating with global teammates based primarily in the United States.

Responsibilities

• Work closely with different team members in finance team to understand the business requirement and prepare data sets for data analysis.
• Design, implement, and maintain a scalable Data extraction in GCP to structured and unstructured data from various sources (databases, APIs, cloud storage).
• Utilize GCP services including Big Query, Dataflow, Pub/Sub, Cloud Run Functions, Airflow and Cloud Storage to optimize and manage data workflows, ensuring scalability, performance, and security
• Continuously monitor, test, and optimize data workflows to improve performance, cost efficiency, and reliability.
• Maintain comprehensive technical documentation of data pipelines, systems, and architecture for knowledge sharing and future development.
• Enhancing applications by identifying opportunities for improvement, making recommendations and designing and implementing systems.
• Provides information by collecting, analyzing, and summarizing development and service issues.
• Ability to work across multiple facets of a project and juggle multiple tasks at the same time

Requirements:  

• Bachelor’s and/or Master’s degree in Computer Science, Computer Engineering or related technical discipline.
• Experience working with enterprise systems and understanding of data design pattern differences between transactional systems and analytical data warehouses
• 2+ years of experience using GCP Services (Big Query, Dataflow, Pub/Sub, Cloud Run Functions). Certifications in GCP are preferred (e.g. Professional Cloud Developer, Professional Cloud Database Engineer).
• 2+ years of professional or open-source experience to read data from APIs and developing programs in Java, Python, and Java Script.
• Expert in building, deploying, and maintaining data pipelines using open-source tools (i.e, Airflow, Composer, DataProc, DataFlow)
• Experience with Gitlab, Jenkins, CI/CD methodologies & tools.
• Skilled at writing optimized ETL jobs to feed data into Big Data systems (i.e., Big Query, DOMO, Hadoop).
• Experience creating dashboards/visualizations using Data Studio, DOMO (or similar).
• Advanced proficiency with SQL, with experience in writing complex queries, optimizing for performance, and using SQL in large-scale data processing workflows
• Good understanding of cloud design considerations and limitations and its impact on Pricing.
• Attention to detail and personal pride in work undertaken.
• Ability to self-start and self-direct work in an unstructured environment, comfortable dealing with ambiguity