Systems Integration Analyst

The role, at a glance:

The Systems Integration Analyst is responsible for designing, developing and implementing solutions to integrate applications and data sources by evaluating existing components or systems to determine integration requirements and ensure that final solutions meet the organization's needs. 

How you'll contribute:

• This position is responsible for the analysis, design, documentation, development, unit testing, and support of data integration and database object development for software applications on both on-premises and cloud resources. 
• The Systems Integration Analyst works closely with the Enterprise Applications team, Business Intelligence Team, IT leadership, business subject matter experts and strategic partners to understand business and operational requirements and implement data integration solutions, procedures, and processes to meet those needs. 
• Designs, develops, and implements database processes and solutions for managing and integrating data between operational systems, data repositories and analytical reporting applications.
• Authors and reviews system designs, provides implementation plans, and implements data integration solutions. 
• Develops strong business relationships and cross-functional partnerships with IT colleagues and business partners to analyze business and operational needs. 
• Recommends and provides guidance regarding data integration, database development, SQL best practices, and development standards as needed. 
• Creates and proposes technical design documentation including current and future functionality, database objects, specifications, and flows/diagrams detailing proposed database and/or data integration implementations. 
• Provides support in investigating and troubleshooting production issues. 

A successful candidate should have:

• Strong knowledge of application integration techniques, tools and API use. 
• Minimum of three to five (3-5) years’ experience with business operations, business system integrations, systems development and hands-on support.
• Intermediate knowledge of ETL, replication, change data capture and other data integration techniques and technologies (Microsoft SQL Server, SQL Server Manager, SSIS, SSRS, SQL Server Visual Studio, etc.). 
• Intermediate knowledge of iPAAS integration development standards and best practices. 
• Intermediate knowledge of API tools such as Swagger, Postman, or SoapUI.
• Extensive knowledge of database systems and administration, including security, development and testing support, modeling and logical design, database design and qualify control. 
• Demonstrate strong quantitative, analytical, and problem-solving skills, with ability to adapt to new methods, techniques and procedures. 
• Intermediate knowledge of logical and physical data modeling and data modeling tools. 
• Experience with standard EDI transactions in Order to Cash, Warehousing context is a plus. 
• Familiarity with Azure DevOps and an ability to work effectively in an Agile team environment. 
• Excellent verbal and written communication skills required. 

Work Environment: 

• Office environment 
• Minimal travel 

What we offer:

• Medical, Dental, and Vision
• 3 weeks annual PTO and 9 paid holidays
• 401(k) + matching
• Employer-paid base life insurance, short, and long-term disability
• Health savings accounts (with Biamp contribution) and flexible spending accounts
• Tuition reimbursement
• Discretionary profit-sharing
• Referral bonuses
• Charitable donation matching

Who is Biamp?

We make the world’s most extraordinary audio and video solutions. For over 40 years, Biamp has created and innovated professional audiovisual solutions that enable great communication. From the smallest of rooms to the largest of venues, we empower true human connection in every space.

As we grow to meet our customers’ needs and evolve to address the challenges of tomorrow, one guiding principle remains the same:

Biamp connects people through extraordinary audiovisual experiences.

About our company:

At Biamp, we believe the employment relationship should be reciprocal. We want you to love your job, and we want your expertise and knowledge to help drive our business forward. We champion a supportive and dynamic environment filled with passionate people who choose continuous improvement over perfection. We insist on clear, explicit decision making, believe in taking calculated risks, and celebrate tough decisions even when they don’t succeed. We look for people who desire the best from themselves and encourage the same from their coworkers. Our commitment to one another and to the common goal is the most consistent reliable path to recurring success for all of us.