Technical Architecture Specialist

Technical Architecture Specialist
Remote
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.

About Diversified Systems
Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast. We offer our consultants a number of flexible and competitive compensation benefit packages.

Diversified Systems is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations.

Diversity, Equity and Inclusion
DSI values authenticity and is committed to making sure our employees and partners are valued and respected. At DSI, we believe building a diverse culture is important because we know when people work together, we can achieve better results as a team. DSI realizes that everyone comes from various backgrounds. We celebrate these differences because our employees are our greatest asset as we strive to best meet the needs of those we serve. As part of our ongoing efforts, DSI is focused on advancing equality, diversity, and inclusion by setting high standards to continually evolve our culture. This includes but is not limited to recruiting, community involvement, client delivery, and career development.