Alteryx Developer (ETL)

Posted 20 Days Ago
Be an Early Applicant
Alexandria, VA
Senior level
Information Technology • Software • Business Intelligence • Consulting
The Role
The Alteryx Developer will design, develop, validate, and troubleshoot ETL workflows in Alteryx, assist in cloud migration efforts, write complex SQL queries, automate processes, and document Alteryx workbooks. The role focuses on ensuring high-quality data analysis and reporting while optimizing infrastructure and workflows.
Summary Generated by Built In

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

• 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, optimizing 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 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. Our hiring process is 100% online.

Top Skills

Alteryx
Python
SQL
The Company
HQ: Arlington, VA
68 Employees
On-site Workplace
Year Founded: 1969

What We Do

Synectics is a client-focused research, statistics, technology, and data science consulting firm devoted to “making data meaningful.” We are a blend of academics and technicians who support federal agencies and other clients. Our core expertise includes IT for grants management; IT for public health databases; application development; data warehousing; and business intelligence. Our grants modules have securely processed over $75 billion in federal funds in one fiscal year – an amazing feat. And we are an amazing place to work, as we champion innovation, communication, and collaboration.

Synectics employs dedicated professionals, who help provide our expanding client base with a full range of IT services. Our philosophy is to provide the best service at very competitive rates and to build long-lasting professional relationships with our clients. Many of them have been with us over 20 years. We believe that consulting services are much more than just contracts—they are the foundation for the success of our clients—and we make every effort to ensure that success is what they achieve using our services.

Similar Jobs

The Aerospace Corporation Logo The Aerospace Corporation

Engineering Manager for Modeling and Simulation Computing

Aerospace • Artificial Intelligence • Cloud • Machine Learning • Cybersecurity • Defense
Hybrid
Chantilly, VA, USA
4600 Employees
134K-201K Annually

Capital One Logo Capital One

Senior Lead, Solutions Architect

Fintech • Machine Learning • Payments • Software • Financial Services
Hybrid
McLean, VA, USA
55000 Employees

STR Logo STR

Senior Embedded Software Engineer

Machine Learning • Security • Software • Analytics • Defense
Arlington, VA, USA
600 Employees

STR Logo STR

Lead Embedded Software Engineer

Machine Learning • Security • Software • Analytics • Defense
Arlington, VA, USA
600 Employees

Similar Companies Hiring

InCommodities Thumbnail
Renewable Energy • Machine Learning • Information Technology • Energy • Automation • Analytics
Austin, TX
234 Employees
RunPod Thumbnail
Software • Infrastructure as a Service (IaaS) • Cloud • Artificial Intelligence
Charlotte, North Carolina
53 Employees
Hedra Thumbnail
Software • News + Entertainment • Marketing Tech • Generative AI • Enterprise Web • Digital Media • Consumer Web
San Francisco, CA
14 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account