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.

• Customer — We focus on our customers' success
• Innovation — We create better solutions
• Collaboration — We create success together
• Inclusion — We always interact with others respectfully
• Candor — We are open and honest with one another
• Integrity — We do the right things and do things right

General Requirements:

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

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