Role Overview

We are seeking a highly skilled, hands-on Senior Alteryx Technical Engineer with extensive experience in developing, optimizing, deploying, and supporting enterprise-grade Alteryx workflows.

The role requires deep technical expertise in Alteryx Designer, advanced data transformation, workflow automation, macros, data integration, performance optimization, and platform administration. The engineer will be responsible for managing business-critical workflows supporting Investor Operations and Client Reporting, ensuring data accuracy, scalability, operational reliability, and efficient processing.

The ideal candidate must demonstrate strong technical problem-solving capabilities, independent engineering ownership, and excellent communication skills to engage effectively with business stakeholders, application teams, and enterprise technology teams.

Key Responsibilities

- Advanced Alteryx Workflow Engineering

Design, develop, and maintain complex ETL/ELT and analytical workflows using Alteryx Designer.

Demonstrate advanced proficiency with Alteryx tools, including Formula, Multi-Row Formula, Multi-Field Formula, Join, Join Multiple, Union, Summarize, Cross Tab, Transpose, Regex, and Dynamic Input/Output.

Develop reusable Standard Macros, Batch Macros, Iterative Macros, and Analytic Apps to support modular and scalable workflow designs.

Implement complex business rules, conditional processing, parameterized workflows, dynamic schema handling, and multi-source data transformations.

Build data cleansing, reconciliation, exception handling, validation, and enrichment pipelines.

Design workflows capable of processing large datasets while maintaining accuracy, performance, and operational stability.

- Workflow Performance Optimization & Troubleshooting

Analyze and optimize workflow execution times, memory consumption, and data processing efficiency.

Apply Alteryx performance optimization techniques, including:

AMP Engine configuration and performance tuning.

Efficient use of Select, Filter, Join, Summarize, and In-DB processing tools.

Pushdown processing to databases where appropriate.

Optimization of data types, intermediate datasets, and workflow dependencies.

Efficient handling of large-volume datasets and complex joins.

Troubleshoot workflow execution failures, schema mismatches, data-type conversion issues, and connectivity errors.

Implement robust error handling, validation checkpoints, logging, and exception reporting.

Perform root-cause analysis and implement permanent solutions for recurring production issues.

- Alteryx Server / Alteryx One Administration

Deploy, schedule, monitor, and maintain production workflows using Alteryx Server or applicable Alteryx One capabilities.

Manage workflow publishing, versioning, scheduling, dependencies, and execution monitoring.

Configure and troubleshoot data connections, credentials, permissions, and access controls.

Work with Alteryx Server components such as Gallery, Controller,



Worker, and Scheduler where applicable.

Support platform configuration, environment management, and deployment activities.

Troubleshoot workflow scheduling failures, execution queues, resource constraints, and connectivity issues.

Support operational monitoring and platform stability for business-critical workflows.

- Enterprise Data Integration & SQL

Integrate Alteryx workflows with enterprise data platforms such as Snowflake, SQL Server, PostgreSQL, and other relational databases.

Develop complex SQL queries involving joins, CTEs, aggregations, window functions, and data validation logic.

Use Alteryx Input Data, Output Data, Dynamic Input, and In-DB tools for efficient data processing.

Integrate REST APIs, JSON, XML, CSV, Excel, and other structured or semi-structured data sources.

Configure and troubleshoot ODBC/JDBC connections and database authentication.

Implement incremental data processing, reconciliation logic, duplicate detection, and data quality controls.

Develop automated workflows for scheduled data extraction, transformation, and reporting.

- Identity & Access Management – Microsoft Entra ID / SCIM

Support Alteryx integration with Microsoft Entra ID for enterprise identity and access management.

Configure and troubleshoot SCIM-based user and group provisioning, including automated provisioning, updates, and deprovisioning.

Manage user/group synchronization, role assignments, and access permissions.

Investigate SCIM provisioning errors, authentication issues, and synchronization failures.

Collaborate with IAM and infrastructure teams to maintain secure and controlled access to the Alteryx platform.

Support role-based access controls, audit requirements, and enterprise security standards.

- Production Support & Engineering Ownership

Own end-to-end technical delivery of Alteryx solutions, from requirements analysis and design through development, testing, deployment, and production support.

Monitor scheduled workflows, investigate failures, and resolve data processing incidents.

Implement automated data quality checks, exception notifications, and operational controls.

Maintain source-to-target mappings, workflow documentation, technical specifications, and runbooks.

Collaborate with upstream and downstream application teams to resolve integration dependencies.

Ensure production workflows meet agreed business processing timelines and reporting requirements.

- Stakeholder Engagement & Communication

Work directly with Investor Operations, Client Reporting, and technology stakeholders.





Translate complex business requirements into robust Alteryx workflow designs.

Explain technical solutions, data issues, root causes, and remediation plans to technical and non-technical audiences.

Provide clear status updates, proactively identify risks, and independently drive issue resolution.

Demonstrate robust ownership, structured problem-solving, and excellent written and verbal communication.

Mandatory Technical Skills

Alteryx Certification – Mandatory: Valid Alteryx Designer Core Certification or higher.

Alteryx Designer: Advanced hands-on expertise in complex workflow development, data transformation, and automation.

Alteryx Macros: Practical experience developing Standard, Batch, and Iterative Macros.

Alteryx Performance Tuning: Strong understanding of workflow optimization, AMP Engine, memory utilization, and efficient processing of large datasets.

SQL: Strong hands-on SQL development, complex queries, joins, aggregations, and data reconciliation.

Data Integration: Experience connecting Alteryx to databases, APIs, and multiple enterprise data sources.

Production Support: Experience troubleshooting failed workflows, scheduling issues, data discrepancies, and performance bottlenecks.

Platform Operations: Working knowledge of Alteryx Server or Alteryx One workflow deployment, scheduling, monitoring, and administration.

Communication: Excellent verbal and written communication skills with the ability to interact confidently with business and technical stakeholders.

Preferred / Good-to-Have Skills

Private Equity or Investment Management domain experience will be a plus.

Alteryx Designer Advanced or Expert Certification.

Experience administering Alteryx Server, including Gallery, Controller, Worker, and scheduling components.

Experience with Alteryx One / Alteryx Analytics Cloud administration.

Microsoft Entra ID, SCIM 2.0 provisioning, and enterprise identity management.

Python scripting, including Pandas and data processing automation.

Snowflake integration and SQL performance optimization.

Experience with Alteryx Server APIs, REST APIs, and workflow orchestration.

Knowledge of Git-based version control and CI/CD practices for Alteryx workflows.

Understanding of financial data reconciliation, investor reporting, data governance, and audit controls.

Ideal Candidate Profile The ideal candidate is a technically strong, hands-on Alteryx engineer who can independently build complex workflows, develop reusable macros, optimize data processing, troubleshoot production issues, and manage enterprise Alteryx operations.

The candidate should have experience supporting business-critical data automation and reporting solutions, demonstrate excellent communication skills, and be comfortable engaging directly with senior business and technical stakeholders.

Alteryx certification is mandatory. Experience in Private Equity or Investment Management will be considered an added advantage.

📌 Lead Software Engineer (Chennai)
🏢 Straive
📍 Chennai