Alteryx Developer - Boston, Massachusetts - Longterm (Day-1 Onsite)

Job Title: Alteryx Developer

Location: Boston, Massachusetts

Duration: Long-term

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

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