Integrations (Data) Engineer

Posted 15 Aug 2018

This job post has expired

Interfolio, Inc

Washington, DC United States


etl sql rest mysql

Integrations (Data) Engineer


Interfolio 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, Interfolio has become the first mover in defining and owning the category of faculty-focused technology that cultivates goal-oriented collaboration around academic decision-making.


Interfolio 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, Interfolio believes that advancing the faculty will advance the institution.


What’s even better than that?


We’ve crafted a fun, collegial, dynamic culture that celebrates team and individual success almost daily. We’ve got a lean team of super-smart, super-hard working, local and remote colleagues who collaborate closely to produce a valuable service for an industry we’re passionate about. And, we genuinely like working with each other and with our clients.


Like what you’ve heard so far?


Then consider joining our Services team. The position of Integrations (Data) Engineer is open to remote employees as well as locals in commuting distance to our Washington, D.C. office.


Interfolio is committed to diversity and the principle of equal employment opportunity for all employees. You will receive consideration for employment without regard to race, color, religion, sex (including pregnancy), national, social or ethnic origin, age, gender identity and/or expression, sexual orientation, family or parental status, or any status protected by the laws or regulations in locations where we operate.


About the Position


The Integrations (Data) Engineer is a member of Interfolio Services team and is responsible for the data level integrations between client systems and their Interfolio products.. You will be responsible for building a team and defining best practices so that Interfolio can implement clients reliably and at increasing scale. Key attributes are a customer first mentality, an agile and adaptable mindset, self-motivated visionary spirit, capacity to give and receive constructive criticism, and a willingness to equally teach and learn.


Primary Responsibilities:



  • Build the next generation of [Interfolio] ETL for Faculty180 using existing APIs, as well as additional API structures

  • Work with the business team to clarify requirements and provide effective technical designs aligning with industry best practices

  • Drive the design and implementation of scalable, high performing and robust ETL applications

  • Ensure a high level of quality through design and implementation of unit, system integration, and performance testing

  • Provide technical mentorship and guidance to more junior engineers

  • Conceptualize, develop and deploy data extraction procedures working collaboratively with new product clients

  • Develop recommendations for internal leadership around preferred data integration methodologies

  • Ensure barriers to accurate completion of Data Integration Services projects are anticipated and overcome

  • Work effectively with internal and external client project managers to ensure timely delivery of implementation

  • Build and foster strong relationships with all levels of technical and non-technical staff at client institutions

  • Identify, recognize, and act on opportunities for improvement in order to advance business goals

  • Confront problems, change, and/or challenges quickly and enthusiastically

  • Support and lead calls for prospective client partners around Interfolio’s data integration methodology

  • Developing validation master plans, process flow diagrams, test cases, and standard operating procedures

  • Analyzing validation test data to figure out whether systems or processes have met validation criteria

  • Performing root cause analysis

  • Coordinating the implementation or scheduling of validation testing with affected client departments and personnel

  • Crafting, populating, or maintaining databases for tracking validation activities, test results, or validated systems


Qualifications



  • Bachelor's degree

  • Experience architecting and delivering ETL services and analytics applications that use AWS Glue, Redshift, Athena or Aurora

  • Rest API development experience

  • 5+ years of professional software development experience

  • 4+ years of SQL knowledge, ideally on Postgres

  • Programming in any high level language, SQL scripts, and Java scripting

  • Understanding of fundamental software engineering, including data structures and programming constructs that would be found in non-trivial programs

  • Understanding of relational databases including intermediate level SQL

  • Basic understanding on internet protocols, networks, and related technologies, including http, xml, REST and Soap web services

  • Excellent customer communication and project management skills

  • Business Intelligence experience (Tableau, Sisense, Microstrategy, Qlik)

  • Big Data experience (AWS EMR)

  • Experience working in an Agile environment


In addition to a competitive salary, Interfolio offers a robust benefits package that includes medical insurance, unlimited PTO, a wellness benefit, 401k, and professional development opportunities. Our culture sets us apart—we look forward sharing more about our company and our team!

