Share this Job

Senior Data Engineer

Date: Feb 18, 2021

Location: Washington, DC, US, 20036

Company: American Chemical Society


Division and Unit Overview

The Washington IT Division of the American Chemical Society provides its members and the worldwide scientific community a comprehensive collection of high-quality information products and services for the practice and advancement of the chemical sciences.  ACS’s members and volunteers are the heart of the organization, and the Society and Administrative Technology (SAT) Department within the Washington IT Division aims to support their professional and academic pursuits by delivering intuitive, high quality, highly available, and secure systems and applications.  We intend to exceed the expectations of our business partners by anticipating, understanding, and validating their business needs; providing useful, cost-effective solutions and support promptly; managing data securely and providing the necessary architecture to use and deliver in effective ways; adhering to established guidelines and standards, and continuously adapting to the evolving environment.


Position Summary 

The position reports to the Senior Manager, Data Science & Engineering within the Society & Administrative Technology (SAT) department. The Senior Data Engineer is responsible for leading data management and data engineering efforts, including data ingestion and curation, ETL processes, ad-hoc and management reporting, analytics, dashboard development, and data acquisition from transactional systems.  The Senior Data Engineer works to ensure the data integration platforms and architecture are maintained and services delivered to meet the evolving demands of business functionality and technical platforms landscape.


The Data Science and Engineering team works closely with all aspects of the full spectrum of data including analysis, architecture, development, visualization, reporting, and advanced analytics. The Data Scientists, Data Engineers and Architects work to build data pipelines that efficiently and reliably move data across systems, as well as the next generation of data tools (including reports, visualizations, and other analytic tools) to enable users to take full advantage of this data.


In this role, the work will broadly influence ACS’s data consumers and analysts. The Senior Data Engineer will get the opportunity to work with focused and scaled objectives while working with a variety of rich data sources. In addition, this role will work on data architecture, development, visualization and analytics projects to provide information and insight to enable data driven business decisions that help optimize performance and increase value for ACS constituents.


Position Accountabilities

  1. Delivers data engineering expertise for ingestion and transformation pipelines that handle data for analytical or operational uses across various business needs and enterprise data domains.
  2. Defines structure, integrates, governs, stores, describes, models, and maintains data in the enterprise for accuracy and usage while maintaining the current state
  3. Safeguards best practices of data architecture, including accountability, governance, and requirements.
  4. Maintain awareness of new developments and trends in the data integration and data warehousing space and provide oversight and input for maintaining and evolving data model design practices and data integration architecture for the organization.
  5. Discover, protect, archive, and discard data to improve information security, improve test data management, and reduce storage costs.
  6. Identify and develop the necessary tools and techniques to exploit these emerging technology trends.
  7. Perform other duties as assigned



  • Bachelor’s degree in Computer Science, Information Systems, Mathematics or similar discipline
  • Technical expertise
    • Experience working with a broad range of modern data science and analytics tools (e.g., SQL, Python, Tableau, ETL tools, and cloud platforms such as AWS)
    • 7+ years of experience programming in SQL (T-SQL, PL/SQL, or other SQL-based database programming languages)
    • 7+ years of experience with defining database structures and integration pipelines
    • 7+ years of experience with data architecture, understanding database schemas, and building data models that enable reporting and analytics 
    • 5+ years of experience with developing canned and custom application reports using tools such as SQL Server Reporting Services
    • One or more years of experience working with Python
    • Ability to identify, analyze, and interpret trends or patterns in complex data sets 
    • Ability to understand the principles of API development
  • Data management expertise
    • 7+ years of experience with data management, including governance, master data management, as well as policies around data standards and acceptable use of data
    • 3+ years of experience with implementing policies and procedures around data governance to ensure best practices of data architecture, including accountability, governance, and requirements
  • Business analysis and soft skills
    • Business Analysis: Ability to quickly transform a conversation into a set of business requirements and transform business requirements  into technical specifications 
    • Quality Assurance and Operations: Manage the quality assurance and operations for the business intelligence and data products that are already released as well as developed 
    • Collaboration: Ability to build partnerships with cross‐functional teams to develop a comprehensive understanding of key data drivers and opportunities within the business
    • Effective Communication: Ability to communicate findings from data analysis and visualization and present information clearly and succinctly, and identify the analytic needs for departments to enable business results. Departments will include but not be limited to Membership, Marketing, Society Business Solutions, Education, and Information Technology
    • Drives Results: Uncover, gather, compile, and deliver insightful, value‐added business analyses and findings to senior management and their teams while fostering an environment of accountability for results. 
    • Project Management: Support  the  creation of  high‐quality  and actionable  data products suitable  for delivery  to  management and team members 
    • Action-Oriented: Derive insights from transactional data 
    • Manage Ambiguity: Operate effectively, even when things are not certain, or the way forward is not clear Strong written and verbal communication skills


Nearest Major Market: Washington DC

Job Segment: Database, Information Systems, Computer Science, SQL, QA, Technology, Quality