Exciting opportunity for an IT Systems Analyst with expertise in SQL, PLSQL, Oracle DBMS, and Linux Shell Scripting! Leverage your skills to manage end-to-end projects, create detailed user stories, and collaborate with development teams. Ideal for professionals with strong analytical skills and experience in Data Warehousing, ETL, and XML. If you're passionate about process improvement and bridging business requirements with development teams, this is the role for you!
location: Alpharetta, Georgia
job type: Contract
salary: $34 - 45 per hour
work hours: 9am to 6pm
education: Bachelors
responsibilities:
- Business Requirements Preparation: Review business requirements and translate them into use cases, screenshots, and examples for new features. This involves working closely with stakeholders to ensure clarity.
- Creating User Stories: Write detailed user stories from business requirements, ensuring the development team has a clear understanding of the logic needed to implement features.
- End-to-End Project Tasks: Oversee all tasks in the project lifecycle, including testing and delivery of user stories within established service level agreements (SLAs).
- Updating Status: Keep track of the project phase and regularly update the status of user stories, ensuring alignment with the project timeline and objectives.
- Gap Analysis: Analyze business requirements for any gaps or areas of ambiguity and work with relevant teams to fill in those gaps for smoother project execution.
- Review and Validation: Participate in reviews of functional specifications, confirming understanding of the requirements and validating them for correctness.
- Coordination with Teams: Work cross-functionally with various teams, such as functional user representatives, development, and RUN teams, to ensure the successful testing and implementation of change requests.
- Technical Skills Application: Use technical skills, particularly in SQL, PLSQL, Oracle DBMS, and Linux Shell Scripting, to support tasks and troubleshooting.
- Data Warehousing and ETL: Apply knowledge of data warehousing and ETL concepts in projects where relevant, contributing to the data flow and integration processes.
- XML Basics: Leverage knowledge of XML to assist with system integration tasks or data exchanges between systems.
qualifications:
- Bachelor's Degree: A degree in Computer Science, Information Technology, Business Administration, or a related field.
- Certifications:
- Oracle Certified Professional (OCP) or Oracle Database Administrator certification.
- SQL Server Certification or equivalent.
- Certified Scrum Master (CSM) or equivalent Agile certifications, especially for roles involving user stories and project management.
- ITIL Certification for service management and process understanding.
- Certified Business Analysis Professional (CBAP) for advanced business analysis skills.
- Industry Experience:
- 3-5 years of experience in business analysis, systems analysis, or project management.
- 3-5 years of experience with SQL, PLSQL programming, and working with Oracle DBMS in a production environment.
- 3-5 years of experience in software development, implementation, and testing.
- Experience working with Linux Shell Scripting in an enterprise setting.
- 2-3 years of experience in data warehousing and ETL processes is a plus.
- Experience with XML-based systems and integrations.
- Technical Experience:
- Strong hands-on experience in business requirements gathering and use case development.
- Proficiency in creating and managing user stories and working with Agile methodologies.
- Experience with systems integration, including working with cross-functional teams for testing and change implementation.
- Additional Skills:
- Project Management or Agile Project Management experience with tools like JIRA or Trello.
- Familiarity with Data Warehousing Concepts and ETL tools for data integration.
- Knowledge of cloud platforms and DevOps practices is an advantage.
skills:
- Strong Analytical Skills: Ability to analyze complex data and business requirements to identify patterns, gaps, and solutions.
- Effective Communication: Excellent verbal and written communication skills for interacting with teams and stakeholders.
- Requirements Gathering: Proficient in gathering business requirements and translating them into clear, actionable items for development.
- Business Case Preparation: Ability to prepare business requirements using use cases, screenshots, and examples for new features.
- User Story Creation: Expertise in creating user stories for development teams with clear and detailed explanations of logic and functionality.
- Project Management: Ability to handle end-to-end project tasks, including testing and delivery, while adhering to established service level agreements (SLAs).
- Gap Analysis: Skill in identifying gaps in business requirements and working with stakeholders to resolve them.
- Functional Specification Review: Experience in reviewing and validating functional specifications to ensure alignment with business needs.
- Cross-functional Collaboration: Skilled at working with functional user representatives, development teams, and RUN teams to implement and test changes.
- SQL and PLSQL Programming: Proficiency in writing and debugging SQL queries and PLSQL programming.
- Oracle DBMS Knowledge: Strong understanding of Oracle Database Management Systems and related functionalities.
- Linux Shell Scripting: Familiarity with shell scripting in a Linux environment for system integration and automation.
- Data Warehousing and ETL: Knowledge of data warehousing concepts and ETL (Extract, Transform, Load) processes.
- XML Basics: Basic understanding of XML for system integrations and data exchanges.
- Problem-Solving Skills: Ability to identify issues and provide effective solutions quickly and efficiently.
- Attention to Detail: Precision in ensuring that business requirements and technical specifications align perfectly.
- Team Player: Strong ability to collaborate and work effectively with teams across various functions and roles.
- Time Management: Ability to manage multiple tasks and deadlines effectively in a fast-paced environment.
- Quality Assurance: Experience in performing quality assurance tasks, including testing user stories and validating functionality.
- Adaptability: Ability to adapt to changing project requirements and environments, ensuring project success.
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).
This posting is open for thirty (30) days.
