Senior Analyst, Business Systems

Davis Polk & Wardwell LLP•New York, NY

11d

About The Position

The Senior Analyst is responsible for designing, developing, and supporting a wide range of software programs. This role works closely with business users to understand requirements, recommend effective technical approaches, and deliver scalable, secure, and efficient applications that support firmwide business needs.

Requirements

Minimum of 10 years of professional software development experience, with strong proficiency in C#, .NET, ASP.NET Core, and modern web application architecture.
Extensive experience with modern front-end development, including Blazor, React, Angular, JavaScript/TypeScript, HTML, and CSS, with a strong understanding of responsive design, UI/UX best practices, and component libraries such as Material UI and Bootstrap.
Strong proficiency in T-SQL, including window functions, CTEs, query optimization, indexing strategies, execution plan analysis, and debugging complex data issues across joins, aggregations, and data pipelines.
Experience with data warehousing and modern data engineering practices, including dimensional modeling, fact/dimension design, and slowly changing dimensions.
Hands-on experience with Microsoft Azure, Azure DevOps, CI/CD pipelines, RESTful APIs, web services, and source control systems such as Git, GitHub, TFS, and SVN.
Experience developing, implementing, or supporting AI solutions that enhance automation, productivity, and user workflows.
Bachelor’s degree required.
Minimum of 10 years of professional software development required.
Minimum of 5 years of hands-on experience with Microsoft SQL Server required.

Nice To Haves

Experience with the Dagster orchestration and DBT transformation framework is a plus.
Familiarity with additional technologies such as Python, Node.js, ColdFusion, Java, PowerShell, Linux shell scripting, VB.NET, VBA, Perl, PHP, and related development tools is a plus.
Exhibits adaptability and willingness to learn new skills/technologies.
Strong verbal and written communication skills, with the ability to convey technical concepts to non-technical users.
Prior experience in a professional services organization strongly preferred.

Responsibilities

Collaborate with business stakeholders to gather, assess, and refine requirements for new application requests, and recommend the most effective approach for implementation.
Design, develop, test, and support scalable, secure, and efficient applications while working directly with end users to ensure requirements are incorporated throughout the development process.
Support SQL database development, maintenance, performance tuning, security, and related data processes.
Apply best practices in application design, development, testing, security, and performance.
Build responsive front-end interfaces and intuitive user experiences across devices.
Develop back-end functionality, including server-side logic, database integrations, APIs, and web services.
Develop and support AI-enabled solutions that improve business processes, automation, and user experience.
Troubleshoot, debug, and validate applications and data-related issues to ensure reliable functionality, performance, and accuracy.
Maintain documentation for owned applications and provide backup support for applications developed by others.
Stay current with emerging technologies, development tools, and modern development practices.
Regularly review application performance, stability, security, and overall health to ensure systems are operating efficiently.