Seeking an Application Systems Engineer.

The person that fills this position will be a vital part of our team and will be responsible for the design and development through a complete System Development Life Cycle (SDLC) of Extract, Transform & load (ETL) processes using Ab Intio as ETL environment.

RESPONSIBILITIES:

- Design and implement highly distributed, scalable and performant ETL processes - Staging, Data Enrichments and Strong data delivery techniques using Ab Intio as ETL environment

- Hands on ETL development (data transformations and data movement) using Ab Initio, Ab Initio Express IT, DQE (Data Quality) and Metadata Portal as key tools

- Effectively work in an ETL framework driven environment

- Identify key business processes and deliver subject specific ETL processes to load physical data models

- Support ongoing ETL efforts for Development, QA and Production environments

- Effectively communicate data design to other members of the team to ensure proper implementation and utilization of the data structures

- Partner with source system Subject Matter Experts (SMEs), Data Analysts and Modelers to build integration and curated views of complex data sources into our environment.

- Work very closely with business analysts, development teams and project managers for requirements and business rules

- Work with Microsoft SQL Server DBAs to troubleshoot problems and optimize performance

- Work on complex problems where analysis requires evaluation of intangible variance factors

- Plan, perform, and act as the escalation point for the most complex platform designs, coding, and testing

- Work with data modeling team to review and critique data architecture design and implementation work

Additional responsibilities:

- Acts as a lead in providing application design guidance and consultation, utilizing a thorough understanding of applicable technology, tools and existing designs.

- Provides technical consultation and support in the development of computer applications and programs

- Develops original and/or highly complex code and provides coding guidance to less experienced staff.

- Leads and/or performs modeling, simulations and analysis efforts.

- Verifies program logic by overseeing the preparation of test data, testing and debugging of programs.

- Oversees overall systems testing and the migration of platforms and applications to production.

- Develops new documentation, departmental technical procedures and user guides.

- Assures quality, security and compliance requirements are met for supported area and oversees creation of or updates to and testing of the business continuation plan.

Required Qualifications

- 7+ years of application development and implementation experience

- 7+ years of Ab Initio experience

- 7+ years of SQL experience

- 6+ years of source/version control tools experience

- 5+ years of experience supporting or designing complex ETL production environments

- 5+ years of SDLC (System Development Life Cycle) experience

- 5+ years of performance tuning experience

Desired Qualifications:

- Good verbal, written, and interpersonal communication skills

- 5+ years of Metadata experience

- 3+ years of Agile experience

- Experience applying new technologies to business needs in a technologically innovative , change-driven organization

- Knowledge and understanding of relational database concepts, querying, data warehousing, ETL process, requirements gathering and/or decision support tools

- Knowledge and understanding of software development life cycle (SDLC): code control, build and deployment

- Knowledge and understanding of authentication methods or protocols

- Knowledge and understanding of database modeling techniques and theory

- A BS/BA degree or higher in information technology

- 2+ years of experience using Build Tools such as Jenkins and uDeploy

- 3+ years of experience working with QA and other Technology teams

- 3+ years of agile software development techniques including designing software for unit testing and acceptance testing, and the use of continuous integration.

- Experience leading junior level team members in a lead role