Technical Architecture Specialist

S R INTERNATIONAL INC

United States

26 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

3 years minimum

Working hours

Regular working hours

Job source

www.indeed.com

Tech stack

JavaScript (Programming Language) Agile Methodology ASP.NET MVC Framework Microsoft Azure C Sharp (Programming Language) Databases Continuous Integration Extract Transform Load (ETL) Database Design Database Development Database Schema Database Security

+21 more

Dependency Injection JQuery Microsoft Software Microsoft SQL Server Model View Controller (MVC) Oracle Databases Oracle (Applications) Performance Tuning Power BI Software Engineering PL-SQL SQL Databases SQL Server Reporting Services SQL Server Integration Services Transact-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