IT Programmer Analyst

Overview

On Site

BASED ON EXPERIENCE

Full Time

Contract - W2

Contract - Independent

Contract - 6+ mo(s)

Skills

Scripting

Database

Data Modeling

SQL

Data Visualization

Data Warehouse

RDBMS

PL/SQL

Stored Procedures

Amazon Web Services

Apache Parquet

JSON

Management

Amazon S3

Amazon Redshift

Extract

Transform

Load

Scheduling

BMC Control-M

BMC

Oracle ERP

Human Resources

Manufacturing

Marketing

System Implementation

Documentation

CGI

Supervision

Reporting

Advanced Analytics

FOCUS

Supply Chain Management

Finance

Analytical Skill

Python

SAS

Data Integration

Informatica

Data Analysis

Tableau

Alteryx

Oracle

Analytics

Cloud Computing

Microsoft Power BI

Communication

Job Details

Position Title:IT Programmer Analyst

Location: San Diego, CA 92121

Duration: 6 Months

Basic Qualifications:

Bachelor's degree minimum

Minimum of 3 years of experience

Required Skills:

Tableau - Dashboarding and governance
Python - Scripting
Redshift - Databases
Data Modelling
SQL
AWS
Oracle

Preferred Qualifications:

At least 3 years of experience with data visualization tools such as Tableau, Oracle Analytics Cloud, or Power BI
Experience in Statistical knowledge to support Advanced Analytics and complex visualizations desirable
Hands-on experience with Python Programming Language
Experience with Data Warehouse Design and Development using Cloud technologies like AWS Redshift and relational database like Oracle SQL and PL/SQL stored procedure
Preferred experience working within the AWS environment
Familiarity with different formats of data files (Parquet files, JSON, Semi-Structure) and moving & managing files in Amazon S3 layer
Process data into Amazon Redshift using Glue and Lambda
Automate repetitive tasks within the data pipeline using Python/Glue/Informatica
Some experience with scheduling jobs using tools like Control-M (BMC Software)
Experience in Oracle ERP Applications, Supply Chain Modules, Financial modules, Order2Cash and Source2Pay modules a plus

Role and responsibilities:

Designs, develops, modifies, debugs, and evaluates programs for functional areas, including but not limited to finance, human resources, manufacturing, and marketing
Analyzes existing programs or formulates logic for new systems, devises logic procedures, prepares flowcharting, performs coding, and tests/debugs programs
Develops conversion and system implementation plans
Prepares and obtains approval of system and programming documentation
Recommends changes in development, maintenance, and system standards
Trains users in conversion and implementation of system
Works under some supervision and makes decisions that are moderate in impact
Requires verbal and written communication skills to convey information that may be somewhat complex to others
Exercises creativity to draft original documents, imagery, or work products within established guidelines
Collaborates with other Analysts to complete assigned coding tasks to specifications without significant errors or bugs
Manages individual project priorities, deadlines, and deliverables with minimal supervision

Job description:

This position is for a Reporting and Advanced Analytics developer with a focus on Supply Chain and Finance projects and a potential for engagements with other business units. The candidate will be responsible for developing solutions in Tableau/Power BI/OAC with expertise in Advanced Visualizations. The candidate is expected to be highly analytical and process-oriented with in-depth knowledge of Tableau, Python, SAS, Model development, Data Integration using Informatica, Data Analysis and Data Exploration, Self-Service Analytics using Tableau, Alteryx, Oracle Analytics Cloud, and Power BI. The role requires a good understanding of the business environment, excellent communication skills, and the ability to work in a fast-paced environment.

APOLIS2024

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.