Applications Analyst

$50.00 - $61.00 hourly
  • Johnson Service Group
  • Aug 02, 2019
Temporary Information Technology

Job Description

Applications Analyst (Financial Systems Support, ERP Project Migration, ERP Integrations)

Johnson Service Group is Seeking analysts to be a technical resource in supporting our customer's HCM and financial applications – operational support of legacy application as well as data migration and integrations definition for ERP implementation. In addition, this role will provide primary IT technical support with various database (Oracle and SQL Server) and interface tools (scripting and reporting…). This position is required to participate in a fast-paced project environment, quickly analyzing and understanding legacy systems and help identify the best migration path to destination system in a timely manner utilizing IT, programming and application analysis skills. This position will also be responsible for system integration with ETL tools and documenting procedures.

Required Skills/Experience

• Working knowledge of Oracle, Microsoft SQL Server, and Microsoft Access
• Ability to learn and understand application data table structure to create database schemas and ability to conditionally extract data directly from data base to create complex database views with Strong SQL programming
• Define, manage and/or perform the design, testing, implementation and documentation of IT systems per agreed timelines, business requirements and organization standards in collaboration with internal business units
• Experience developing interfaces and integration between different system
• Extract & transform for data integration
• Work as a cross-functional team member, critically evaluate and manage user requests to ensure accurate prioritization and optimal resolutions
• Lead communication with internal staff and technology service providers to bridge the requirement gaps and technical needs
• Familiarity with Unix environment and shell scripting
• 2+ years’ experience in IT Applications
• 4-year degree or Master’s degree related to Computer Science and Business Analyst

General Skills & Abilities
• Communications skills to define and document requirements
• Excellent documentation skills
• Willingness to document processes and procedures, enabler of turnover to production
Desired Skills/Experience
• Experience with Microsoft SQL Server and Oracle database backup/restore processes and Microsoft SQL Server SSIS and SSRS
• Working experience of creating Oracle Packages/functions and Microsoft SQL Server stored procedures
• Experience supporting finance functions like Accounting, Budgeting or Forecasting functions
• Exposure to SaaS application support
• Experience with programming
• Experience working on interface development between finance/HR system (eP/NextGen) and Questica budget system
• Experience with a public-sector agency

When applying, please note that you saw the job posted on the NOVA Job Board. If you need help with your resumé, please see a NOVA Career Advisor.