Data Integration Engineer

The role, at a glance:

The Data Integration Engineer is responsible for designing, developing and implementing solutions to integrate applications and datasources by evaluating existing components or systems to determine integration requirements and ensure that final solutions meet the organization's needs. 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-premise and cloud resources. The Data Integration Engineer 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.

How you’ll contribute:

• Design, develop, and implement database processes and solutions for managing and integrating data between operational systems, data repositories and analytical reporting applications.
• Author and review system designs, provides implementation plans, and implements data integration solutions.
• Develop strong business relationships and cross-functional partnerships with IT colleagues and business partners to analyze business and operational needs.
• Recommend and provide guidance regarding data integration, database development, SQL best practices, and development standards as needed.
• Create and propose technical design documentation including current and future functionality, database objects, specifications, and flows/diagrams detailing proposed database and/or data integration implementations.
• Provide support in investigating and troubleshooting production issues.
• Additional duties as assigned by your supervisor.

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 packaged integration tools such as Boomi, Tibco, SSIS, etc.
• 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:

• This is an onsite position based in Beaverton, OR.
• Routine use of standard office equipment.
• Minimal travel (less than 5%)

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.

Biamp is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.

Job Type: Full-time

Pay: $75,000.00 - $85,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Employee assistance program
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Referral program
• Retirement plan
• Tuition reimbursement
• Vision insurance

Compensation package:

• Profit sharing

Experience level:

• 3 years

Schedule:

• Monday to Friday

Experience:

• business ops, system integrations, systems development: 3 years (Required)
• ETL, and replication, change data capture: 1 year (Required)
• packaged integration tools: 1 year (Required)

Work Location: In person