Solutions Architect

Position Description

Important Disclaimer Notice:

The within described functions are among the essential job functions for this position but are not exhaustive of the essential functions of the job or of the tasks that an Associate may be required to perform. Associates may be assigned additional responsibilities as necessary. The employer reserves the right to revise this job description at any time and to require Associates to perform other tasks as circumstances or conditions of its business, competitive considerations, or the work environment change.

Job Summary:

The Information Technology team is looking for a senior analyst who is analytical, data oriented and has intellectual curiosity to understand processes within various functions of Schweid & Sons. The Senior Solutions Architect will be leading various automation initiatives, provide analytics and work group solutions that enhance productivity and eliminate or streamline labor intense work.

Essential Job Functions:

The essential job functions of this position include, but are not limited to, the following:

• Manage portfolio of BI solutions and be responsible for delivery of all associated project tasks and outcomes
• Partner with internal customers to assess needs and design solutions to have disparate systems speak to each other, improve efficiencies by automating repetitive processes, and or improve controls through standardization of workflows
• Provide end-user technical support and performance-tune BI applications as necessary by resolving system issues for ongoing sustainability of business processes as well as a various S&S functions (sales, marketing, operations, etc.); potential for periodic on-call duty supporting existing BI applications and services
• Review and update documentation for associated application standard operating procedures

• Lead requirements and scoping sessions to understand, define and anticipate business needs; data governance - create data and quality assurance reviews and direct stakeholders/customers in quality testing to ensure requirements have been met and design is optimized for functionality and performance
• Interact with various stakeholders on system improvements utilizing new tools & approaches; provide enhanced analytical capabilities
• Interact with numerous tools such as SharePoint, Office 365, Tableau, Power BI, Power Automate (and UI Flow), MS Power Apps, MS SQL Server Services, MS Visual Studio .NET framework, MS Excel and/or Access, Aspen Canopy, ETL iPaaS tools
• Manage work request queue in accordance with project planning tools and internal ticket tracking; ensure requests are addressed in a timely manner
• Collaborate with the team on required day to day support
• Participate in and lead continuing education training seminars/classes in areas of technical expertise

Qualifications/Requirements:

• Experience in project and change management with excellent written and verbal communication skills
• Solid organizational skills including attention to detail and multi-tasking
• Analytical mindset that can define or identify a problem, generate alternatives or potential solutions, evaluate, provide recommendation, and implement the chosen solution
• Intellectual curiosity and willingness to learn new tools and techniques to support a rapidly changing landscape of customer needs
• Proficient in Office 365 online environment and using Microsoft Power Platform (Power Apps, Power Automate, Power BI)
• Experience and Working knowledge of SharePoint Online (classic and modern) including site creation and maintenance; customization of web parts, workflow and other process automation techniques
• Knowledge of Structured Query Language (SQL) in a relational database environment. Experience in SQL Server and capable creating and using Stored Procedures, User Defined Functions, creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers
• Experience with basic reporting solutions and tools with visual analytics such as Power BI and Tableau, as well as data mining software, like ABBYY FlexiCapture, and other business intelligence tools and applications
• Experience in cloud computing including Microsoft Azure
• Familiarity with APIs, JSON, Data Extraction, Transforming and Loading (ETL) using various tools; experience with EDI is a plus
• Experience in ASP.NET, JavaScript, jQuery would be a plus
• Experience in the area of Robotic Process Automation (RPA) as well as management of RPA governance would be a plus

Education and Experience:

• Bachelor of Science in Information Systems/Technology, Computer Science, Business Administration, or related field
• 4-6 years of professional experience a technical role
• Analytical experience or equivalent business intelligence experience
• Microsoft Power Platform Certification, a plus