Solutions Architect

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 Tablaeu, 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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

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 Tablaeu, 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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.