Senior Data & Reporting Architect - Remote

Prorec Resource Solutions, LLC; Harrisburg (Dauphin County); On-site; USD 80,000 - 110,000; Full time

Job summary

Prorec Resource Solutions, LLC seeks a developer to build SSRS reports and .NET Core MVC applications for the Department of Environmental Protection. This 100% remote role requires residency within a 2-hour radius of Harrisburg, PA.

The contract runs Aug 3, 2026 through Jun 30, 2027, with extensions common. Candidates should have 3 years of related experience, strong SSRS and ETL skills, and a solid background in .NET Core, C#, SQL Server, Oracle, and data modeling.

Qualifications

• 3 years of related work experience.
• Extensive SSRS development knowledge with SQL Server Integration Services for ETL.
• Deep experience with .NET Core, MVC, C#, DI, JavaScript, and jQuery.
• Experience with Oracle databases and PL/SQL using SQL Developer.
• Experience with SQL Server databases and T-SQL using SSMS.
• Strong data modeling and database design capabilities.

Responsibilities

• Develop new SSRS reports and database objects against complex SQL Server and Oracle databases.
• Modify or enhance existing SSRS reports and database objects as assigned.
• Create and maintain .NET Core MVC applications.
• Design relational and multidimensional databases.
• Perform performance tuning for SSRS reports.
• Test SSRS reports and database objects before user testing.
• Apply Agile development principles.
• Collaborate with business users to gather requirements and ensure solutions meet needs.
• Assist in designing reporting database solutions and configuring report servers and security.
• Research new software releases and assist with upgrade processes.
• Use Azure DevOps work items and provide project statuses and estimates.
• Use Git as code repository.
• Maintain best practices and mentor team members on IT standards.
• Document all work for future reference.
• Independently execute tasks and assignments.
• Create and maintain CI/CD pipelines to automate build and deployment.
• Publish reports to Power BI service workspaces and manage deployment pipelines.

Skills

SSRS development

SQL Server

Oracle

.NET Core

MVC

C#

JavaScript

Git

Azure DevOps

Data modeling

Education

4-year college degree or equivalent

Tools

Azure DevOps

Git

SQL Developer

SQL Server Management Studio

Job description

Prorec Resource Solutions, LLC seeks a developer to build SSRS reports and .NET Core MVC applications for the Department of Environmental Protection. This 100% remote role requires residency within a 2-hour radius of Harrisburg, PA.

The contract runs Aug 3, 2026 through Jun 30, 2027, with extensions common. Candidates should have 3 years of related experience, strong SSRS and ETL skills, and a solid background in .NET Core, C#, SQL Server, Oracle, and data modeling.