Job Description:
We are seeking a Supply Chain Systems Analyst for a very important client
Responsibilities:
Requirements Gathering and Analysis:
o collaborate with various teams, departments and stakeholders to gather, document, and analyze business requirements, processes, and workflows.
o Elicit, document, and analyze business requirements, processes, and workflows.
o Translate business requirements into clear and concise functional specifications for technical teams.
o Work with project managers to define project scope, objectives, and deliverables.
System Design and Architecture:
o Design and document system architectures, data flows, and integration points.
o Collaborate with technology teams to design solutions that meet business needs.
o Ensure alignment with overall enterprise architecture and standards.
o Create robust dimensional data models for various domains, Sales Order, Inventory, Planning, Supply Chain and forecasting data.
Solution Development and Testing:
o Work closely with development teams to implement system changes, enhancements, and new features.
o Participate in code reviews and ensure adherence to coding standards.
o Conduct system testing, including unit testing, integration testing, user acceptance testing and validation of implemented solutions
o Ensure that delivered solutions meet the specified requirements and are of high quality.
Data Management and Integration:
o Design and optimize ETL (Extract, Transform, Load) processes using Informatica.
o Integrate data from diverse sources, including ERP systems, mobile applications, and cloud-based platforms across global locations.
o Migrate and synchronize data from the Enterprise Data Warehouse (EDW) to Big Query using Data Fusion, especially during company mergers.
o Experience writing complex queries and fine-tune existing SQL queries to enhance data load and retrieval performance.
Cloud Expertise:
o Preferred experience working within the AWS environment.
o Familiarity with different format of data files (Parquet files, JSON, Semi-Structure) and moving & managing files in Amazon S3 layer.
o Process data into Amazon Redshift using Glue and Lambda.
o Automate repetitive tasks within the data pipeline using Python/glue/Informatica.
Problem Solving and Troubleshooting:
o Investigate and resolve system issues, bugs, and performance bottlenecks.
o Provide timely support to end users and address their queries.
Business Process Improvement:
o Identify opportunities for process automation and optimization.
o Propose system enhancements to streamline workflows and improve efficiency.
o Conduct thorough analysis of existing systems, processes, and workflows to identify areas for improvement.
Collaboration and Communication:
o Work closely with cross-functional teams, including stakeholders business analysts, developers, and project managers.
o Communicate effectively to bridge the gap between technical and non-technical stakeholders.
Principal Duties & Responsibilities
Communicates with project lead and internal teams via email and direct conversation to overcome obstacles and resolve any problems.
Prioritizes troubleshooting issues, and consults with subject matter experts to troubleshoot complex production-related bugs.
Participates in project review sessions to communicate project status and discuss complex issues.
Prioritizes issues and consults with subject matter experts to resolve complex production-related bugs.
Actively manages team project priorities, deadlines, and deliverables for a single project.
Creates and reviews functional and/or system specifications that meet business user requirements, often for multiple large scale projects.
Leads collaboration with more junior and senior Systems Analysts and business partners to document and present recommendations for improvements to existing and new applications and systems.
Identifies resources, delegates work, and reviews the work of team members in order to address changing timelines or priorities.
Manages designated work unit by translating business plans into tactical action items, ensuring all guidelines are followed, delegating tasks to meet goals and objectives, and overseeing the completion of work assignments.
Helps team members to determine which work tasks are most important, manages distractions, and deals with setbacks in a timely manner.
Requirement:
Qualifications:
Bachelor's degree in computer science, Information Systems, Supply Chain or related field (or equivalent experience).
Proven experience in data modeling, ETL development, and cloud environments.
Strong SQL skills and ability to optimize queries.
Familiarity with reporting tools (Tableau, Qlikview, OAC, Business Objects, Power BI).
Understanding of supply demand analysis, material planning, procurement, order management, inventory and supply management, logistic coordination, and continuous supply chain improvement
Excellent communication skills and a commitment to excellence.
Top 5 Required Skills
1 Requirement gathering and analysis
2 Data modeling, ETL development, and cloud environments
3 Strong SQL skills
4 Familiarity with reporting
5 Experience working in Supply Chain Management
Technologies (specific tools and/or programs you would want to see on their resumes)
Tableau, Qlikview, OAC, Business Objects, Power BI
AWS, Python/glue/Informatica
Keywords (specific words, projects, programs you would want to see on their resumes)
Tableau, Qlikview, OAC, Business Objects, Power BI, AWS, Python, glue, Informatica
Supply Chain Management, Inventory Management, Enterprise Data Warehouse
Education Requirement
Bachelor's degree in computer science, Information Systems, Supply Chain or related field (or equivalent experience)
Min Required Years of Experience
3
IT Core Competencies
Accountability - Hold one's self and others accountable for measurable quality, timely and cost-effective results, and accepts responsibility for impacts to the business and changes to business processes.
Adaptability - Adjusting own behaviors to work efficiently and effectively in light of new information, changing situations and/or different environments.
Collaboration - Fosters working together by establishing, communicating, and reinforcing shared values, norms, and objectives.
Communication - The ability to effectively exchange information with stakeholders in addition to the ability to accurately hear and understand the partially expressed thoughts, feelings, and concerns of others.
Financial Acumen - Ability to understand in-depth financial information that can be used to make meaningful insights to drive business growth in a safe and transparent environment.
Influence - The ability to accomplish goals through others.
People Development - Models and creates an environment that promotes career development.
Strategic Focus - Applies a comprehensive approach using business acumen and industry research to solve systematic complexities that promote growth.
Additional Competencies (All competencies below are required upon entry)
Analytical Skills - The ability to collect information and identify fundamental patterns/trends in data This includes the ability to gather, integrate, and interpret information from several sources.
Applications - Basic knowledge of application architecture specifically related to performance and troubleshooting.
Creating the New and Different - The ability to approach problems with curiosity and open-mindedness This includes developing personal creativity, approaching the problem differently, and asking for others' opinions This also includes exposing one's self to new ideas, trends, and environments.
Decision Making - The ability to make quick, accurate decisions This includes the ability to weigh alternatives and take into account the impact of the decisions on people, equipment, or other resources.
Demonstrating Personal Flexibility - The ability to demonstrate resourcefulness and resilience in the face of change, obstacles, and adversity This includes adapting to competing demands and shifting priorities This also includes improving adaptability, pursuing new skills and knowledge, and regularly seeking feedback from others.
Focusing on the Customer - The ability to effectively identify and address key customer needs This includes leading others to maintain focus on customers and seeking information to uncover a true client need.
Project Management - Knowledge of project lifecycles This includes an understanding of methodology attributes such as entrance and exit criteria for assigned project stages, team roles and responsibilities, and tools and techniques This also includes the ability to plan activities within a project stage and report on progress.
Root Cause Analysis - The ability to understand the cause of an issue and contribute to identifying the appropriate solution.
Systems Analysis - Knowledge of how a system should work and how routine changes in conditions, operations, and the environment will affect outcomes.
Taking Initiative - The ability to attack work activities with drive and energy, understand the impact of work on key metrics, and make decisions that are in the company's best interest This includes not being afraid to initiate action before all the facts are known, and driving value-added work tasks to completion.
Testing - Understanding of testing methodologies and testing-related tools
Time Management - The ability to quickly prioritize mission-critical from less important or trivial work activities This includes sensing what the next most useful thing is to work on, and focusing on the critical few tasks that add value while putting aside or delaying the rest.
Physical Requirements
Push Max Weight Limit = 5
Pull Max Weight Limit = 5
Lift Max Weight Limit = 5
Forklift Required (Y/N): N
Additional Physical Requirements
Frequently transports between offices, buildings, and campuses up to mile.
Frequently transports and installs equipment up to 5 lbs.
Performs required tasks at various heights (e.g., standing or sitting).
Monitors and utilizes computers and test equipment for more than 6 hours a day.
Continuous communication which includes the comprehension of information with colleagues, customers, and vendors both in person and remotely.
Driving Requirements
Are there driving responsibilities no matter how minimal with this role? No
(If Yes)How many hours per week? n/a