Sr Software Engineer

About Our Company We're a diversified financial services leader with more than $1.5 trillion in assets under management, administration and advisement as of year-end 2024. Our team of 22,000 people across 19 countries, serves more than 3.5 million individual, small business and institutional clients. We are a longstanding leader in financial planning and advice, a global asset manager and an insurer. Our unwavering focus on our clients and strong financial foundation connects each of our unique businesses - Ameriprise Financial, Columbia Threadneedle Investments and RiverSource Insurance and Annuities. Here, we foster meaningful careers, invest in the future, and make a difference for clients, institutions and communities around the world. Job Description Serve as a resource on software development projects and lead the development team through the design, development, documentation, testing, and modification of existing and new software applications, championing standard techniques, procedures, and criteria. Participate in architecture design, performance monitoring, product evaluation, and buy versus build decisions. Track and communicate development project status, dependencies, and risks and mitigation strategies to the project team and leadership. Provide technical expertise to the business. Key Responsibilities Execute and/or oversee the creation of low level design documents (including code samples/outlines) and detailed engineering specifications based on complex business, user, and non-functional (e.g. performance, reliability, balance, and controls) requirements. Write code that adheres to standards, procedures, and techniques. Maintain integrity of existing program logic according to specifications. Complete deliverables using the Software Development Life-Cycle (SDLC). Partner with the business and project team to gather requirements and fully understand project goals, and then use this information to effectively plan and lead the development process. Participate in project design walk-throughs. Evaluate interrelationships between applications and design for effective interfaces between interrelated applications/systems. Appropriately address failure scenarios in design work. Proactively review then plan and execute corrective action in response to production support issues, as required. Lead the code review process to ensure development work adheres to standards and specifications, which includes peer review, as well as code review external to development team. Write and/or revise system design documentation and operations documentation to include providing required input into operation support manuals and user guides. Create and properly archive all project related documentation. Ensure all code is effectively unit tested prior to being released to the quality assurance team. Resolve all unit test issues in a timely manner. Assist the quality assurance team in identifying test cases and in creating/mining test data to enable a thorough test of all development deliverables. Respond to all inquiries and issues in a timely manner as the developed code/program moves through the testing process and into production. Approve code to be put into production. Provide oversight, mentorship, and technical leadership to a development team, which consists of employees, contractors, and vendor partner resources, to ensure the timely execution of project deliverables. Provide governance oversight to ensure adherence to development strategy, standards, tools, and procedures. Guide the development teams to consistently apply appropriate development principles and standards during all phases of the development life-cycle. Conduct annual asset health and security assessment. Improve health of system assets by identifying enhancements to improve performance, reliability, and resource consumption. Track standards exceptions (e.g. security gaps) to ensure they are addressed in a planful and timely manner. Evaluate, troubleshoot, and lead root-cause analysis for production issues and system failures. Determine corrective action and improvements to prevent recurrence. Provide implementation/production support, as required. Maintain up-to-date skills in software development technologies and a broad understanding of the business, business needs, and how applications/assets drive and support the business (understand the greater impact of assets/applications and development work). Provide expertise in the selection and implementation of development tools and best practices, as well as recommendations on priority and asset investments. Establish and maintain productive working relationships with business partners and project teams. Performs other duties as assigned Required Qualifications Bachelors degree or equivalent (4-years) in Computer Science, Engineering, or related field; or equivalent work experience. 7-10 years of relevant experience required. 7+ years of experience coding and/or designing in multiple programming languages, including focused experience in relevant/targeted software stack (specific required software stack will vary by position). 7+ years of practical experience and proven success with the design and build of complex software applications in multiple environments. Experience working with vendor partner (on- and off-shore) resources. Preferred Qualifications 7-10 years of experience in technology and/or software development, progressing in complexity and responsibility. Proven success in the design of complex, best-in-class enterprise-level software applications. Superior analytical and business skills to reconcile conflicting objectives and find/design acceptable compromises within existing constraints. Expert level application of technology/engineering knowledge-base to multiple and evolving programs and languages. Superior technical communication skills. Extensive experience with Oracle, SQL Server and T-SQL in constructing Procedures, Tables, Table Variables, User Functions, Views, indexes, CTE, Temporary Tables. Strong experience in working with indexes, SQL Scripts, Linked Server. Strong experience in creating maintenance plans, jobs and scheduling jobs. Strong Knowledge in Dynamic SQL (sp_execute, exec) Creation of Tables, Views, Indexes and Sequences. Writing Complex Queries, inline queries, Stored Procedures and Functions, CTE's Visa Sponsorship Applicants must have a valid work authorization that does not now, or in the future, require visa sponsorship for employment in the United States (e.g., H-1B, F-1 CPT, F-1 OPT, TN). In-Office Collaboration We are a client-centric, relationship-based business. Working together, in-person, is foundational to how we achieve results. By fostering a culture of face-to-face collaboration, idea sharing, productivity and personal connection, we deliver for our stakeholders - clients, advisors, employees and shareholders. Our employees work in the office at least four (4) days per week, with flexibility to work from home one (1) day per week. Some roles may require additional in-office time or different in-office expectations, and specific requirements will be discussed during the hiring process. Base Pay Salary The estimated base salary for this role is $131,700 - $181,000 a year. We have a pay-for performance compensation philosophy. Your initial total compensation may vary based on job-related knowledge, skills, experience, and geographical work location. In addition, most of our roles are eligible for variable pay in the form of bonus, commissions, and/or long-term incentives depending on the role. We also have a competitive and comprehensive benefits program that supports all aspects of your health and well-being, including but not limited to vacation time, sick time, 401(k), and health, dental and life insurances. Full-Time/Part-Time Full time Exempt/Non-Exempt Exempt Job Family Group Technology Line of Business TECH Technology Ameriprise Financial is an equal opportunity employer. We consider all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, national origin, ancestry, age, physical or mental disability, medical condition, pregnancy, military status, veteran status, genetic information, citizenship, disability status, marital status, family status or any other basis prohibited by law. We are committed to fostering an inclusive and accessible recruitment process for individuals with disabilities. If you require a reasonable accommodation to participate in the application or interview process, speak to your recruiter to discuss how we can support you. Ameriprise Financial