Solutions Architect III - Snowflake

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

The Solutions Architect - Snowflake will work with business stakeholders, solution architects and technical area leads to identify real-world problems and propose advanced solutions supporting day-to-day decision-making in various functional areas. This role reports to the Director, IT Data & Analytics and serves as an integral part of the Data & Analytics IT team.

Accountabilities & Responsibilities:

• You will help to define short- and long-term roadmaps for data platforms or their specific areas.
• Conduct solution assessments and/or design solutions to ensure that functional and technical specifications meet the identified business needs within the organization
• You will be involved in technology and methodology evaluation for various business functions analytical use cases, eg. including Data Mesh and AI-led applications.
• You will be involved in POV and POC activities which will involve Snowflake and ETL tools such as Azure Data Factory (ADF).
• Engage in and facilitate stakeholder discussions to understand, analyze and document business requirements, business processes, and technical specifications (including system architecture documentation) 
• Configure, develop and support applications used in our Data & Analytics tech stack (Snowflake, ADF and Power BI)
• 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  
• You will contribute to the growth of Snowflake technology practice and participate in the roadmap and go-to-market strategy definition.
• 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
• 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 Data Lake (using ETL tools such as Azure Data Factory, flat file processing etc.).
• Develop and maintain data management standards including documentation of current data sources, transformations and report specifications.
• Support user creation and access management of our current Snowflake reporting platform, providing the correct access to specific users as they come onboard.
• Ensure data quality including validation, cleansing/scrubbing, and ETL methods.

Education & Experience:

• 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 years of Microsoft Power BI experience is required
• Snowflake (Cloud Data Warehouse) experience is preferred
• Azure Data Factory and Oracle Data Sync experience is preferred
• 3 years of experience with using ERP systems as a source for data & analytics solutions
• Experience in working with business stakeholders to understand business priorities and requirements
• Knowledge of at least one of the following technologies/methodologies will be an additional advantage: Python, Streamlit, Matillion, DBT, Atlan, Terraform, Kubernetes, Data Vault, Data Mesh.
• Knowledge and experience with Snowflake’s AI offerings (Cortex)

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

U.S. Applicants: EOE/AA Disability/Veteran