Technical Architecture Specialist
Please mention DailyRemote when applying
AI Summary
Develop and maintain enterprise reporting solutions, .NET Core MVC applications, and database objects across SQL Server and Oracle environments. Build ETL processes and manage CI/CD pipelines using Azure DevOps and Git.
Job Title: Technical Architecture Specialist
Job Code: PA 807197
Client: Commonwealth of Pennsylvania – Department of Environmental Protection (DEP)
Location: Remote
Duration: Long-Term Contract
Work Hours: 37.5 Hours/Week
Closing Date: 07/22/2026
Position Overview
The Pennsylvania Department of Environmental Protection (DEP) is seeking an experienced Technical Architecture Specialist to develop and maintain enterprise reporting solutions, .NET Core MVC applications, and database objects across SQL Server and Oracle environments. The ideal candidate will have strong expertise in SSRS, SSIS, .NET Core, C#, SQL Server, Oracle, ETL, Azure DevOps, Git, CI/CD, and Power BI while supporting enterprise reporting, application development, and database solutions.
Required Skills
- 3+ years of related IT experience
- Strong experience with Microsoft SSRS and SQL Server Integration Services (SSIS) for ETL development
- Expertise in .NET Core, ASP.NET MVC, C#, Dependency Injection, JavaScript, and jQuery
- Experience handling large enterprise datasets and reporting solutions
- Oracle Database, PL/SQL, and SQL Developer
- SQL Server, T-SQL, and SQL Server Management Studio (SSMS)
- Data Modeling and Database Design
- Excellent verbal and written communication skills
Preferred Skills
- Bachelor's degree in Computer Science or related technical field
- Azure DevOps
- Git
- Power BI Service
- CI/CD Pipeline Development
- Agile/Scrum Methodology
- Performance Tuning
- Enterprise Reporting Database Design
Key Responsibilities
- Develop, enhance, and maintain SSRS reports and database objects for SQL Server and Oracle databases.
- Design, develop, and maintain .NET Core MVC applications using C#, JavaScript, jQuery, and Dependency Injection.
- Build and maintain ETL processes using SQL Server Integration Services (SSIS).
- Design relational and multidimensional databases and optimize report performance.
- Gather and document business requirements while collaborating with business users.
- Configure report servers, database security, and reporting solutions.
- Create and maintain CI/CD pipelines using Azure DevOps and Git.
- Publish and manage reports within Power BI Service across multiple deployment environments.
- Document technical solutions, mentor team members, and follow Agile development best practices.
Primary Skills
SSRS, SSIS, ETL, .NET Core, ASP.NET MVC, C#, JavaScript, jQuery, SQL Server, T-SQL, Oracle, PL/SQL, SQL Developer, SQL Server Management Studio (SSMS), Data Modeling, Database Design, Azure DevOps, Git, Power BI, CI/CD, Dependency Injection, Performance Tuning, Agile, Enterprise Reporting, Microsoft Technologies.
This is a remote position.
Automatically Apply to the Best Remote Jobs
Stop the endless job search. Our AI finds and applies to the best jobs for you.
