SDLC Compliance & Reporting Analyst

Must Have Technical/Functional Skills

Advanced Excel/VBA

SDLC Governance

Compliance Reporting

Release Controls

Application Team Coordination

Roles & Responsibilities

We are seeking a detail-oriented SDLC Compliance & Reporting Analyst with strong expertise in Microsoft Excel, VBA/VB macro development, and software delivery lifecycle (SDLC) processes. The individual will support release governance and compliance reporting activities by maintaining reporting solutions, validating SDLC artifacts, coordinating with application teams, and ensuring adherence to established release and control processes. This role will play a key part in helping the organization transition to a more structured and controlled SDLC workflow. The responsibilities align closely with the customer's current SDLC governance and compliance monitoring activities.

Key Responsibilities

Maintain, enhance, and troubleshoot Excel-based reporting solutions and VBA/VB macros.

Develop and manage compliance dashboards, scorecards, and management reports.

Analyze SDLC and release compliance reports to identify gaps, inconsistencies, and missing artifacts.

Coordinate with application development, QA, infrastructure, and release teams to ensure required SDLC documentation is completed and uploaded.

Follow up with project and application teams regarding missing approvals, checklists, evidence, and release artifacts.

Monitor compliance against release governance processes and quality gates.

Validate release documentation readiness prior to production deployment.

Support audits, governance reviews, and compliance assessments by providing accurate reporting and evidence.

Perform data extraction, cleansing, validation, and transformation activities using Excel and VBA automation.

Collaborate with stakeholders to improve reporting efficiency and identify opportunities for automation and process optimization.

Assist in transitioning manual governance and reporting processes toward a more mature and controlled workflow.

Technical Skills

Strong hands-on experience with:

o Microsoft Excel (Advanced)

o VBA/VB Macro Development

o Pivot Tables, Power Query, Advanced Formulas

o Dashboard and Management Reporting

o Data Analysis and Reconciliation

Ability to troubleshoot and enhance existing Excel/VBA applications.

SDLC & Process Knowledge

Good understanding of:

o Software Development Life Cycle (SDLC)

o Release Management Pr ocesses

o Change Management

o Quality Gates and Governance Controls

o Production Readiness Reviews

o Compliance and Audit Requirements

Soft Skills

Strong communication and stakeholder coordination skills.

Ability to engage application teams and challenge incomplete or non-compliant submissions.

Strong analytical and problem-solving capabilities.

Detail-oriented with a focus on process adherence and accuracy.

Ability to work independently in a governance-driven environment.

Preferred Qualifications

Experience supporting compliance, PMO, governance, or release management functions.

Exposure to Workfront, ServiceNow, Jira, Azure DevOps, or similar workflow tools.

Experience with Power BI or Power Apps is a plus.

Prior experience in Banking, Financial Services, or other regulated environments is preferred.