Solutions Architect IV - Data Analytics

Integer Holdings; Plano (TX); On-site; USD 95,000 - 125,000; Full time

Benefits offered by this job

Medical, dental & vision

401(k) with match

Paid time off & holidays

Job summary

Integer Holdings is seeking a Data & Analytics professional to lead data architecture, ETL, and BI efforts. You will design scalable data pipelines, maintain data governance, and deliver enterprise dashboards in Power BI for key business KPIs.

Collaboration with IT and business stakeholders is essential to translate needs into actionable analytics. The role requires 3–5 years of BI experience, expertise in Azure Data Factory, Snowflake, and a solid understanding of ERP data sources.

Qualifications

• 3-5 years hands-on experience in BI and data analytics solutions.
• Experience with relational DB concepts and flat file processing.
• Strong Power BI experience and data warehousing knowledge.
• Knowledge of ETL tools, data modeling, and governance practices.

Responsibilities

• Engage with stakeholders to document requirements and translate into technical specs.
• Define data architecture, modeling, pipelines, and visualization standards.
• Configure and support applications on the Data & Analytics stack.
• Design integrations and validate solutions with test plans and scripts.
• Develop enterprise BI dashboards and KPIs in Power BI.
• Collaborate across IT and Manufacturing to drive data initiatives.

Skills

Power BI

SQL

Data modeling

Azure Data Factory

Snowflake

Stakeholder management

Data storytelling

SDLC

Education

Bachelor's Degree in CS or IS or Business Admin

Tools

Power BI

Azure Data Factory

Snowflake

Oracle ERP

SAP Analytics Cloud

Job description

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

Accountabilities & Responsibilities

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

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.

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

Our total rewards program is designed to attract, retain, and motivate associates to contribute to Integer\'s success. Our compensation program includes base salary and a cash-based incentive program supporting our pay-for-performance philosophy. We provide a comprehensive benefits package with immediate eligibility including medical, dental, vision, disability, life insurance, and adoption benefits. Parental leave is available after one year. Optional employee-paid programs include supplemental life insurance, critical illness, hospital indemnity and accident insurance. Employees are immediately eligible to participate in the 401(k) plan with company matching contributions. We provide 80 hours (10 days) of company designated holidays per year plus an annual allotment of paid time off.

U.S. Applicants: Equal Opportunity Employer. In addition, veterans and individuals with disabilities are encouraged to apply.