Business Analytics Advisor

Ampcus Inc; Morris Plains (NJ); On-site; USD 80,000 - 110,000; Full time

Job summary

An innovative firm is seeking a Business Analytics Advisor to join their dynamic team. This role involves leveraging Teradata SQL and IBM Mainframe to create custom output files, ensuring high-quality solutions that meet client needs. The ideal candidate will thrive in an Agile environment, possessing strong communication skills and the ability to collaborate effectively with team members. You will participate in all technical phases of projects, troubleshoot and develop solutions, and contribute to a culture of excellence. If you are passionate about data analytics and eager to make an impact, this opportunity is perfect for you.

Qualifications

• 5+ years of experience in Teradata SQL and IBM Mainframe.
• Experience with Agile methodologies and Unix/Linux Shell scripting.

Responsibilities

• Develop custom output files and write SQL queries for data extraction.
• Collaborate with QA teams and ensure quality solutions.

Skills

Teradata SQL

IBM Mainframe

Unix/Linux Shell Scripting

Agile Methodologies

JCL

CA7

Communication Skills

Education

Bachelor's degree in Computer Science

High School Diploma or GED

Tools

Jira

Job description

Business Analytics Advisor

Location: Can sit in either TX or NJ offices

Job Description:

Seeking Teradata SQL developer/lead and data analyst with experience working on an IBM Mainframe to build custom output files for our clients/vendors. Candidates will need to quickly get familiar with the Enterprise Data Warehouse that sources our output data and be able to write SQL queries to extract the data needed to deliver on client requirements.

Job Specifics:

• Candidate must have experience working in an Agile environment and with being a collaborative member of an Agile team. Candidate must be a good communicator and have strong people skills.
• Must be able to create Technical designs and solutions that deliver quality solutions for client and business needs.
• Must have a thorough understanding of Teradata- how it processes and stores data and how to write efficient SQL to retrieve data needed.
• Must have Unix/Linux Shell scripting experience.
• Participate in all technical phases of each project assigned.
• Accountable for quality and timeliness of product development, technical design, and solution implementation as a development team member.
• Partners with QA teams to resolve solution design deficiencies and related deliverables.
• Troubleshoots, maintains, and develops application and system solutions for business mandated products and regular operational processes.

Job Qualifications Considered a Plus:

• Previous experience in Health care or PBM industry
• Jira
• PBM or Health Care business experience

Skills:

• IBM Mainframe: 5 years
• JCL: 5 years
• CA7: 5 years
• Teradata SQL experience: 5 years
• Agile: 3 years
• Unix/Linux Shell Script: 2 Years

Education:

Bachelors degree or equivalent in Computer Science, Software Systems, Computer Applications PREFERRED. High School Diploma or GED REQUIRED.

Note: Employer will not sponsor applicants for any employment visas, at hiring or in the future, including but not limited to H-1B visas. Corp-to-Corp or subcontract personnel will not be considered for this position.