Position: Alteryx Developer
Location: Boston Massachusetts
Job Description
Key Responsibilities:
- 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 selfservice data analysis and automation.
- Use Alteryx Connect and Promote to manage metadata and advanced analytics models (if applicable).
- Data Integration & ETL Development
- Extract transform and load (ETL) data from multiple sources including:
- Databases: Snowflake SQL Server SAP HANA Oracle PostgreSQL.
- Cloud Platforms: AWS Azure Google Cloud.
- APIs & Web Services: REST/SOAP APIs JSON XML.
- 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.
- 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.
- 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 InDB (InDatabase) processing to execute transformations at the database level for performance gains.
- Reduce manual efforts through automation and reusable Alteryx components.
- 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.
- Alteryx Server Administration & Deployment
- Deploy and manage workflows on Alteryx Server for enterprisewide 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:
- 35 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.
- Handson 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 InDB (InDatabase) tools to optimize largescale data processing.
- Familiarity with data visualization tools (Tableau Power BI Qlik) for integrated reporting solutions.
- Exposure to ControlM or other workflow scheduling tools is a plus.
- Experience with Alteryx Promote and Alteryx Connect for metadata and model management (optional).
Soft Skills:
- Strong problemsolving and analytical thinking for data transformation challenges.
- Ability to work independently and as part of a team in a fastpaced 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:
- Bachelors or Masters 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).