Integrations (Data) Engineer


Interfolio 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, Interfolio has become the first mover in defining and owning the category of faculty-focused technology that cultivates goal-oriented collaboration around academic decision-making.


Interfolio 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, Interfolio believes that advancing the faculty will advance the institution.


What’s even better than that?


We’ve crafted a fun, collegial, dynamic culture that celebrates team and individual success almost daily. We’ve got a lean team of super-smart, super-hard working, local and remote colleagues who collaborate closely to produce a valuable service for an industry we’re passionate about. And, we genuinely like working with each other and with our clients.


Like what you’ve heard so far?


Then consider joining our Services team. The position of Integrations (Data) Engineer is open to remote employees as well as locals in commuting distance to our Washington, D.C. office.


Interfolio is committed to diversity and the principle of equal employment opportunity for all employees. You will receive consideration for employment without regard to race, color, religion, sex (including pregnancy), national, social or ethnic origin, age, gender identity and/or expression, sexual orientation, family or parental status, or any status protected by the laws or regulations in locations where we operate.


About the Position


The Integrations (Data) Engineer is a member of Interfolio Services team and is responsible for the data level integrations between client systems and their Interfolio products.. You will be responsible for building a team and defining best practices so that Interfolio can implement clients reliably and at increasing scale. Key attributes are a customer first mentality, an agile and adaptable mindset, self-motivated visionary spirit, capacity to give and receive constructive criticism, and a willingness to equally teach and learn.


Primary Responsibilities:



  • Build the next generation of [Interfolio] ETL for Faculty180 using existing APIs, as well as additional API structures

  • Work with the business team to clarify requirements and provide effective technical designs aligning with industry best practices

  • Drive the design and implementation of scalable, high performing and robust ETL applications

  • Ensure a high level of quality through design and implementation of unit, system integration, and performance testing

  • Provide technical mentorship and guidance to more junior engineers

  • Conceptualize, develop and deploy data extraction procedures working collaboratively with new product clients

  • Develop recommendations for internal leadership around preferred data integration methodologies

  • Ensure barriers to accurate completion of Data Integration Services projects are anticipated and overcome

  • Work effectively with internal and external client project managers to ensure timely delivery of implementation

  • Build and foster strong relationships with all levels of technical and non-technical staff at client institutions

  • Identify, recognize, and act on opportunities for improvement in order to advance business goals

  • Confront problems, change, and/or challenges quickly and enthusiastically

  • Support and lead calls for prospective client partners around Interfolio’s data integration methodology

  • Developing validation master plans, process flow diagrams, test cases, and standard operating procedures

  • Analyzing validation test data to figure out whether systems or processes have met validation criteria

  • Performing root cause analysis

  • Coordinating the implementation or scheduling of validation testing with affected client departments and personnel

  • Crafting, populating, or maintaining databases for tracking validation activities, test results, or validated systems


Qualifications



  • Bachelor's degree

  • Experience architecting and delivering ETL services and analytics applications that use AWS Glue, Redshift, Athena or Aurora

  • Rest API development experience

  • 5+ years of professional software development experience

  • 4+ years of SQL knowledge, ideally on Postgres

  • Programming in any high level language, SQL scripts, and Java scripting

  • Understanding of fundamental software engineering, including data structures and programming constructs that would be found in non-trivial programs

  • Understanding of relational databases including intermediate level SQL

  • Basic understanding on internet protocols, networks, and related technologies, including http, xml, REST and Soap web services

  • Excellent customer communication and project management skills

  • Business Intelligence experience (Tableau, Sisense, Microstrategy, Qlik)

  • Big Data experience (AWS EMR)

  • Experience working in an Agile environment


In addition to a competitive salary, Interfolio offers a robust benefits package that includes medical insurance, unlimited PTO, a wellness benefit, 401k, and professional development opportunities. Our culture sets us apart—we look forward sharing more about our company and our team!

Job Source: Stackoverflow
Job Source: Stackoverflow

Related jobs

© Techie Jobs 2017. All rights reserved.