Lead Application Developer

ADP • Salem, NH

2d • Hybrid

About The Position

ADP is seeking a Lead Application Developer to drive end-to-end solution delivery across our application portfolio. This role combines hands-on development with technical leadership—guiding design, code quality, data integration, and reporting capabilities across a complex ecosystem that includes .NET, SQL Server, Oracle/Oracle APEX, Salesforce, and ADP data sources. The ideal candidate is a strong problem solver who can translate business needs into scalable, secure, and maintainable solutions.

Requirements

• 7+ years of professional software development experience, including lead developer responsibilities.
• .NET expertise: VB.NET, C#, ASP.NET, and .NET Core for APIs, web apps, and services.
• SQL Server proficiency: Expert-level TR-SQL (queries, indexing strategies, stored procedures, performance tuning).
• Oracle experience, including APEX application development preferred.
• Reporting & BI: SSRS and/or comparable BI tools used to build operational dashboards.
• Salesforce experience (data model familiarity, API integration, authentication flows).
• Data ecosystem knowledge in ADP: awareness of core data sources such as Databricks, Oracle, DB2, SQL Server instances, and how to design integrations with them.
• ADP RS SORs understanding and how systems-of-record impact integration, data quality, and reporting.
• REST API consumption: authentication (OAuth 2.0/Bearer), pagination, error handling, and resilience patterns.
• Technical writing capabilities: architecture diagrams, sequence flows, ADRs, and runbooks.

Nice To Haves

• Experience with CI/CD (Azure DevOps, GitHub Actions, or similar), automated testing, and infrastructure-as-code basics.
• Familiarity with Databricks (Spark SQL, Delta Lake concepts) and ETL/ELT patterns.
• Performance tuning across application, database, and API layers; profiling and observability (App Insights, logging/metrics).
• Data governance and security best practices (PII handling, RBAC, encryption at-rest/in-transit).
• Exposure to SSIS, Power BI, or other enterprise BI platforms.
• Prior experience integrating ADP products and datasets at enterprise scale preferred.

Responsibilities

• Own solution delivery across the full SDLC: requirements, design, development, testing, deployment, and support.
• Design and build .NET applications (VB.NET, C#, ASP.NET, .NET Core) with clean architecture and testable patterns.
• Develop robust data layers using SQL Server (T-SQL queries, views, functions, stored procedures) and Oracle (PL/SQL) and build apps in APEX where appropriate.
• Create dashboards and reports using SSRS and/or other BI tools; establish data models and govern data refresh and access.
• Integrate systems via REST APIs (consume and orchestrate), including Salesforce and internal/external services.
• Leverage ADP data (e.g., Databricks, Oracle, DB2, SQL Server instances) and apply ADP RS SORs understanding for authoritative data sourcing and data lineage.
• Author high-quality technical documentation (solution designs, data dictionaries, specs, deployment guides).
• Partner with product owners and business SMEs to clarify requirements, size work, and prioritize backlogs.
• Champion best practices in security, performance, reliability, and observability.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed