Technical Architecture Specialist

S R INTERNATIONAL INC
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Remote

Tech stack

JavaScript
Agile Methodologies
ASP.NET
Azure
C Sharp (Programming Language)
Databases
Continuous Integration
ETL
Database Design
Database Development
Database Schema
Database Security
Dependency Injection
jQuery
Microsoft Software
Microsoft SQL Server
MVC
Oracle
Oracle Applications
Performance Tuning
Power BI
Software Engineering
PL-SQL
SQL Databases
SQL Server Reporting Services
SQL Server Integration Services
T-SQL
.NET Core
GIT
Information Technology
Tools for Reporting
SQL Server Management Studio (SSMS)
Network Server

Job description

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., * 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.

Requirements

  • 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

Apply for this position