Agent-Orch. Software Engr

Job Summary

This hybrid role for an Agent Orch Software Engineer focuses on designing and implementing robust data and intelligence solutions using Snowflake Cortex Code Snowflake Cortex and core Snowflake capabilities to support finance and accounting analytics. The role requires eight to twelve years of experience and emphasizes scalable orchestration patterns secure data processing and impactful insights for business stakeholders.

Responsibilities

• Design and implement advanced data orchestration workflows using Snowflake Cortex Code and Snowflake Cortex to enable intelligent automation and high performance analytical pipelines for enterprise stakeholders.
• Develop optimized data models and transformation logic in Snowflake that support complex finance and accounting reporting needs ensuring accuracy consistency and timely availability of key metrics.
• Collaborate with cross functional teams in a hybrid work environment to gather detailed business requirements translate them into technical designs and deliver secure scalable data solutions that align with organizational goals.
• Configure and maintain Snowflake environments including warehouses databases and roles to ensure reliable performance robust security posture and efficient resource utilization across day shift operations.
• Create reusable patterns and components for agent based orchestration in Snowflake Cortex Code that streamline workflow management reduce maintenance overhead and improve development velocity for project teams.
• Conduct thorough data quality checks using systematic validation rules and monitoring frameworks within Snowflake to safeguard financial and accounting datasets from anomalies and inconsistencies.
• Optimize SQL queries data pipelines and orchestration logic to minimize compute costs enhance execution speed and support large scale analytical workloads without service disruption.
• Prepare clear technical documentation and solution walkthroughs that explain design decisions data flows orchestration strategies and operational procedures to both technical and nontechnical stakeholders.
• Collaborate with finance and accounting domain experts to refine analytical models calculations and data interpretations ensuring that delivered solutions accurately reflect business policies and regulatory requirements.
• Implement robust access control patterns and governance practices in Snowflake to protect sensitive financial information while supporting responsible data sharing for decision makers.
• Coordinate deployment activities across development testing and production environments ensuring smooth rollout of new features and updates without impacting ongoing business processes.
• Provide guidance on best practices for Snowflake Cortex Cortex Code and core Snowflake usage helping project teams adopt efficient design principles and enhance long term solution maintainability.
• Monitor operational dashboards logs and performance metrics to proactively identify issues and drive continuous improvement in data orchestration reliability and user experience.

Qualifications

• Possess strong hands on experience in Snowflake Cortex Code Snowflake Cortex and Snowflake data platform including design development performance tuning and secure operations for enterprise workloads.
• Demonstrate proficiency in writing complex SQL designing scalable data models and implementing efficient transformation logic that support finance and accounting analytics and reporting scenarios.
• Bring familiarity with finance and accounting concepts such as general ledger reporting reconciliations and financial metrics enabling effective collaboration with domain teams and accurate solution design.
• Exhibit experience working in hybrid delivery setups coordinating on site and remote collaboration while maintaining clear communication and structured documentation for all stakeholders.
• Show proven track record of managing end to end data solutions over eight to twelve years including requirement analysis build testing deployment and steady state support within large organizations.
• Display strong problem solving skills with the ability to troubleshoot performance bottlenecks data quality issues and orchestration failures in Snowflake based environments using systematic diagnostic approaches.
• Utilize knowledge of cloud data ecosystem and integration tooling to connect Snowflake with upstream and downstream systems ensuring seamless data movement metadata integrity and reliable analytics.

Certifications Required

Snowflake SnowPro Core Certification or equivalent advanced Snowflake platform certification is strongly preferred for this role.