Key skills
AWSAzureCloudETLGoogle Cloud PlatformMySQLOraclePostgresPythonRDBMSSOAPSQLRAnalyticsSnowflakeGCPGoogle CloudPostgreSQLSQL ServerOAuthGitBitbucketVersion ControlCI/CDCommunicationCollaboration
About this role
Role Overview
- Design, build, and maintain Alteryx workflows that consume REST and SOAP APIs for real-time and batch data ingestion.
- Implement authentication methods, including OAuth 2.0, API keys, and token-based security, within Alteryx workflows.
- Monitor API integrations for performance, error handling, and data integrity.
- Establish and manage native Alteryx database connections across multiple RDBMS platforms (SQL Server, Oracle, MySQL, PostgreSQL, etc.).
- Configure and optimize Alteryx–Snowflake connectivity using ODBC/JDBC drivers and bulk loading techniques.
- Leverage pushdown optimization and in-database tools for maximum performance against large datasets.
- Create frameworks within Alteryx for data quality checks, including completeness, accuracy, consistency, and referential integrity.
- Implement logging and exception handling within workflows to monitor data anomalies.
- Automate validation processes to run pre
- and post-load for ETL jobs.
- Apply Alteryx Designer best practices: modular workflow design, reusable macros, annotation/documentation, and version control.
- Optimize workflows for Alteryx Server execution: scheduling, priority management, dependency handling, and resource optimization.
- Implement governance standards for workflow deployment, access management, and error resolution.
- Partner with analysts, data engineers, and business stakeholders to translate requirements into efficient workflows.
- Maintain clear technical documentation for workflows, macros, APIs, and connections.
- Train junior staff and evangelize Alteryx best practices across the organization.
Requirements
- 8+ Years of experience as an Alteryx Developer
- Bachelor’s degree in Data Analytics, Computer Science, Information Systems, or related field
- 3–5+ years of Alteryx Designer experience (Core or Advanced certified preferred)
- Proven experience integrating APIs into Alteryx workflows
- Strong background in database administration and connectivity within Alteryx
- Hands-on experience with Snowflake data cloud integration, including bulk loads and query optimization
- Proficient in SQL (DDL/DML), with ability to script and optimize queries
- Excellent understanding of ETL concepts, data cleansing, and data governance
- Strong problem-solving and troubleshooting capabilities
- Excellent communication skills for cross-team collaboration
- Experience building Macros in Alteryx (preferred)
- Experience with automation tools such as Alteryx Scheduler or Server API (preferred)
- Familiarity with Python or R for supplemental analytics tasks (preferred)
- Cloud experience (Snowflake on AWS/Azure/GCP ecosystem) (preferred)
- Knowledge of CI/CD and workflow version control systems (Git, Bitbucket) (preferred)
- Reading/writing from Snowflake (Using Alteryx) (preferred)
Tech Stack
- AWS
- Azure
- Cloud
- ETL
- Google Cloud Platform
- MySQL
- Oracle
- Postgres
- Python
- RDBMS
- SOAP
- SQL
Benefits
- Health insurance
- Retirement plans
- Paid time off
- Flexible work arrangements
- Professional development