Solutions Architect IV - Data Analytics

By living according to a common set of values, we create a culture that unifies, embraces the uniqueness we all bring to the company, and positions Integer for long-term success., * Engage in and facilitate stakeholder discussions to understand, analyze and document business requirements, business processes, and technical specifications (including system architecture documentation)

• Define and implement data architecture best practices, including data modeling, pipeline orchestration, transformation logic, and visualization standards.
• Configure, develop and support applications used on our Data & Analytics tech stack
• Design and specify integrations between solutions collaborating with stakeholders and other IT teams
• Create / review test plans and scripts; Conduct / participate in testing the solution to ensure the solution meets functional and technical requirements
• Liaise with business users and support/resolve system issues
• Lead system maintenance (review application patch, document test plan, and execute test scripts)
• Participate in the process for collection of requirements and writing of validation documents
• Follow Integer standards for validation, project management and SDLC
• Participate in and contribute to status and planning meetings
• Effectively communicate status, issue escalations & resolutions, and other events as required to all levels of Manufacturing and IT
• Schedule and facilitate meetings, document action items, follow-up to drive resolution
• Create presentations to help communicate complex technical, organizational, and project concepts and status
• Research and advise on the best technologies to leverage and / or approach to take in developing a system architecture or upgrades to install
• Capacity to see the big picture, develop plans and architectures with a global mindset
• Ability to account for project challenges on constraints including, risk, time, resources and scope
• Assist in the development of solutions roadmaps

Data & Analytics Specific:

• Work with the Data & Analytics team on data ingestion strategies for the new Data Lake (using ETL tools, flat file processing etc.).
• Develop and maintain data management standards including documentation of current data sources, transformations and report specifications.
• Design scalable and performant data integration workflows using Azure Data Factory (ADF).
• Oversee the setup, optimization, and usage of Snowflake as a cloud data warehouse platform.
• Develop enterprise BI dashboards, KPIs, and reports using Microsoft Power BI, adhering to best practices for performance, usability, and governance.

• Bachelor’s Degree in computer science, information systems or business administration
• 3-5 years hands-on experience in the analysis, planning, designing, configuring, testing, deploying, and administration of a BI and Data Analytics solutions
• Experience with relational database concepts and flat file processing concepts
• 3-5 years of Microsoft Power BI experience is required
• Snowflake (Cloud Data Warehouse) experience is preferred
• Azure Data Factory and SAP Analytics Cloud experience is preferred
• 3 years of experience with using ERP systems (preferably Oracle) as a source for data & analytics solutions
• Experience in working with business stakeholders to understand business priorities and requirements

Knowledge & Skills:

• Modeling - Able to represent information using a combination of graphical and textual elements; able to choose the correct type of model for a set of information, depending on the type of information to be communicated as well as the audience who will consume the information.
• Requirements Analysis - Able to prioritize and elaborate stakeholder and solution requirements to meet the needs of the sponsoring organization and stakeholders.
• Relationship Management - Able to quickly create relationships and partnerships with stakeholders; be comfortable in a challenger role that, at times, requires building constructive tension in interactions.
• Understanding of Microsoft Power BI and/or other similar data visualization platforms
• Passion for data and analytics, translating data into insights, decisions, and actions
• Ability to understand and communicate the business impact of data analysis and recommendations. Desire to understand the “why” behind the numbers and able to simply explain complex analytical models.
• Change management skills and ability to operate effectively in fast paced environment
• SDLC and Project Management skills; familiarity with basic PM and SDLC methodologies
• Able to work with cross-functional teams to drive and influence changes and improvements
• Excellent written, verbal, team and presentation skills
• Ability to clearly communicate technical concepts to both technical and non-technical users
• Able to work in a team environment that includes other architects / analysts, developers, and QA team
• Ability to lead change and motivate cross-functional teams to achieve tactical and strategic goals
• Self-starter, self-managed, quick learner, open-minded, problem-solver with a positive, collaborative, and team-based attitude
• Periodic travel is required