Business Partner Integration Engineer    

Our Company:

PopSockets LLC, based in Boulder, Colorado, designs, manufactures and sells innovative lifestyle products. Our flagship product, the PopSockets grip—a collapsible grip and stand that provides secure one-handed holding for any mobile device—was invented by philosophy professor David Barnett, with the first grip sold on PopSockets.com in 2014 and the 100 millionth sold in 2018. PopSockets products embody the company's mission to create empowering, personal, and fun products.

PopSockets was named one of the Best Places to Work in Colorado in 2018 and also listed as Inc. 5000's second fastest growing company in the US, with a 71,424% percent of sales increase over the last three years.

For more information on what it’s like to work at PopSockets, check out:  https://www.builtincolorado.com/company/popsockets-llc

The Role:

This new IT position will lead both strategic planning and day-to-day management of systems integration across the internal and external enterprise. Success in this role is measured by the timely, accurate and error-free flow of key business data across systems to support order management, inventory accuracy, financial reconciliation and availability of data for business intelligence. The ideal candidate is a business-savvy developer with proven experience architecting web services interfaces, creating ETL connections and defining data management best practices.

Responsibilities:

  • Frequent collaboration with third-party partners and regular travel to partner sites globally to support requirements definition and joint development of integration projects.
  • Collaborates with stakeholders and development team members to achieve business results. Work closely with other engineers to integrate databases and business applications with other internal or third party applications.
  • Supports data flows between business applications and provides solutions for managing and integrating data between operational systems, data repositories, and reporting and analytical applications. This includes but is not limited to ETL, APIs, stored procedures, Enterprise Integration Patterns, EDI, views, and functions.
  • Writes functional design documents, creates/maintains EDI maps and specifications, troubleshoots complex EDI failures, works with external EDI partners, and tests interconnected systems.
  • Recommends and provides guidance regarding data integration and database development, best practices, and standards to the development team members as needed.
  • Create and propose technical design documentation which includes current and future functionality, database objects affected, specifications, and flows/diagrams to detail the proposed database and/or Data Integration implementation.
  • Should be able to develop a good understanding of the business processes and be prepared to recommend related technology platforms in future.
  • Participates in industry and other professional networks to ensure awareness of industry standards, trends and best practices in order to strengthen organizational and technical knowledge.
  • Investigates and troubleshoots production issues.
  • Works continually on improving performance of source code using industry standard methodologies

Requirements:

  • Bachelor's degree from four-year college or university: Engineering, Computer Science, Mathematics)
  • Three to five years related experience and/or training; or equivalent combination of education and experience.
  • Must have extensive experience with CRMs, ERPs and Ecommerce platforms.  
  • Hands-on experience with these technologies preferred; MySQL, AWS/Azure, MS Dynamics NAV, Salesforce Commerce Cloud, Ruby on Rails, SPS Commerce, Snowflake, Looker
  • Enterprise ERP DataFlows and connectors
  • Data mapping and cleansing
  • Data flow design and implementation
  • 3+ years Data Integration technologies and principles
  • Advanced knowledge of various CDP and ERP integrations in regards to inventory management.
  • Experience with index design SQL performance tuning techniques
  • Experience integrating data from structured and unstructured formats: flat files, XML, EDI, JSON, EXCEL
  • Scripting language skills, to aid with juggling files, directories, users, and permission issues that can complicate ETL. Experience with popular scripting languages for ETL include Python, Perl, or Bash.
  • Working knowledge and experience in online transactional (OLTP) processing and analytical processing (OLAP) databases and schemas
  • Basic understanding of object oriented programming
  • Experience in distributed architectures such as Microservices, SOA, and RESTful APIs
  • Willing to travel globally, up to 50% of time.

 

Apply for this Job

* Required

File   X
File   X
When autocomplete results are available use up and down arrows to review
+ Add Another Education


U.S. Equal Opportunity Employment Information (Completion is voluntary)

Individuals seeking employment at PopSockets are considered without regards to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation. You are being given the opportunity to provide the following information in order to help us comply with federal and state Equal Employment Opportunity/Affirmative Action record keeping, reporting, and other legal requirements.

Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.


Form CC-305

OMB Control Number 1250-0005

Expires 1/31/2020

Voluntary Self-Identification of Disability

Why are you being asked to complete this form?

Because we do business with the government, we must reach out to, hire, and provide equal opportunity to qualified people with disabilities1. To help us measure how well we are doing, we are asking you to tell us if you have a disability or if you ever had a disability. Completing this form is voluntary, but we hope that you will choose to fill it out. If you are applying for a job, any answer you give will be kept private and will not be used against you in any way.

If you already work for us, your answer will not be used against you in any way. Because a person may become disabled at any time, we are required to ask all of our employees to update their information every five years. You may voluntarily self-identify as having a disability on this form without fear of any punishment because you did not identify as having a disability earlier.

How do I know if I have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Disabilities include, but are not limited to:

  • Blindness
  • Deafness
  • Cancer
  • Diabetes
  • Epilepsy
  • Autism
  • Cerebral palsy
  • HIV/AIDS
  • Schizophrenia
  • Muscular dystrophy
  • Bipolar disorder
  • Major depression
  • Multiple sclerosis (MS)
  • Missing limbs or partially missing limbs
  • Post-traumatic stress disorder (PTSD)
  • Obsessive compulsive disorder
  • Impairments requiring the use of a wheelchair
  • Intellectual disability (previously called mental retardation)
Reasonable Accommodation Notice

Federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job or to perform your job. Examples of reasonable accommodation include making a change to the application process or work procedures, providing documents in an alternate format, using a sign language interpreter, or using specialized equipment.

1Section 503 of the Rehabilitation Act of 1973, as amended. For more information about this form or the equal employment obligations of Federal contractors, visit the U.S. Department of Labor's Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.