Technical Architecture Specialist

Adept Consulting Services•Harrisburg, PA

About The Position

This role involves developing and maintaining SSRS reports and database objects, creating and managing .Net Core MVC applications, and ensuring the quality and performance of reporting solutions. The specialist will work with business users to gather requirements, design reporting database solutions, and configure report servers. They will also research new software functionalities, manage upgrades, and utilize Azure DevOps and GIT for development processes. Adherence to established standards, mentoring team members, and documenting all work are key aspects of this position. Additionally, the role includes creating and maintaining CI/CD pipelines for automated builds and deployments, and publishing reports to Power BI.

Requirements

3-5 years of related work experience.
Excellent verbal and written communication required.
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 experience.
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.

Nice To Haves

4-year college degree or equivalent technical study desired.

Responsibilities

Develops new SSRS reports and database objects against complex enterprise databases (both SQL Server and Oracle) and modifies or enhances existing SSRS reports and database objects as assigned.
Create and maintain .Net Core MVC applications.
Demonstrates experience with the design of relational and multidimensional database.
Demonstrates proficiency in performance tuning to ensure quality and performance of SSRS reports.
Tests the SSRS reports and database objects created and maintained by the service center thoroughly prior to user testing.
Applies Agile development principles.
Works with business users to gather and document requirements and ensures solutions meet their business needs.
Assists in designing reporting database solutions for the service center and configuring report servers and security.
Researches functionality in new software releases and performs, documents, and assists other staff in the upgrade processes.
Uses Azure DevOps and work items and provides project statuses and project time estimates to the reporting section supervisor.
Uses GIT for code repository.
Adheres to any standards set by the Service Center and the Governor’s Office of Administration.
Demonstrates analytical and customer service skills.
Ensures that best practices are maintained and mentors team members on the best practices, standards, and IT processes.
Documents all work for future reference.
Independently executes all tasks and work assignments.
Create, configure and maintain CI/CD pipelines to automate build and deployment.
Publishing reports to power BI service workspaces and managing pipeline to deploy the reports to different environments.