Alteryx Developer (ETL)

Synectics for Management Decisions, Inc; Alexandria (VA); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Competitive salary

Medical and dental insurance

401k

Paid leave

Professional development support

Job summary

Synectics for Management Decisions, Inc is seeking an Alteryx Engineer in Alexandria, VA. You will perform analysis, development, and testing of software for a major federal agency.

The ideal candidate has over 5 years in IT, with at least 3 years focused on Alteryx, data modeling, and AWS services. Attractive benefits include medical, dental, 401k, paid leave, and additional support for professional growth.

Qualifications

• 5+ years of experience in IT industry focusing on data.
• 3+ years of experience with Alteryx; certification preferred.
• Hands-on experience with Alteryx Designer and Server.
• Knowledge in scripting with Shell, Python, PowerShell.
• Understanding of data warehousing and data models.

Responsibilities

• Design and develop ETL workflows in Alteryx.
• Troubleshoot datasets and optimize data delivery processes.
• Guide cloud migration strategy for data analytics.
• Create documentation for best practices and technical specifications.
• Write complex SQL queries for data extraction in Alteryx.

Skills

Alteryx Designer

Alteryx Server

SQL

AWS Services

Python

Shell scripting

Data modeling

Education

Bachelor's degree in Engineering or related field

Tools

SAS DI Studio

Informatica

AWS Glue

Talend

Job description

Synectics is a customer-focused information management services firm that offers its customers data-driven solutions associated with the following core competencies: IT Modernization, Research & Statistical Analysis, Data Analytics, and Knowledge Management & Data Visualization. We are a woman-owned small business (WOSB) that is ISO 9001:2015 and ISO 27001:2013 certified and appraised at CMMI-3. Our office is located in Arlington, VA, near the Rosslyn Metro. Synectics offers a competitive salary and an impressive full benefits package that includes employee medical and dental, 401k, company paid life and short/long term disability insurance and paid leave, along with an environment that supports professional development and growth.

Job Description

Synectics for Management Decisions (SMDI) is seeking an Alteryx Engineer to join their growing team. The qualified applicant will perform complex analysis, design, development, and unit testing of software applications and play a key role in the DW cloud migration as part of the Enterprise Data Analytics and Services program for a large federal agency in Alexandria, VA.

Responsibilities

• Design, develop, validate, and troubleshoot the ETL workflows and datasets in Alteryx for analysis, forecasting, and report delivery and update the current SAS DI studio jobs to migrate the data to the cloud using Alteryx.
• Design and develop workflows consuming and publishing to API endpoints.
• Create and update documentation like best practices, technical specifications, implementation guides, architecture diagrams, and design documents.
• Identify, design, and implement internal process improvements, automate manual processes, optimize data delivery process, re‑design infrastructure for greater scalability, etc.
• Guide in implementing the cloud migration architecture, strategy, and roadmap.
• Write complex SQL queries with multiple joins to automate/manipulate these extracts in Alteryx.
• Create Alteryx related Standard Operating Procedures (SOP).
• Configure and manage project permissions and provide periodic reports on Alteryx and Server usage.
• Document and publish Alteryx workbooks and data extracts/ Alteryx workflows/ apps/macros.

Qualifications

• Minimum 5 years of experience in IT industry and focus on data.
• Minimum 3 years of related experience with Alteryx. Certification preferred.
• Hands‑on skills and work experience in Alteryx Designer, Alteryx Server, and the tools with Alteryx such as Parsing, Transforms and Predictive.
• Scripting knowledge & experience (Shell scripts, Python, PowerShell).
• Good understanding of design, development, unit testing, quality assurance, user acceptance testing, software release and change management.
• Good understanding of data models and data warehousing.
• Good working knowledge of AWS Services including Compute, Storage, Networking, Database, Management tools, Security, Identity and Compliance.
• Experience with other ETL tools a plus (SAS DI Studio, Informatica, AWS Glue & Talend).
• Strong analytical, problem solving and troubleshooting abilities.
• Bachelor’s degree in Engineering or related field.

Additional Information

Synectics is an Equal Opportunity Employer.

We offer a competitive salary and an impressive full benefits package that includes employee medical and dental, 401k, company paid life and short/long term disability insurance and paid leave, along with an environment that supports professional development and growth.