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.

At Integer, our values are embedded in everything we do.

We focus on our customers' success

We create better solutions

We create success together

We always interact with others respectfully

We are open and honest with one another

We do the right things and do things right

• 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

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

Data & Analytics Specific:

• 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

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