Data Integration Engineer

Data Integration Engineer

Our client is on a mission to build smart, inspired, and useful products for faculty and academic communities. By building an engine for faculty activity, decisions, and data, they have become the first mover in defining and owning the category of faculty-focused technology that cultivates goal-oriented collaboration around academic decision-making.

Our client operates the first holistic faculty information system to support the full lifecycle of faculty work, from job seeking to review, tenure, sabbatical, committee work, research, and beyond. Offering colleges and universities increased clarity and insight into faculty data to help achieve their strategic initiatives, they believe that advancing the faculty will advance the institution. They have crafted a fun, collegial, dynamic culture that celebrates team and individual success almost daily. Their lean team of super-smart, super-hard working, local and remote colleagues, collaborate closely to produce a valuable service for an industry they’re passionate about. They genuinely like working with each other and with their clients.

The Technical Services Data Integration Engineer is a member of our client's Professional Services Team who is responsible for the successful implementation and continued success of their clients. In this role, you will primarily be responsible for managing the ins and outs of complex data-related software and supporting clients’ data-related issues. In addition, you will be helping clients align to, implement, and optimize data management schemes and practices in adherence to their standardized methods. You will also be responsible for assisting with the design and implementation of an ETL solution to standardize, optimize and scale their data ingestion capabilities. As you familiarize yourself with the software you will help to build and expand their ETL solution, interacting with product engineering to help define API use cases and the team’s requirements. There will be continued opportunities to migrate clients from the legacy system to the new tool. As you gain experience, consulting will be a key aspect of this role.

  • Understand and execute complex client data operations and troubleshooting within a PHP application
  • Help to build a data load system using an ETL platform (Matillion) with existing APIs and new constructs
  • Work collaboratively with clients to understand, adhere to, and adopt data integration methodologies & formatting
  • Possess a client-centered mindset around delivery & communications, focused on client delight and success
  • Implement data extraction & insertion procedures
  • Work effectively with our internal and external clients to ensure timely delivery of implementation and ongoing tasks
  • Build and foster strong relationships with all levels of technical and non-technical staff at client institutions
  • Identify, recognize, and proactively act on opportunities for improvement in order to advance business process goals
  • Ability to identify challenges, accept and implement change, and quickly adapt to dynamic situations
  • Possess strong verbal and written communication skills.


Requirements:

  • Bachelor's degree or higher in Computer Science or a related field
  • Significant experience delivering ETL data load services
  • 2-5 years of professional software development experience
  • 2-5 years of relational database and SQL experience, ideally on Postgres and Snowflake
  • Advanced programming in any language and associated technologies including Python, SQL, PHP, JSON, HTML, JavaScript, XML, GraphQL
  • Understanding of fundamental object-oriented software engineering, including data structures and programming constructs
  • Substantive experience with SAML-based SSO, including various SPs and IDPs
  • Advanced understanding of internet protocols, networks, APIs, and related technologies: HTTP, REST, and SOAP web services

Preferred:

  • Excellent customer communication and project management skills
  • 3-5 years of customer-facing experience
  • Experience building tools for data analysis
  • ETL platform experience (Matillion preferred), SQL and Python experience
  • Experience with PHP and connectivity to database

Benefits + Salary

Logos/outerjoin logo full

Outer Join is the premier job board for remote jobs in data science, analytics, and engineering.