Sr. Solution Architect - BI

Salary Range: $135-165k

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. 

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.

MAJOR RESPONSIBILITIES/ACTIVITIES: 

• 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.

QUALIFICATIONS & SKILLS:

• 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.
• Architectural knowledge of data pipeline processing, operational and analytical data models.

EDUCATION & EXPERIENCE REQUIREMENTS: 

• Bachelor’s degree in an area of study that includes working with data, systems, or complex organizations, such as Computer Science/Engineering, Business Analytics, Statistics, Administration, or related fields.
• 12+ years professional experience delivering BI, data management technologies and best practice and Analytics solutions
• 5+ Experience leading BI and Analytics teams and/or complex Analytics projects.
• Expertise in collaborating, communication, and presenting with cross-functional teams to deliver high-impact business solutions.
• Extensive knowledge of modern architectural patterns, frameworks, and industry best practices.
• Strong knowledge of the Microsoft tool set.

• Prefer strong knowledge of Azure, and Azure ML Studio.
• Prefer candidates having experience with outsourced teams.

ESSENTIAL PHYSICAL FUNCTIONS:

• Frequent lifting up to 30 lbs.

This job description reflects management's assignment of essential functions; it does not prescribe or restrict the tasks that may be assigned.

MISTRAS Group, Inc. is committed to equal employment opportunity. Employment decisions including initial hiring and all matters involving the terms and conditions of employment will be made without regard to any protected class under applicable law. If hired, the employment relationship is “At-Will,” which means that employment can be terminated at any time, and for any reason, at the option of either the Company or the employee.  Please direct questions about these policies to a MISTRAS Group, Inc. Human Resources representative. 

By submitting & signing , I hereby understand and agree to the terms and conditions of employment as outlined above.  I certify that the responses and information provided in this application (including any other supporting documentation such as a cover letter, resume, or transcript) are true and accurate to the best of my knowledge. I understand that misrepresenting or omitting information requested is cause for dismissal at any time, without notice. I hereby give the Company permission to contact schools, previous employers (unless otherwise indicated), references, and others disclosed in my application. 

Note to Applicants:

Smoking is prohibited in all indoor areas of the Company.  Employees may use designated smoking areas (if established) in accordance with applicable state and local law.

Rhode Island Applicants: The Company is subject to Chapters 29-38 of Title 28 of the General Laws of Rhode Island, and is therefore covered by the state’s workers’ compensation law.

Initial (if applicable):    Massachusetts Applicants: I understand that it is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Initial (if applicable):    Maryland Applicants: I UNDERSTAND THAT UNDER MARYLAND LAW, AN EMPLOYER MAY NOT REQUIRE OR DEMAND, AS A CONDITION OF EMPLOYMENT, PROSPECTIVE EMPLOYMENT OR CONTINUED EMPLOYMENT, THAT ANY INDIVIDUAL SUBMIT TO OR TAKE A POLYGRAPH OR SIMILAR TEST. AN EMPLOYER WHO VIOLATES THIS LAW IS GUILTY OF A MISDEMEANOR AND SUBJECT TO A FINE NOT EXCEEDING $100.

#LI-AB1

Mistras Group, Inc. is an Equal Opportunity Employer/Veterans/Disabled: