Consultant - Software Engineer

General Position Information

Reports directly to (Title): Director or Senior Director, Business Operations

Matrix reports to (Title): As applicable

Direct Reports: Individual contributor; no direct reports

Created / Last Revised: -

Job Code: -

Position Summary

As a Backend Developer your primary responsibility will be to contribute to the development, maintenance, and optimization of server-side applications that power our digital solutions. You will play a vital role in shaping the core functionality of our systems, ensuring seamless data flow, and collaborating with cross-functional teams to deliver high-quality software. This role offers a unique opportunity to gain hands-on experience in backend development, work on diverse projects, and cultivate a strong foundation in server-side programming.

Responsibilities

Collaboration

• Work closely with cross-functional teams, including product managers, designers, engineers, and third-party partners, to ensure the backend development aligns with overall project goals.
• Participate in discussions and planning sessions to understand project requirements and contribute to the design and architecture of server-side applications.

Development

• Design, develop, and maintain SQL Server database objects (Stored Procedures, Functions, Views, Triggers).
• Develop, enhance, and support SSIS packages for ETL and data integration.
• Migrate SSIS workloads to Azure (SSIS in Azure Data Factory / SQL MI).
• Develop and support .NET applications using C#, ASP.NET / ASP.NET Core.
• Perform Lift & Shift migrations of SQL Server databases from on-prem to Azure SQL Managed Instance.
• Analyze .NET + SQL + SSIS workloads for Azure compatibility.
• Resolve migration issues related to performance, data consistency, and connectivity.
• Perform SQL and SSIS performance tuning.
• Design, develop, and maintain robust .NET Core applications and services, ensuring they meet performance and reliability standards.
• Develop and maintain RESTful APIs for seamless integration with front-end applications, adhering to industry standards and best practices.
• Implement data exchange formats such as JSON and XML to ensure compatibility and smooth communication between server-side and client-side components.

Coding

• Write clean, efficient, and well-documented code for server-side applications, following coding standards and best practices.
• Ensure code quality through regular code reviews and adherence to coding guidelines.
• Utilize programming languages such as .NET for backend development.

Agile Practices

• Participate in Agile development processes, including Scrum practices, to ensure efficient and iterative development.
• Engage in regular code reviews, automated unit testing, end-to-end testing, continuous integration, and deployment to maintain high-quality code and rapid delivery.

Optimization

• Identify and resolve technical issues, bugs, and performance bottlenecks to enhance overall system performance.
• Debug and optimize backend code to ensure maximum efficiency and reliability.

Integration

• Collaborate with front-end developers to integrate user-facing elements seamlessly with server-side logic, ensuring a cohesive end-to-end application experience.
• Ensure that backend functionality aligns with front-end requirements and provides a smooth user experience.

Technical Skills

• Apply strong object-oriented design and analysis skills, leveraging design patterns to create scalable and maintainable code.
• Utilize knowledge of Microsoft Operating Systems and Application Servers to enhance backend development.
• Draw on experience with the entire software development life cycle to ensure that backend development processes align with industry standards and best practices.

Database Management

• Design and maintain databases, ensuring optimal performance, reliability, and data integrity for backend systems.
• Write efficient and optimized database queries for data retrieval and manipulation, contributing to the overall performance of the applications.

Education & Experience

• Bachelor’s degree in information technology, computer science or related fields.
• 8+ Years of relevant work experience including:
• 5+ year(s) of engineering, delivering and supporting production software products (required).
• 8+ year(s) experience with C#, Dot Net or Any cloud.

Must Have Skills

• Exceptional stakeholder service skills in a team-oriented, collaborative environment.
• Exceptional interpersonal skills to interface with all levels of the organization.
• Strong verbal and written communication with the ability to work with staff and business required.
• Experience with ASP.Net, .NET Core, Entity Framework and C# required.
• Strong knowledge with database design and development preferred – SQL/NoSQL DB.
• Design, develop, and maintain SQL Server database objects (Stored Procedures, Functions, Views, Triggers).
• Develop, enhance, and support SSIS packages for ETL and data integration.
• Perform SQL and SSIS performance tuning.
• Experience with Google Cloud and Microsoft Azure preferred.
• Experience with versioning control (GIT) preferred.
• Experience in designing Restful API microservices.
• Hands-on experience with Apache Airflow for workflow orchestration and Kafka for real-time data streaming.
• Experience with CI/CD pipelines using Jenkins, Argo CD, and similar tools.

Nice To Have Skills

• Strong focus on delivering stakeholders value required.
• Excellent troubleshooting, analysis, and problem-solving abilities require.
• Willingness to learn our business domain required.
• Experience with continuous integration and continuous deployment preferred.
• Strong analytical and problem-solving skills.
• Ability to troubleshoot and debug complex issues.
• Proactive attitude toward learning new technologies and industry best practices.
• Ability to work collaboratively in a team environment.
• Willingness to contribute to a positive and inclusive team culture.

Licenses, Certifications & Training

N/A

Knowledge, Skills, Abilities, Behaviors

• Strong analytical and problem-solving skills with the ability to identify, troubleshoot, and resolve complex technical issues effectively.
• Excellent communication and collaboration skills, with the ability to work successfully across cross-functional teams and engage technical and non-technical stakeholders.
• Demonstrated ability to manage multiple priorities, work independently, and deliver high-quality results in a fast-paced environment.
• Strong sense of ownership, accountability, and commitment to continuous improvement, operational excellence, and customer satisfaction.
• Adaptable, proactive, and eager to learn new technologies, with the ability to quickly adjust to changing business and technical requirements.