Alteryx Developer (ETL)
Apply NowCompany: Synectics for Management Decisions, Inc
Location: Alexandria, VA 22304
Description:
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.
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.