Job Title: IT Programmer Analyst/ Data Analyst Location: San Diego, CA 92121 Duration: 6+ Months with the possibility of extension Work Shift: Mon - Fri 1st Shift 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. General Summary 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. The responsibilities of this role include: • Working under some supervision. • Making decisions that are moderate in impact; errors may have relatively minor financial impact or effect on projects, operations, or customer relationships; errors may require involvement beyond immediate work group to correct. • Requires verbal and written communication skills to convey information that may be somewhat complex to others who may have limited knowledge of the subject in question. • Most tasks require multiple steps that can be performed in various orders; some planning and prioritization must occur to complete the tasks effectively; mistakes may result in some rework. • Deductive and inductive problem solving is required; multiple approaches may be taken/necessary to solve the problem; often information is missing or incomplete; intermediate data analysis/interpretation skills may be required. • Exercising creativity to draft original documents, imagery, or work products within established guidelines. Required Skills: 1. Tableau – Dashboarding and governance 1. Python - Scripting 1. Redshift – Databases 1. Data Modelling 1. SQL 1. AWS (Redshift, S3, Lambda, Glue) 1. Oracle ERP, Oracle cloud (Prefer skill) Preferred Qualifications: • At least 3 years of experience with data visualizations 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. • At least 3 years of 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 format 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. Principal Duties & Responsibilities: • Unit tests own code to verify stability and functionality • Communicates with project lead via email and direct conversation to make recommendations about overcoming impending obstacles. • Gathers, integrates, and interprets information from a variety of sources in order to troubleshoot issues and find solutions. • Resolves standard software issues and bugs. • Adapts to significant changes and setbacks in order to manage pressure and meet deadlines independently. • Participates in code reviews on project team's submitted solutions. • Writes code for small features or minor bug fixes to support collaboration with other engineers. • Anticipates complex issues and discusses within and outside of project team to maintain open communication. • Manages individual project priorities, deadlines, and deliverables with minimal supervision. • Collaborates with other Analysts to complete assigned coding tasks to specifications without significant errors or bugs. • Determines which work tasks are most important for self and junior personnel, manages distractions, and independently deals with setbacks in a timely manner. • Executes against current technology roadmap.