Technical Consultant (ETL &Workato/SQL Development) - remote

Unanet’s product exposes targeted scripting hooks that enable the development of custom business logic validation. Our industry-leading product integrates with numerous external systems, primarily through a suite of Extract, Transform and Load (ETL) scripts. You will collaborate with Product Development and the rest of our Technology Services Team to develop, implement, and extend ETL Connectors and Recipes built via Workato. Additionally, you will work with our Senior Technical Consultant within our Professional Services Team to support existing interfaces built using our proprietary ETL system.

Our Technical Consultants also work closely with internal and external Business Consultants to review and validate customer requirements for implementing custom business logic validation and then develop those solutions using SQL (PostgreSQL, Oracle PL/SQL, and Microsoft T-SQL).

This position is based out of our Dulles, Virginia office and will report to our Manager of Technical Services.

What You’ll Do

• Extend and develop solutions using ETL middleware (Workato)
• Work with consultants to validate custom business logic validation requirements and then develop SQL (PostgreSQL, Oracle, and MS SQL) scripts based on those requirements
• Create, maintain, and facilitate the execution of custom and standard DB scripts to assist Unanet’s Support Team
• Work with both Product and Technical Services Teams to support existing integrations and assist in developing, implementing, and extending new integrations built via Workato

Your First 90 Days

By Day 30: You will be immersed in learning our products and solutions, including the data model and specific Technology Services policies and procedures. Product education will be at the forefront of your efforts, in concert with shadowing Senior Technology Consultants during Workato recipe configurations and/or Business Rules Enforcement (BRE) design and development.

By Day 60: You will be directly involved with Workato customization for client implementations with Senior team members shadowing you. While continuing to educate yourself on Unanet’s product, your efforts will directly support our UnanetConnect integration platform. Additional areas may include converting, testing, and implementing standard BRE scripts in PostgreSQL, Oracle PL/SQL and Microsoft T-SQL.

By Day 90: You will build on your experience to date and be a primary customer point of contact for integration efforts via Workato. You may also be involved in developing custom BRE scripts and custom support scripts. At this point, you will have completed the core Unanet University Product Training and be poised to grow and expand that knowledge as a core member of our Technical Services Team.

Who You Are

• Prior experience with iPaaS solutions (Workato strongly preferred)
• 2+ years of experience with ETL systems and processes, 
• 3+ years of experience or education in database programming, preferably with PostgreSQL and PL/SQL
• Ability to work with customers to troubleshoot technical issues
• Ability to multi-task across numerous client projects
• Strong verbal and written communication skills
• Strong interpersonal and team skills and the desire to work in a dynamic and fast-paced environment
• High level of initiative to work alone or part of a team

Your Differentiators

• 2+ years experience with development using Ruby
• Prior development experience using an object-oriented programming language, preferably Java
• Bachelor's Degree in Computer Science, Information Technology or related

Our Values

• We are a Team. Employees, customers, and partners working together.
• We are Customer-Focused. Customers are the heart of everything we do.
• We are Driven. Seeking exceptional outcomes.
• We Own our Success. Every employee has a stake in our company.
• We do the right thing and have fun in the process.

Unanet is proud to be an Equal Opportunity Employer. Applicants will be considered for positions without regard to race, religion, sex, national origin, age, disability, veteran status or any other consideration made unlawful by applicable federal, state or local laws.