Skip to main content

This job has expired

Business Systems Technical Analyst

Employer
Catholic Diocese of Arlington
Location
Arlington, VA
Closing date
Dec 5, 2021
POSITION SUMMARY:The Information Technology Department is responsible for selecting, deploying and supporting software, hardware and telecommunication resources used by the 450+ staff members of the Central Administrative Offices (CAO) of the Catholic Diocese of Arlington (CDA), the Arlington Catholic Herald (ACH) and the Catholic Charities of the Diocese of Arlington (CCDA) in fulfilling their mission within the Diocese.The Business Systems Technical Analyst position is a hands-on technical position responsible for developing and maintaining custom components and system integrations, including but not limited to application-to-application integrations; SQL and Window services; internal and external APIs; EDI; and SQL stored procedures, triggers and complex reports. This position is also responsible for participating in requirements analysis and decomposition, design, development, internal testing and the documentation of SQL database applications, application-to-application integrations, custom components and third-party plug-ins. Additional responsibilities will include troubleshooting software application SQL errors, existing integrations and providing 2nd tier technical support to the Business Applications Administrator.PRINCIPAL DUTIES:Act as troubleshooting escalation point, tier two technical support, for critical business databases, integrations and custom code.Provide tier one technical assistance to troubleshoot and resolve integration and API errors.Act as an escalation resource, tier two support, for front-end enhancements to existing web-based applications using HTML5, CSS, JavaScript/JQuery and other front-end technologies.Develop, document and maintain SQL stored procedures, triggers, views and services for all critical business applications.Develop and implement processes for filtering and cleaning data, ensuring data integrity for CRM and other software applications.Coordinate directly with business users and business applications administrator to understand and analyze technical specifications.Draft technical requirements to be used by vendors for the development of third-party code and integrations for critical business applications.Work with vendors' development team to architect, design, build and implement software applications, API's and custom integrations.Review code developed by third-party vendors for customizing critical business applications for adherence with technical requirements and OWASP compliance.Develop code to enhance standard functionality or streamline processes for critical business applications.Participate in the selection of critical business applications software.Act as data conversion SME for critical business application implementations, leading the data mapping and data conversion efforts.Support implementation team acting as liaison between vendor(s) and CDA on resolving system defects and proposing solutions.Provide quality assurance testing for application enhancements and projects; identify and document errors and propose solutions.Develop structures and best practices for load testing and performance of critical business applications.Identify opportunities for data process automation and propose solutions.Implement and configure Reporting Services (SSRS) according to industry best practices to support CRM and other solutions to meet business requirements; identify additional reporting use cases to support new and existing business needs.Collect and document technical requirements for complex reports for critical business applications.Lead development of complex Crystal, Power BI, SQL or SSRS reports from critical application database sources.Utilize Microsoft Power BI or SSRS reporting tools to extract information from critical business applications and assist in interpreting data and providing reports for end users.Document database architecture and customizations/modifications for all critical applications.Maintain current system diagrams for all critical applications, including data dictionary and system integrations.Manage custom code repository ensuring that all custom code is included in repository and any code changes or updates are included in the repository.Maintain up-to-date test environment for all critical applications.Test monthly security updates and patches impact on custom components and third-party plug-ins for critical business applications in test environment prior to deployment to production.Test SQL upgrades for critical business applications in test environment prior to deployment to production.Act as on-call primary point of contact for after hours and weekend infrastructure issues for a one-week rotation every four to six weeks.Provide technical assistance and support for disaster recovery scenarios.Other responsibilities as assigned.QUALIFICATIONS:Knowledge/Skills:Strong analytical and problem-solving skills, with the ability to follow structured process to resolve exceptions.Demonstrated ability to design and document software solutions.Solution-oriented with a high sense of quality, attention to detail, accuracy, efficiency and meeting tight deadlines.Excellent written, verbal and interpersonal communications skills with a strong sense of customer service.Advanced knowledge of Microsoft SQLIntermediate to Advanced knowledge of HTML/HTML5/DHTML, JavaScript, JQuery, XML/XSL and CSS.Working knowledge of core web languages including C# and .Experience using database tools such as SQL Server Management Studio and Visual Studio.Integration Architecture and best practices.Strong familiarity with Agile software development practices and tools, as well as structured release and deployment best practices.Experience writing Web Services, RESTFUL or SOAP, as well as experience writing fault-tolerant code.Advanced knowledge of data systems and database methodology, design and modeling.Basic knowledge of application architecture and performance management.Education: BS in Computer Science or BA in Management Information Systems or business-related major.Years and Types of Experience: Three to five years information technology experience, including experience reviewing and developing C#, , XML, HTML5 and JavaScript code, preferably for CRM and/or financial software solutions.PI154262156

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert