Data Software Engineer – Financial Systems
| Company | Sony Interactive Entertainment |
|---|---|
| Location | San Diego, CA, USA |
| Salary | $126300 – $189500 |
| Type | Full-Time |
| Degrees | |
| Experience Level | Senior |
Requirements
- 5+ years of experience in software engineering
- Strong analytical and problem-solving skills
- Understanding of basic accounting and industry business models such as subscriptions, preorders, royalties, revenue sharing, and bounties
- Sound understanding of relational database systems such as Oracle or Snowflake, database and data warehouse design and loading, and working with very large datasets
- Experience in SQL window functions and other SQL analytical functions
- Experience with data ETL tools such as Informatica or data pipeline design and development
- Familiarity with cloud (AWS) architecture services (EC2, S3, EFS, MSK, Lambda), distributed systems and backend architecture
- Experience with event-driven architecture using Apache Kafka (AWS MSK) and Golang
- Proficiency in programming languages such as SQL, Linux shell scripting, Golang, JavaScript, NodeJS
- Ability to operate independently with minimal supervision
- Experience working effectively with offshore / near shore service providers
- Passion for pursuing new technologies and constantly learning
Responsibilities
- Participating in the 24×7 production support of a finance technology stack in an AWS cloud environment
- Supporting business critical jobs, including successful processing over monthly accounting close
- Participating in operations team to monitor system alerts; respond to job failures, and work on all issues which impact finance systems stakeholders
- Delivering root cause analysis for difficult and complex issues faced by the finance systems team
- Analyzing transaction level detail to uncover processing gaps and respond to complex queries from finance, tax, and compliance departments
- Developing custom reports for finance to support finance, legal, audit, and other teams
- Financial data and application design utilizing Golang, SQL, JavaScript, NodeJS languages
- Being agile and capable to switch between operations and development roles as needed
- Using independent judgement and applied skills to develop new programs and processes to expand finance systems functionality
- Working independently and collaboratively
- Providing high levels of technical skills to deliver best results in the industry
- Other duties as assigned
Preferred Qualifications
- Nice to have experience in developing and supporting an event-driven architecture (EDA) with proven hands-on experience coding using Golang or similar languages
- Nice to have hands-on experience with bash shell scripting, Git-hub version control and Jenkins automation
- Working with issue tracking tools (e.g. JIRA, Service Now)
- Familiarity with collaboration tools (e.g. Confluence, Trello)
- Experience with communication tools (e.g. Slack, Webex, Skype for Business)
- Knowledge of version control systems (e.g. Github)
- Experience with automation tools (e.g. Jenkins, Ansible, CloudFormation, Terraform)
- Working within controlled/compliance-based environments (particularly Sarbanes Oxley) would be beneficial