Technical Architecture Specialist

Adept Consulting Services, Inc.

Technical Architecture Specialist responsible for creating SSRS reports and .Net Core MVC applications. Collaborating with business users and applying Agile principles in a hybrid setup.

Posted 7/14/2026full-timeHarrisburg • Pennsylvania • 🇺🇸 United StatesMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in SSRS report development, database design, and performance tuning, with a strong foundation in .Net Core MVC applications and Agile methodologies. Proficient in managing large datasets and utilizing Microsoft tools for ETL operations and CI/CD pipeline automation.

Highest-signal resume keywords

SSRS Report DevelopmentSQL Server Integration ServicesPerformance TuningData ModelingAgile Development Principles

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SSRSSQL ServerOraclePL/SQLT-SQL.Net CoreMVCC#JavaScriptJQuery

Soft Skills

Analytical SkillsCustomer Service SkillsVerbal CommunicationWritten Communication

Tools & Technologies

Azure DevOpsGITSQL Server Management StudioSQL DeveloperPower BI

Industry Keywords

ETL OperationsCI/CD PipelinesDatabase DesignReporting SolutionsAgile Methodologies

Tech Stack

Tools & technologies

AzureETLJavaScriptjQueryOracleSQLSSIS

About the role

Key responsibilities & impact

Develops new SSRS reports and database objects against complex enterprise databases (both SQL Server and Oracle) and modifies or enhances existing SSRS reports and database objects as assigned
Create and maintain .Net Core MVC applications
Demonstrates experience with the design of relational and multidimensional database
Demonstrates proficiency in performance tuning to ensure quality and performance of SSRS reports
Tests the SSRS reports and database objects created and maintained by the service center thoroughly prior to user testing.
Applies Agile development principles
Works with business users to gather and document requirements and ensures solutions meet their business needs
Assists in designing reporting database solutions for the service center and configuring report servers and security
Researches functionality in new software releases and performs, documents, and assists other staff in the upgrade processes.
Uses Azure DevOps and work items and provides project statuses and project time estimates to the reporting section supervisor
Uses GIT for code repository
Adheres to any standards set by the Service Center and the Governor’s Office of Administration
Demonstrates analytical and customer service skills
Ensures that best practices are maintained and mentors team members on the best practices, standards, and IT processes
Documents all work for future reference
Independently executes all tasks and work assignments
Create, configure and maintain CI/CD pipelines to automate build and deployment.
Publishing reports to power BI service workspaces and managing pipeline to deploy the reports to different environments.

Requirements

What you’ll need

3-5 years of related work experience
Excellent verbal and written communication required
4-year college degree or equivalent technical study desired
Extensive experience working with Microsoft tools, with in-depth SSRS development knowledge and SQL Server Integration Services to perform ETL operations
In-depth experience with .net core, MVC, C#, dependency injection, JavaScript, and jQuery experience
Extensive experience handling large datasets and reporting based on various data sources
In-depth experience working with Oracle databases and PL/SQL using SQL Developer
In-depth experience working with SQL Server databases and T-SQL using SQL Server Management Studio
In-depth experience with data modeling and the ability to analyze and understand database design

Benefits

Comp & perks

Health Care Plan (Medical, Dental & Vision)
Retirement Plan (401k)
PTO