First seen by Alion on Nov 12, 2026.
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
1. 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.
2. Workflow Performance Optimization & Troubleshooting
• Analyze and optimize workflow execution times, memory consumption, and data processing efficiency.
• Apply Alteryx performance optimization techniques, including:
o AMP Engine configuration and performance tuning.
o Efficient use of Select, Filter, Join, Summarize, and In-DB processing tools.
o Pushdown processing to databases where appropriate.
o Optimization of data types, intermediate datasets, and workflow dependencies.
o 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.
3. 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.
4. 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.
5. 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.
6.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.
7. 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 strong 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.
Job Description
Document No: AMP_HR_F_004 Ver No: 1.1 Rev Date: 04-May-2026
Internal Page 6 of 7
• 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.
Skills
Alteryx, ETL

