Data Systems Software Engineer 2

Job description

Delivers scoped features with moderate supervision. Designs simple schemas and queries for Online Transaction Processing use cases; adds endpoints and integrates with Representational State Transfer services. Investigates performance regressions using logs and metrics; writes unit/integration tests and adheres to coding standards. Collaborates with product and user experience on acceptance criteria and measures feature adoption basics.

Responsibilities

Key Responsibilities

Data Systems Software Development: Design and optimize straightforward schemas and queries for targeted use cases and reports. Build and evolve Representational State Transfer endpoints backed by Oracle Database with measurable performance goals. Instrument features to track adoption and conversion; analyze basic dashboards to propose follow-ups. Contributes to the implementation or development of existing and new services.

Software Development and Coding

Design, Testing, and Optimization

• Contributes to designing software solutions and analyzes requirements to achieve business and operational goals, with limited guidance. Adheres to all phases of the software development lifecycle.

Applies working knowledge to develop and review code for new software features and enhancements following design specifications and develops documents to clarify software design and code. Conducts debugging and troubleshooting to identify and fix simple and moderately complex software issues. Develops fixes for identified issues. Implements software testing (e.g., functional testing), quality assurance processes, software error logging, monitoring, and observability for effective debugging, following established frameworks.

Supports the implementation of standard and non-standard performance profiling and optimization of coding. Troubleshoots and resolves standard and non-standard issues related to application programming interface (API) functionality and integration. Implements standard and non-standard API versioning, lifecycle, and interoperability strategies. Issue/Defect Collaboration

Software Products Support

• Collaborates with own team and begins to network outside of team to understand customer issues and align solutions. May provide technical guidance and support to customers regarding customer-reported issues, with limited supervision.

Assists peers to advocate for customers' interests and suggests product enhancements based on feedback. Influences efforts to ensure customer satisfaction through timely resolution of issues and effective communication. Utilizes working knowledge to implement customer issue and/or defect handling and training processes, with some guidance. Collaborates with experienced colleagues to investigate and troubleshoot product maintenance issues to ensure customer agreement on short- and long-term solutions.

Practices and Standards Compliance

Security and Compliance

• Begins to collaborate with the team to establish and follow development practices and coding standards. Assists in ensuring code quality and adherence to broad acceptance criteria during development.

Demonstrates working knowledge of industry best practices and applies them to software development processes. Assists in implementing secure coding practices to prevent security vulnerabilities. Development Operations

System Maintenance

• Performs periodic maintenance and testing operations for systems that require upgrading or patching (e.g., for critical vulnerabilities), with limited guidance. Assists in driving improvements, ensures automation, testing, and debugging of systems to ensure service/product availability, health, support, and reliability.

Core Responsibilities

Planning & Execution: Tracks timelines with minimal supervision, ensuring work is completed in a timely manner and is in alignment with project requirements. Prioritizes and adjusts work as resources or timelines change, with some guidance.

Collaboration & Partnership

Collaborates within a team to better understand expectations and achieve shared objectives. Leverages a foundational understanding of business, stakeholder, and/or customer needs to build partnerships with limited guidance. Actively listens and asks questions to enhance collaboration.

Problem Solving

Identifies and addresses issues, escalating problems to senior staff as needed in accordance with standard procedures. Compiles and reviews data and/or information from multiple sources to troubleshoot standard and non-standard errors.

Continuous Learning

Seeks opportunities to gain knowledge and learn new skills and/or tools aligned with industry trends and best practices. Utilizes feedback and training to improve skills. Participates in a culture of continuous learning and knowledge sharing.

Continuous Improvement

Implements updates to processes, protocols, and workflows to increase efficiency and effectiveness as directed with some guidance. Contributes to ideation for future process improvements.