BI Engineer - ACS

BI Engineer

The American Chemical Society is the world’s largest scientific membership association and one of the top ten science publishers in the world. We publish more than 50 well-reputed and peer-reviewed journals in all aspects of chemistry and related fields. Information Technology is responsible for providing services to programs that reach over 150,000 members and hundreds of thousands of our journal readers at thousands of institutions of higher learning and leading business and research organizations.

Our Information Technology (IT) units have more than 200 professionals engaged in harnessing the most advanced IT technologies including Artificial Intelligence (AI), Business Analytics, efficient search technologies Big Data, and Cloud-based web sites. Our Infrastructure team is exploring new technologies such as Blockchain and Container technologies to enhance our platforms to deliver complex applications that advance ACS’s mission of “Advancing the broader chemistry enterprise and its practitioners for the benefit of Earth and its people”.

The IT Publications Software Engineering group is responsible for the creation, maintenance and support of enterprise-level information technology systems that produce publication-ready articles for the ACS Journals and weekly news magazine. We support publication of about fifty scientific journals, a weekly news magazine, and an extensive IT network of over 200 editorial offices. The Software Engineering Group is responsible for the design, construction and maintenance of applications that assist the entire publication process, from author submission through peer review, editor acceptance, technical editing, graphics editing, page composition, delivery on web sites for Internet access.

Position Summary

The incumbent in this position will be part of the Data Science and Engineering Technologies team and will be filling in for a BI engineer must be able to analyze, design, develop, integrate, run, and support various Looker based Dashboards, LookML and reporting requirements across multiple Data warehouses and data architectures involving various cloud based data sources and possibly on prem data sources as well.

This position will be required to:

• Work with Business Owners, Data Warehouse teams and Business Intelligence teams [On Looker/Tableau etc] to identify requirement on new and existing data warehouses and data marts and implement LookML Logic to design, develop and launch new Looks and dashboards based on the business needs.
• Work with business users and technical designers to assist in efficient LookML data model designs that meet business unit requirements involving integrations of various ACS publications and other related data retrieved into various data warehouses/marts.
• Work with management, project managers and other lead developers and architects to help design and develop Business Intelligence artificats and assets that can be leveraged across the organization.
• Understand relationship between GCP products well – Primarily Data Fusion, Big Query and Looker, and demonstrate experience in Advanced Looker development and interfacing with Google Big Query [Comparable DW acceptable].
• Good working knowledge of UX/UI development within and outside looker.
• Provide strong leadership and mentoring for less senior personnel in the areas of design, implementation, and professional development.
• Be flexible to work during non-Business hours.

The ideal candidate will:

• Have experience with Google Looker or Equivalent, Interfacing with Big Query or Equivalent, to establish sound Business Intelligence for ACS, and to establish best practices within the team. Very good understanding of SQL queries [both generated and custom written]
• Have an extremely in-depth understanding of features and capabilities of looker with demonstrable experience.
• HTML/Java script and other UI technologies is a plus.
• Have a working knowledge of Tableau and other BI tools which may assist.
• Have strong written and verbal communication skills

Education and Experience and Technical Requirements:
Bachelor’s degree or equivalent experience. 5+ years with proven results in system development, implementation, and operations is required. Strong understanding of design patterns with a focus on tiered, large-scale data systems.