Software Development Senior Specialist

We are looking for a skilled Snowflake Developer to design, develop, and optimize scalable data warehouse solutions using Snowflake. 
Candidate should also be skilled in Power Automate Developer to design, develop, and implement automated workflows and business process solutions using Microsoft Power Platform
The ideal candidate will have strong SQL expertise, hands-on experience with ETL/ELT pipelines, a solid understanding of cloud data architecture, integrating enterprise systems, and improving operational efficiency through automation.

You will work closely with data engineers, analysts, and business stakeholders to deliver high-quality, performance-optimized data and scalable automation solutions.

- Design, develop, and maintain data warehouse solutions in Snowflake.

- Build and optimize complex SQL queries, views, stored procedures, and data models.

- Develop and maintain ETL/ELT pipelines to ingest data from various sources (APIs, databases, flat files, cloud storage).

- Implement Snowflake features such as Streams, Tasks, Snowpipe, Time Travel, Cloning, and Data Sharing.

- Perform query tuning and performance optimization.

- Monitor warehouse performance and manage cost optimization strategies.

- Implement security best practices (RBAC, masking policies, secure data sharing).

- Troubleshoot data issues, pipeline failures, and performance bottlenecks.

- Maintain documentation for data models, transformations, and workflows.

- Design, develop, and deploy automated workflows using Microsoft Power Automate (Cloud Flows, Desktop Flows).

- Automate business processes across Microsoft 365, SharePoint, Teams, Outlook, OneDrive, and third-party applications.

- Develop custom connectors and integrate REST APIs, web services, and external systems.

- Implement approval workflows, notifications, document automation, and system integrations.

- Troubleshoot and resolve flow failures, performance issues, and integration errors.

- Implement governance, security, and best practices within the Power Platform environment.

- Collaborate with Power Apps developers to build end-to-end automation solutions.

- Maintain documentation for workflows, integration points, and automation logic.

- Provide support, enhancements, and optimization for existing automation solutions.

- Ensure compliance with organizational security and data protection policies.