Sr. Solution Architect - BI

Description

The Data Solutions Center of Excellence (COE) is a business segment of MISTRAS focused on providing software technology, implementation services and data analytics to a diverse group of customers operating globally. There are multiple divisions within the business segment with each focusing on a particular business or service line. The COE offers standalone software products and technical services to customers as well as complementing traditional MISTRAS inspection services with business intelligence capabilities.

Salary Range: $135-165k

The Sr. Solutions Architect of Business Intelligence plays a pivotal role in technology leadership and innovation at MISTRAS, facilitating the advancement of data and analytical ideas into tangible dashboards and information outputs. This role requires collaboration with business SMEs, product owners, and leadership to understand and influence business requirements, alongside leading business discussions and technical strategy. The incumbent will be responsible for data and analytics product definition, creating conceptual and logical architectural designs, providing technical guidance in implementing those designs, and plays a hands‑on role in initial R&D.

• Aid business partners in developing and implementing Business Intelligence (BI) related strategic goals that will assist them in achieving their objectives.
• Direct, influence, and support projects in implementing and using new BI software tools and systems.
• Design, code, test, and document all new or modified BI systems, applications, and programs.
• Develop the data layer, cubes, metadata, and report functionality.
• Collaborate with teams in the design of databases and data warehouses to ensure interoperability with BI solutions.
• Analyze user requirements and, based on findings, design functional specifications for BI front-end applications.
• Work with project managers to ensure that data entry, retrieval, change and delete functions meet business requirements for project completion.
• Design and deliver end‑user training and training materials; provide technical support as necessary.
• Troubleshoot BI tools, systems, and software; performance‑tune these applications as necessary.
• Act as an evangelist for BI benefits throughout the organization, promoting healthy usage and adopting standards and best practices.
• Evaluate and influence the selection of database/data warehouse components, including hardware performance, dimensional and relational database management systems, Extract Transform Load (ETL) best practices, metadata management tools, and database design solutions.
• Conduct research and provide recommendations regarding BI products, services, and standards to support customer procurement, retention, and development efforts.
• Mentor and provide leadership to members of the team, managing a team of 2-8 resources.
• Develop, design, implement, enhance, maintain and analyze database systems, queries, and procedures in SQL Server and other environments.
• Develop complex SQL SSIS packages for ETL data for Data Warehouse projects and assignments and be able to modify existing Data Warehouse structure to incorporate data from disparate data sources.
• Perform development and unit testing of ETL processes (various platforms).
• Develop, test, and implement solutions that involve databases, OLAP cubes, and reporting components.
• Perform initial data load and data validation in a production environment.
• Conduct knowledge transfer sessions with team members, business and IT partners.
• Facilitate user requirement discussions with the business and drive architecture and design consistent with enterprise strategy.
• Drive artificial intelligence research and tool selection, followed by implementation of approved initiatives.
• Other duties as assigned.

• Strong communication and ability to partner with leadership as well as team members.
• Excellent interpersonal communication skills.
• Excellent written communication skills.
• Knowledge of proper data pipeline and presentation architectural patterns.
• Strong understanding and usage of agile development methodologies.
• Strong voice of customer mindset.
• A…