Alteryx Developer

Job Title – Alteryx Developer

Location – Boston MA

Type – Contract

Work Mode – 3 Days / Week

Interview Mode – Microsoft Teams meeting – Video

Key Responsibilities:

1. Alteryx Workflow Development & Automation

• Design, develop, and optimize Alteryx workflows, macros, and analytic apps for ETL and data transformation.

• Implement data cleansing, validation, and enrichment techniques within workflows.

• Develop scheduled workflows in Alteryx Server to automate ETL and data preparation tasks.

• Build Alteryx Gallery Apps for self-service data analysis and automation.

• Use Alteryx Connect and Promote to manage metadata and advanced analytics models (if applicable).

2. Data Integration & ETL Development

• Extract, transform, and load (ETL) data from multiple sources, including:

o Databases: Snowflake, SQL Server, SAP HANA, Oracle, PostgreSQL.

o Cloud Platforms: AWS, Azure, Google Cloud.

o APIs & Web Services: REST/SOAP APIs, JSON, XML.

o Files: Excel, CSV, Parquet, JSON, XML.

• Design efficient ETL pipelines to support analytics, dashboards, and reports.

• Optimize data workflows to improve performance, scalability, and reusability.

3. Advanced Analytics & Scripting

• Develop predictive models and statistical analysis using Alteryx predictive tools.

• Utilize Python and R scripts within Alteryx for advanced analytics.

• Implement machine learning models (if applicable) and integrate with AI/ML platforms.

• Perform data profiling and anomaly detection to identify inconsistencies in datasets.

4. Performance Tuning & Optimization

• Improve workflow execution time by optimizing queries, caching, and data processing techniques.

• Implement best practices for efficient data transformation and storage.

• Leverage In-DB (In-Database) processing to execute transformations at the database level for performance gains.

• Reduce manual efforts through automation and reusable Alteryx components.

5. Collaboration & Stakeholder Engagement

• Work closely with business analysts, data engineers, and data scientists to gather and analyze requirements.

• Provide technical support and training to business users on Alteryx workflows.

• Document ETL processes, workflow logic, and best practices for knowledge sharing.

• Participate in code reviews and peer programming sessions to improve workflow quality.

6. Alteryx Server Administration & Deployment

• Deploy and manage workflows on Alteryx Server for enterprise-wide access.

• Configure user roles, permissions, and automation schedules in Alteryx Server.

• Monitor server performance and troubleshoot failed workflows or job execution issues.

• Set up version control and workflow governance to ensure compliance with data security policies.

Required Skills & Experience:

Technical Skills:

✔ 3-5 years of experience in Alteryx Designer, Alteryx Server, and Alteryx Gallery.

✔ Strong ETL and data integration experience across multiple databases and file types.

✔ Proficiency in SQL for query optimization and performance tuning.

✔ Hands-on experience with Snowflake, SAP HANA, SQL Server, Oracle, or PostgreSQL.

✔ Experience in REST API integration using Alteryx tools and scripting.

✔ Knowledge of Python, R, or VBA for advanced scripting and automation.

✔ Experience with Alteryx In-DB (In-Database) tools to optimize large-scale data processing.

✔ Familiarity with data visualization tools (Tableau, Power BI, Qlik) for integrated reporting solutions.

✔ Exposure to Control-M or other workflow scheduling tools is a plus.

✔ Experience with Alteryx Promote and Alteryx Connect for metadata and model management (optional).

Soft Skills:

✔ Strong problem-solving and analytical thinking for data transformation challenges.

✔ Ability to work independently and as part of a team in a fast-paced environment.

✔ Excellent written and verbal communication skills to engage with business and technical stakeholders.

✔ Ability to understand business requirements and translate them into technical solutions.

✔ Strong attention to detail and a mindset for continuous improvement.

Preferred Qualifications:

• Bachelor’s or Master’s degree in Computer Science, Data Analytics, Information Technology, or a related field.

• Must be a US Citizen ONLY. Dual citizenship other than US and work visas are not eligible.

• Alteryx Certification (Alteryx Designer Core, Advanced, or Expert) is highly preferred.

• Experience with big data platforms (Hadoop, Spark, Databricks) is a plus.

• Knowledge of AWS/Azure cloud data services (S3, Redshift, Synapse, etc.).

• Prior experience in Alteryx migration projects (from legacy ETL tools to Alteryx).