Senior SQL ETL Developer — SSIS/SSRS & Azure

TechDigital Group

Pittsburgh (Allegheny County)

On-site

USD 70,000 - 110,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

An established industry player is seeking a skilled developer with extensive experience in SQL Server and ASP.NET technologies. This role involves designing and implementing robust applications, utilizing ETL processes, and working with cloud services like Azure. You will collaborate with a dynamic team to deliver high-quality solutions while contributing to the development of innovative projects. If you are passionate about technology and eager to make a significant impact, this opportunity is perfect for you.

Qualifications

  • 6-10 years of experience in SQL Server, ETL, and ASP.NET technologies.
  • Proficiency in Azure and various testing frameworks is a plus.

Responsibilities

  • Develop and maintain applications using ASP.NET and SQL technologies.
  • Implement ETL processes and ensure data integrity.

Skills

SQL
ETL
SSIS
SSRS
ASP.NET
Classic ASP
VB.NET
Azure
C#
OpenQuery

Tools

Azure DevOps
Unit Test Frameworks
Angular

Job description

Business Systems Analyst
Program Technology Governance Intake & Approval Management System (built on ServiceNow)
Preferred Background Insurance industry; ServiceNow or comparable Service Management / Governance tool implementations


We are building a Technology Governance Intake and Approval Management system on the ServiceNow platform to standardize how technology requests are submitted, reviewed, prioritized, and approved across the organization. We are looking for an experienced Business Systems Analyst to partner with our Shared Services development team throughout the project lifecycle, from requirements discovery through UAT, Documenting BRD, System and Functional requirements, User Guides and go-live. This is a hands-on role requiring someone comfortable running structured elicitation sessions, writing detailed requirements and test artifacts.

Key Responsibilities
• Author clear, testable business and functional requirements documents (BRD/FRD) for intake workflows, approval routing, and governance controls within ServiceNow.
• Build and maintain a full requirements traceability matrix (RTM) linking business requirements to design, development, and test cases.
• Translate governance and approval policy/process into system workflows, forms, and business rules in partnership with ServiceNow developers.
• Develop detailed test plans, test scripts, and test cases (functional, regression, integration) covering intake, routing, approval, and reporting features.
• In partnership with the Head of Tech Governance plan, coordinate, and execute User Acceptance Testing (UAT) including entry/exit criteria, defect triage, sign-off, and stakeholder training support.
• Support process mapping and current-state/future-state analysis of governance and approval workflows.
• Act as liaison between business stakeholders, shared services developers, QA, and project working group, ensuring alignment and clear communication.
• Assist change management activities: training materials and adoption support.
• Creating documentation aligning with audit, compliance, and governance standards.

Required Qualifications
• 5+ years of experience as a Business Systems Analyst
• Proven experience writing business/functional requirements, use cases, and user stories for enterprise systems.
• Hands-on experience building and maintaining a requirements traceability matrix (RTM).
• Strong experience developing test plans, test cases, and executing/coordinating UAT.
• Strong stakeholder management skills, including the ability to navigate and resolve conflicting priorities across business and technical teams.
• Excellent written and verbal communication skills; able to translate business needs into clear technical requirements and vice versa.
• Experience working with cross-functional teams including developers, QA, architects, and cross-functional team.
• Proficiency with tools such as Confluence, Visio, and Microsoft Office/Excel for RTM and documentation.
• Strong analytical, problem-solving, and organizational skills; high attention to detail.

Preferred Qualifications
• Experience with the ServiceNow platform, particularly modules related to Governance, Risk & Compliance (GRC), IT Business Management (ITBM/PPM), Demand/Intake Management, or App Engine/workflow-based approval processes.
• Prior experience building or supporting a technology governance, intake, or approval management system/tool or equivalent.
• Insurance industry experience (P&C, Life, Health, or Reinsurance) and familiarity with insurance-specific governance, risk, and regulatory considerations.
• Experience with IT Service Management (ITSM) tools and processes (Incident, Change, Problem, Request Management).
• Business Analysis certification (CBAP, CCBA, ECBA/IIBA) and/or Project Management certification (PMP, CAPM, PMI-ACP).
• Understanding of audit, SOX, or regulatory compliance documentation.
Soft Skills / Attributes
• Detail-oriented with strong documentation discipline, balanced with the ability to see the big picture.
• Adaptable to shifting requirements and evolving project scope.

Deliverables Expected from This Role
• Business & Functional Requirements Documents (BRD/FRD)
• Requirements Traceability Matrix (RTM)
• Test Plan and Test Cases (functional, regression, integration)
• UAT Plan, UAT execution results, and sign-off documentation
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Azure-Powered Digital Health Solutions Architect
Azure-Powered Digital Health Solutions Architect

TechDigital Group • Oakland (CA)

On-site
USD 120,000 - 180,000
Strategic ServiceNow BA | Agile Partner & Platform Expert
Strategic ServiceNow BA | Agile Partner & Platform Expert

TechDigital Group • Charlotte (NC)

On-site
USD 80,000 - 120,000
ServiceNow Business Analyst
ServiceNow Business Analyst

Saicon • Omaha (NE)

On-site
USD 90,000 - 120,000
Sr. Business Analyst
Sr. Business Analyst

Sharp Solutions Inc • Ashburn (VA)

On-site
USD 90,000 - 125,000
ServiceNow Business Analyst
ServiceNow Business Analyst

The Planet Group • Newport News (VA)

On-site
USD 75,000 - 110,000
ServiceNow Technical Architect – GRC/TPRM
ServiceNow Technical Architect – GRC/TPRM

Fyerx • United States

Remote
USD 13,000 - 19,000
Senior ServiceNow Business Analyst
Senior ServiceNow Business Analyst

ServiceNow • Arizona

On-site
USD 90,000 - 120,000
Lead ServiceNow Engineer - IRM
Lead ServiceNow Engineer - IRM

Alldus • New York (NY)

Hybrid
USD 120,000 - 160,000
Senior Business Analyst
Senior Business Analyst

NorthBay Solutions LLC • United States

Remote
USD 100,000 - 140,000
Senior ITSM Architect & ServiceNow Lead
Senior ITSM Architect & ServiceNow Lead

Ignite IT, LLC • Suitland (MD)

Hybrid
USD 120,000 - 170,000
401(k)
Dental insurance
Flexible spending account
+7