Associate Data & Analytic Engineer

Your Role at Cabot

Reporting to the Senior Data and Analytics Engineer, the Data Engineer must have a passion for data and deep understanding of data concepts and modeling. The ideal candidate has experience understanding process and reporting needs in a manufacturing organization and will support Cabot in becoming a data driven organization by stewardship of data hygiene, security, and compliance. This position plays the important role of bridging the gap between our business stakeholders and third-party implementation team and will be key to the continued successful implementation of the Cabot RENEW Digitalization project.

The Data and Analytics team support key initiatives that accelerate the development of the data management platforms and architecture (Master Data Management, Data Quality Monitoring, Master Data Governance). The Data Engineer will collaborate with various stakeholders across the Company to deliver reporting solutions and facilitate seamless data access across the corporate functions and plant solutions landscape

This role requires familiarity with BI, Data Warehousing, ETL, relational database concepts as well as experience in the data and analytics domain.

How You Will Make An Impact

• Driving modernization of the architecture and design of data and analytics systems, including Data Warehouse, Application Integrations, Master Data Management, Data Quality Monitoring, and Master Data Governance solutions
• Collaborate with business champions and the architecture & innovation team, to gather detailed business requirements, focused on delivering enterprise data analytics solutions across various data platforms stacks (Oracle, Microsoft, SAP).
• Solve complex business problems through data analysis, building proof-of-concepts to prove out business value in a deadline-driven environment, with a quality-first mindset
• Collaborate with data owners and the integrations team to inventory source systems and data movement throughout various systems to drive continuous improvement and streamline Master Data Management across platforms
• Support the definition and design of a unified company wide data architecture that helps realize the data management strategy
• Translate Business requirements to fit for purpose solutions and technical requirements for developers
• Work across the organization to research and answer complex questions related to enterprise reporting solutions and other systems.
• Work closely with the Business Relationship Managers to make sure requirements are met during user acceptance testing (UAT), including tracking issues through to resolution and securing end-user acceptance signoff.
• Analyze, define, build, test, and deliver reports/dashboards/interactive visualizations using Power BI/OAS.
• Provide guidance and training to business stakeholders on business intelligence solutions and establish best practices.
• Support Ingestion of data from various sources into data platform and curate the data for consumption.
• Support compliance with data governance and data security requirements

• Bachelors degree in Computer Science, Information Systems, or other with related work experience. Advanced degree is a plus.
• 7+ years of related work experience, working in a global manufacturing organization a plus
• Experience in building data models and visualizations using Power BI.
• Demonstrated experience with master data, metadata, data architecture, data governance, data quality, data modeling, and data standards
• Strong interpersonal and teamwork skills with the ability to work with various other teams within the organization
• Excellent verbal and written communication with strong interpersonal and relationship-building skills.
• Strong programming and scripting skills in particular PySpark or Spark on Azure Synapse, or comparable big data technology.
• Solid experience with SQL: writing complex queries, joins, validation logic.
• Hands-on experience with Azure Data Factory.
• Experience working with Azure Data Lake Storage (or equivalent) and with layered data design (e.g., Bronze/Silver/Gold medallion architecture).
• Familiarity with data modeling techniques and experience building dimensional schemas, understanding star/snowflake, conformed dimensions, slowly changing dimensions, etc.
• Bonus: Experience working with Azure Synapse Analytics/Microsoft Fabric for data transformation at scale.
• Bonus: Experience with DevOps/CI-CD pipelines for data solutions, and with monitoring/observability of data pipelines.
• Bonus: Experience with OBIEE/OAS/OAC.