Taguig City, Philippines
Job ID: 23929
Section 1: Identifying Information
Systems Analyst Data Management – AWS
Edgar Bernardo Jambalos / Camille Alvarez
Global IS – Data Management
Positions reporting to this position
Target team size:
Section 2: Position Summary
Guidelines: Please provide a brief summary of the overall scope of the position.
The Systems Analyst – Data Management - AWS designs, develops, and implements, maintains, and supports end-user systems. Also responsible for defining application system requirements to solve complex business problems and write new application programs of moderate to significant complexity and scope. Maintains and modifies existing application programs. The Systems Analyst – Data Management - AWS is responsible for following the Ingram Micro chosen application’s development standards and methodologies. Primarily works on an independent basis within the guidelines given for delivery of technical work assignments.
Section 3: Responsibilities, Supporting Actions & End-Results
Guidelines: List the essential responsibilities, functions and/or activities, provide the supporting actions to describe how the work will be accomplished and provide the desired end results. List the responsibilities in order of importance and the estimated percentage of time for the responsibility (no one responsibility should be greater than 60% of time or less than 10%). The most important responsibility is not necessarily the one where the most amount of time is spent.
Major Responsibility:Systems Analysis and Design
Independently analyzes business problems and operational data from one or more sources to formulate solutions of moderate to significant complexity. Responsible for identifying various technical/application alternatives and clearly defining user specifications.
Analysis typically includes design of new programs of moderate to significant complexity and complex changes to existing programs. May involve design outside of subject matter expertise.
Analysis typically limited to small/medium projects or tasks within a large project.
Relies on others only for specific application knowledge or non-primary platform/application issues.
Creative in delivering value and carefully researched alternatives and system solutions to address customer/user requests.
Resolves technical issues and analyzes or develops solutions for application programs outside primary application knowledge.
Performs efficient and effective analysis and complete task level activities, which may include development of recommendations, process design changes, system specifications, and business analysis cases from the analysis performed.
Initiates and leads design reviews for own projects.
Directs interaction with application users, change requestors, and/or user/departmental middle management.
Works directly with functional department liaisons for key application area(s) to understand current processes and methodologies and work towards implementing efficiencies and where feasible, improving the current processes or system.
This position is responsible for developing, configuring, implementing and maintaining AWS systems.
Troubleshooting and resolving complex production support issues quickly and summarizing and reporting the results; producing appropriate documentation and notifications for changes to production systems or fixes to production problems.
Responsible for creating, enhancing and analyzing complex data metrics and procedures to improve the level of data integrity within the AWS systems.
Responsible for testing, configuring, documenting and preparing for system upgrades, patches, enhancements and other backend system developments.
Consult with AWS team to determine their goals and objectives for AWS systems; and will provide recommendations for achieving those goals and develop such solutions; creating unit and system testing scenarios and scripts, performing unit testing, assisting AWS team in system and UAT testing, and documenting testing results.
Provides advanced Level 2/3 support. Investigates operational or systematic problems and provides resolution using advanced analytical skills and tools as necessary.
Ensures that programs and projects are designed to support and implement the Organizations goals and objectives
The ability to troubleshoot service interruption incidents, identify the root cause and take corrective action.
Experience with the full application development lifecycle
Must be able to work independently
Must be able to manage constantly changing priorities
Must be able to complete assignments within the expected timeline
Experience supporting a 24X7 operational environment including acting as primary on-call contact on a rotating basis.
Ensures quality standards are met.
Other responsibilities as assigned.
End Results:Team continues to improve technical and functional skills in order to complete incidents within service level agreements to promote customer satisfaction.
Major Responsibility:Systems Development and Implementation
Designs and writes new programs with a moderate to high degree of complexity utilizing departmental systems development methodology, standard procedures, and techniques.
Prepares components of assignments for review and production implementation. To include program comparisons, detailed test results, user/technical/operational documentation, rerun/restart procedures, and other pertinent information.
Executes the Systems Development Methodology (SDM) for small projects.
Proficient in primary language, application, and platform.
Utilizes all development tools in primary application and/or platform.
Creates detailed programming specifications with consideration to efficiency and ease of maintenance.
Demonstrates increasing consideration of coding/development across multiple platforms/applications.
Interprets medium level business requirements into programming specifications.
Independently resolves abnormal terminations (Abends)/production issues.
Develops programs outside primary application and platform.
Proficient in primary database platform.
Systems development tasks may include new development, systems maintenance, or small enhancements in any of the following general areas: mainframe or client-server online systems, interfaces, or conversions, and web-based internet, intranet, or extranet-based applications.
Systems development supports, adheres to, and maintains current applications development standards and methodologies.
Responsible for installation and implementation of major, complex software systems. Ensures all program product software is properly prioritized, planed, tested and coordinated with the appropriate parties. Ensures all program product software changes are implemented in the time frame required and in a zero-defect manner.
Planning and organizing responsibilities. Schedules and prioritizes multiple projects. Determines the appropriate level of resources needed to staff projects.
End Results:Supports and guides LO and Development activities while empowering team members to take actions and make decisions.
Major Responsibility:Systems Maintenance and Support
Maintains and modifies existing application programs and write new programs of high complexity. Develops specifications based on end-user/customer requirements and design/scope necessary tasks.
Resolves technical issues and modifies application programs outside of primary application or platform.
Performs problem analysis, monitoring, determines and implements system solutions, escalate as appropriate to departmental management, and communicate resolution to appropriate Information Technology management and support personnel.
Systems development supports, adheres to, and maintains current applications development standards and methodologies.
Provides on-call support on normal rotations and take’s ownership of incidents and brings them to closure.
Responsible for meeting service level objectives and system availability. Identifies root causes of serious, complex problems and permanently resolves. Implements and uses the required software tools to proactively monitor the systems as well as recover the systems if required.
Initiates, supports and promotes change efforts. Understands the value of change and communicates this to others.
Maintains documentation to support DW/BI
End Results:Work towards implementing efficiencies and improving the current processes or system.
Section 4: Decision Making Authority Level
Guidelines: Describe the authority held by the position by listing the main decisions that the position is free to make and explain the decisions that depend on the position’s advice.
Decisions free to make:
Effective prioritization of problems and resolution plan.
Work assignment priorities.
Holds team members accountable and performs basic performance management.
Clearly communicates expectations. Coordinates and tracks the work of the team.
Prioritize issues and concerns requiring the attention of Management
Initiating Meetings and other communications to manage effective work flow and achieve desired results.
Explain the decisions that depend on position’s advice:
Resolution of incidents and SLAs being met.
Prioritization due to resource allocation impact.
Example decisions that depend on position’s advice:
Reallocation of additional associates to a critical incident.
Generation of weekly status report to management.
Section 5: Scope/Dimensions
Guidelines: List the main quantitative measures that define the size and scope of the position (headcount, budget, profit dollar target).
Collaborates with Business and other teams such as Data Management, Impulse, SEEBURGER and others
Part of local team of 2 headcount
Incident Triage. Ensures that requests, incidents, RFCs, and problem tickets are handled with urgency and completed in compliance with published SLAs...
Section 6: Job Qualifications and Educational Requirement
Guidelines: Provide the education, experience, skills and competencies necessary to perform the position.
2 to 3 years for Design and Development with expert knowledge of DW Architecture and ETL Processes. Strong programming skills in ETL
Knowledge of AWS Data Stack using S3, EMR, Data Pipeline. Cloud Formation Amazon, Redshift, VPC, IAM, Amazon Athena, Amazon Quick sight.
Worked on the CICD implementation using Jenkins.
Well versed in code repository management tools – GIT, TFS.
Develop and maintain system design documents to illustrate current and future architecture.
System Administration/Architecture experience.
Ability to diagnose and resolve system bottlenecks
Experience in capacity planning for computation and storage needs
Competency in developing solutions for diverse and complex business problems
Proactive, initiative taker, possess ability to work independently with minimal supervision
A collaborative working style and ability to work independently in a team environment
Excellent verbal and written communication skills
Ability to work under pressure, adapt to changing environments, manage multiple large projects
Section 7: IM Competencies
Guidelines: Provide the IM Competencies necessary to perform the position.
Develops Innovative Practices
Works as a Team Member
Acts with Integrity & Respect
Section 8: Other Information
Guidelines: Indicate any information that would be helpful in understanding the nature, scope or purpose of the position, or any unusual or hazardous conditions associated with performing the position.
Resource is willing to work on a shifting schedule (esp., night/graveyard shift - no exceptions)
Resource is willing to work on a rotating On Call Schedule (Week End Support)
Resource is flexible to work on holidays and weekends (i.e., project cutover or on-call support work)
Travel is probable for this position thus should not have travel restrictions (likely to US and India)