No more applications are being accepted for this job
- Requirement gathering and analysis
- Data modeling, ETL development, and cloud environments
- Strong SQL skills
- Familiarity with reporting
- Experience working in Supply Chain Management
Systems Analysis - San Diego, United States - Apolis
Description
Title:
Systems Analysis - Systems Analyst, Staff
Location:
San Diego, CA, 92121
Duration: 12+ Months
Pay Rate: 67/hr on w2
Required 5+ years of Industry experience.
Top 5 Required Skills
Qualifications:
Bachelors 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.
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.
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 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.
#J-18808-Ljbffr