Data Systems Software Engineer 2

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.

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.