Software Engineering & Development, AVP
State Street1 day ago
Base Salary
$90k - $158k/yr
Responsibilities
- Design and develop database-driven enterprise applications based on business requirements.
- Coordinate development activities among business analysts, developers, and testing teams.
- Perform technical design, estimation, application build, configuration, unit testing, and production deployment.
- Develop SQL and PL/SQL programs and database objects including views, materialized views, stored procedures, and triggers.
- Build data pipelines and ETL jobs across multiple data sources.
- Optimize database performance, scalability, storage growth, security, and compliance.
- Troubleshoot database performance and production issues and provide workarounds or escalate to service owners.
- Validate data populated in target containers through unit testing and ensure quality and accuracy.
- Support event-based, micro-batch, and batch processing systems handling high-volume and high-velocity transactions and data.
Requirements
- Bachelor’s degree required.
- At least 10 years of experience in a relevant database development role.
- Hands-on database development, data modeling, database design, performance tuning, and troubleshooting experience.
- Strong SQL and PL/SQL programming experience, including creation of database objects.
- Experience with Oracle RDBMS, AWS services, RDS, PostgreSQL, and Redshift.
- Experience building scalable, resilient, cloud-native architectures and data pipelines for ETL jobs.
- Knowledge of AWS cloud security, including IAM roles and policies, security groups, and encryption keys.
- Experience with GitHub or another code repository and a cloud controller or release management tool.
- Financial services industry experience preferred.
- Ability to keep current with cloud database technologies.
Benefits
- Hybrid work arrangement requiring four days per week in the Boston, Massachusetts office and one remote day.
- Monday–Friday schedule, 9:00 AM–5:00 PM Eastern Time.
- 401(k) retirement savings plan with company match.
- Insurance coverage including life, medical, dental, vision, and long-term disability options.
- Paid time off including vacation, sick leave, short-term disability, and family-care leave.
- Employee Assistance Program and tax-advantaged savings plans.
- Eligibility for incentive compensation and annual performance-based awards.
- Inclusive development opportunities, flexible work-life support, paid volunteer days, and employee networks.
Tech Stack
Categories
BackendData Engineering
About State Street
State Street is a global custodian bank and asset manager serving institutional investors with investment servicing, fund accounting, trading/FX, data, and index/active strategies. Its products include State Street Global Advisors’ funds and ETFs, the Charles River Investment Management Solution, and the front-to-back State Street Alpha platform. Founded in 1792 and headquartered in Boston, the company is publicly traded on the NYSE (ticker: STT) and operates across major markets worldwide.