Technical Architecture Specialist

Jobtailor; Harrisburg (Dauphin County); On-site; USD 90,000 - 120,000; Full time

Job summary

Jobtailor in the United States seeks a skilled SSRS/BI developer to design and enhance SSRS reports and database objects against SQL Server and Oracle, build .NET Core MVC applications, and mentor teammates on best practices.

You will collaborate with Agile teams, gather requirements from business users, configure report servers and CI/CD pipelines, publish reports to Power BI, and use Azure DevOps and GIT to track work.

Qualifications

• 3-5 years of related work experience.
• Excellent verbal and written communication.
• 4-year college degree or equivalent technical study.
• Extensive experience with Microsoft tools and SSRS development.
• Experience with Oracle and SQL Server databases for ETL.

Responsibilities

• Develop new SSRS reports and database objects against complex enterprise databases (SQL Server and Oracle).
• Create and maintain .NET Core MVC applications.
• Demonstrate design and modeling of relational and multidimensional databases.
• Perform performance tuning for SSRS reports and database objects.
• Test SSRS reports and DB objects before user testing.
• Apply Agile development principles and document requirements with business users.
• Assist in designing reporting solutions and configuring report servers and security.

Skills

SSRS Report Development

Performance Tuning

Agile Development

Data Modeling

Analytical Skills

Customer Service Skills

Verbal Communication

Written Communication

Education

4-year college degree or equivalent

Tools

SSRS

SQL Server

Oracle

PL/SQL

T-SQL

.NET Core

MVC

C#

JavaScript

JQuery

Power BI

Azure DevOps

GIT

SQL Server Management Studio

SQL Developer

Job description

Responsibilities

• Develop new SSRS reports and database objects against complex enterprise databases (both SQL Server and Oracle) and modify or enhance existing SSRS reports and database objects as assigned
• Create and maintain .Net Core MVC applications
• Demonstrate experience with the design of relational and multidimensional databases
• Demonstrate proficiency in performance tuning to ensure quality and performance of SSRS reports
• Test SSRS reports and database objects created and maintained by the service center thoroughly prior to user testing
• Apply Agile development principles
• Work with business users to gather and document requirements and ensure solutions meet their business needs
• Assist in designing reporting database solutions for the service center and configuring report servers and security
• Research functionality in new software releases, perform, document, and assist other staff in upgrade processes
• Use Azure DevOps and work items to provide project statuses and time estimates to the reporting section supervisor
• Use GIT for code repository
• Adhere to standards set by the Service Center and the Governor’s Office of Administration
• Demonstrate analytical and customer service skills
• Ensure best practices are maintained and mentor team members on best practices, standards, and IT processes
• Document all work for future reference
• Execute tasks and work assignments independently
• Create, configure, and maintain CI/CD pipelines to automate build and deployment
• Publish reports to Power BI service workspaces and manage pipelines to deploy reports to different environments

Requirements

• 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
• 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

Core Competencies

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 Development
• SQL Server Integration Services
• Performance Tuning
• Data Modeling
• Agile Development Principles

Hard Skills

• SSRS
• SQL Server
• Oracle
• PL/SQL
• T‑SQL
• .NET Core
• MVC
• C#
• JavaScript
• JQuery

Soft Skills

• Analytical Skills
• Customer Service Skills
• Verbal Communication
• Written Communication

Industry Keywords

• ETL Operations
• CI/CD Pipelines
• Database Design
• Reporting Solutions
• Agile Methodologies

Tools & Technologies

• Azure DevOps
• GIT
• SQL Server Management Studio
• SQL Developer
• Power BI