Data Engineer

CAS uses intuitive technology, unparalleled scientific content and unmatched human expertise to help companies create groundbreaking innovations that benefit the world. As the scientific information solutions division of the American Chemical Society, CAS manages the largest curated reservoir of scientific knowledge, and for 116 years, has helped innovators mine, assess and apply that information to keep businesses thriving. The CAS team is global, diverse, endlessly curious and strives to make scientific insights accessible to innovators worldwide.

CAS is currently seeking a Data Engineer. This position will be located in our headquarters in Columbus, Ohio.

Data engineers are responsible for supporting ingestion and transformation pipelines that handle data for analytical or operational uses across broad business areas and enterprise data domains. The data engineer often works as a dedicated member of support teams, focused on providing production stability for data processing workflows that will be used by analytics groups and data scientists who are interrogating information for predictive analytics, machine learning and data mining purposes.

Duties

• Delivers data engineering expertise for ingestion and transformation pipelines that handle data for analytical or operational uses across wide variety of business needs and enterprise data domains.

• Ensures production stability for data processing workflows used by analytics groups and data scientists who are interrogating information for predictive analytics, machine learning and data mining purposes.

• Safeguards best practices of data architecture including accountability, governance, and requirements.

• Perform other duties as assigned

Qualifications

• Minimum 2 years software engineering experience with Bachelor’s degree in Computer Science or similar discipline

• Experience across a broad range of modern data science and analytics tools (e.g., SQL, Hadoop, Spark, Python, R)

• Experience with DevOps, Continuous Integration and Continuous Delivery (Maven, Jenkins, Stash, Ansible, Docker)

• Experience with programming in at least one of the following languages: Scala, Spark, Python, Java, as well as Unix shell skills

• Support policies and procedures enforced by the data governance committee to ensure best practices of data architecture including accountability, governance, and requirements

• Experience building Data Ingestion on the cloud

• Understanding of principles, best practices and trade-offs of schema design for both Relational and NoSQL database systems

• Understanding of Big Data NoSQL databases/technologies (MarkLogic, Hbase, Hive, Spark, MongoDB)

• Strong written and verbal communication skills.

Desired, but not required:

• Knowledge and experience in chemistry, drug discovery/development, or medical related industry

• Experience in Large Big Data Development and Deployment Automation in Private/Public cloud preferably on AWS

• Hands on experience in big data environments such as (Cloudera or Hortonworks)

• Experience working with XML

CAS offers a competitive salary and comprehensive benefits package, including a generous vacation plan, medical, dental, vision insurance plans, and employee savings and retirement plans.  Candidates for this position must be authorized to work in the United States and not require work authorization sponsorship by our company for this position now or in the future.  EEO/Minority/Female/Disabled/Veteran