Job Description:
We are seeking a Systems Analyst, Staff for a very important client
Job Description:
Analyzes complex business problems to be solved with automated systems Provides technical expertise in identifying, evaluating and developing systems and procedures that are cost effective and meet user requirements Configures system settings and options; plans and executes unit, integration and acceptance testing; and creates specifications for systems to meet business requirements Designs details of automated systems May provide consultation to users in the area of automated systems May lead cross-functional linked teams to address business or systems issues.
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.
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 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:
Top 5 Required Skills (These are not preferred skills. If the candidate does not have these required skills, they will be rejected completely)
1 Strong understanding on financial modeling, Forecasting and Planning.
2 Expertise in AWS Cloud services (Lambda, Glue, Redshift, Athena)
3 Expertise in handling financial data, databases, and data integration Oracle SQL, PL/SQL
4 Knowledge of SQL, data warehousing, and data visualization tools (such as Tableau)
5 Stakeholder Engagement, Problem solving and troubleshooting skills.
Technologies: What does this temp must know to perform the required job duties (These are not preferred technologies - If they do not have these technologies they will be rejected completely)
AWS Cloud services (Lambda, Glue, Redshift, Athena)
Data Visualization Tools: Tableau, Power BI or Qlikview
Required Education:
Bachelor's degree
Required Years of Experience:
5 years of IT-relevant work experience with a Bachelor's degree.
OR
7 years of IT-relevant work experience without a Bachelor's degree.
Key Words:
Data Integration, AWS Cloud services (Lambda, Glue, Redshift, Athena)
Informatica, IICS, Oracle SQL, PL/SQL, Tableau, Power BI.