Technical Architecture SpecialistRemote
Must reside within 2-hour radius of Harrisburg region.
Description:Diversified Systems is searching for a Technical Architecture Specialist to develop, revise, and maintain reporting solutions, database objects, and web applications supporting enterprise systems. Under broad supervision, the consultant will develop new SSRS reports and database objects against complex enterprise databases, maintain .NET Core MVC applications, support CI/CD processes, and collaborate with business users to deliver scalable reporting and application solutions.
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 the 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 and perform, document, and assist other staff in upgrade processes.
- Use Azure DevOps work items and provide project statuses and project time estimates to the reporting section supervisor.
- Use GIT for code repository management.
- Adhere to any standards set by the Service Center and the Governor's Office of Administration.
- Demonstrate analytical and customer service skills.
- Ensure that best practices are maintained and mentor team members on best practices, standards, and IT processes.
- Document all work for future reference.
- Independently execute all tasks and work assignments.
- 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 years of related work experience required.
- Extensive experience working with Microsoft tools, with in-depth SSRS development knowledge and SQL Server Integration Services to perform ETL operations required.
- In-depth experience with .NET Core, MVC, C#, dependency injection, JavaScript, and jQuery required.
- Extensive experience handling large datasets and reporting based on various data sources required.
- In-depth experience working with Oracle databases and PL/SQL using SQL Developer required.
- In-depth experience working with SQL Server databases and T-SQL using SQL Server Management Studio required.
- In-depth experience with data modeling and the ability to analyze and understand database design required.
- Excellent verbal and written communication skills required.
- 4-year college degree or equivalent technical study highly desired.
