Contractor -Alteryx Developer

Socket.dev; Boulder (CO); On-site; USD 120,000 - 180,000; Full time

Job summary

Datavail seeks a Senior Alteryx Developer to design and maintain automated data pipelines for analytics. You will work on API integrations, database connectivity, and Snowflake environments to ensure reliable data delivery across enterprise datasets.

You will implement Alteryx best practices for Designer and Server, optimize workflows for performance, and collaborate with analysts and data engineers to translate requirements into efficient solutions.

Qualifications

• Bachelor’s degree or higher in a data-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.
• Skilled 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.

Responsibilities

• Design, build, and maintain Alteryx workflows that ingest data from REST and SOAP APIs.
• Implement authentication methods (OAuth 2.0, API keys) within Alteryx workflows.
• Monitor API integrations for performance and data integrity.
• Establish and manage Alteryx database connections across SQL Server, Oracle, MySQL, PostgreSQL, etc.
• Configure and optimize Alteryx–Snowflake connectivity using drivers and bulk loading.
• Apply pushdown optimization and in-database tools for performance across large datasets.
• Create frameworks for data quality checks and logging within workflows.
• Collaborate with analysts and engineers to translate requirements into workflows.

Skills

Alteryx Designer

API integrations

SQL

Snowflake

Data governance

ETL concepts

Problem solving

Communication

Education

Bachelor’s degree in Data Analytics

Information Systems

Tools

Alteryx Server

ODBC/JDBC

Snowflake

REST APIs

Job description

Title: Senior Alteryx Developer

Location: USA

Exp: 8+ Years

Job Description:

We are seeking a results-driven Senior Alteryx Developer with proven expertise in API integrations, database connectivity, Snowflake environments, data validation, and Alteryx best practices. This role will be pivotal in enabling high-quality, automated, and reliable data pipelines that power analytics and business decision-making. The ideal candidate will bring strong technical skills, a detailed understanding of enterprise data ecosystems, and the ability to optimize Alteryx solutions for both Designer and Server environments.

1. API Integration & Automation

• 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.

2. Database Connectivity & Snowflake Integration

• 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.

3. Data Validation & Quality Assurance

• 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.

4. Best Practices & Performance Optimization

• 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.

5. Collaboration & Documentation

• 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.

• Required Qualifications

Required:

• 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.

• Skilled 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.

Preferred Skills

• Experience building Macros in Alteryx

• Experience with automation tools such as Alteryx Scheduler or Server API.

• Familiarity with Python or R for supplemental analytics tasks.

• Cloud experience (Snowflake on AWS/Azure/GCP ecosystem).

• Knowledge of CI/CD and workflow version control systems (Git, Bitbucket).

• Reading/writing from Snowflake (Using Alteryx)

Datavail is a leading provider of data management, application development, analytics, and cloud services, with more than 1,000 professionals helping clients build and manage applications and data via a world‑class tech‑enabled delivery platform and software solutions across all leading technologies. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes, and is an AWS Advanced Tier Consulting Partner, a Microsoft Solutions Partner for Data & AI and Digital & App Innovation (Azure), an Oracle Partner, and a MySQL Partner.

Datavail’s Data Management Services:

Datavail’s Data Management and Analytics practice is made up of experts who provide a variety of data services including initial consulting and development, designing and building complete data systems, as well as ongoing support and management of database, data warehouse, data lake, data integration, and virtualization and reporting environments. Datavail’s team is comprised of not just excellent BI & analytics consultants, but great people as well. Datavail’s data intelligence consultants are experienced, knowledgeable and certified in the best in breed BI and analytics software applications and technologies. We ascertain your business objectives, goals and requirements, assess your environment, and recommend the tools which best fit your unique situation. Our proven methodology can help your project succeed, regardless of stage. With the combination of a proven delivery model and top‑notch experience ensures that Datavail will remain the Data Management experts on demand you desire. Datavail’s flexible and client focused services always add value to your organization.