Associate Data & Analytic Engineer

Your Role at Cabot: You will be reporting to the Senior Data and Analytics Engineer and must have a passion for data with a deep understanding of data concepts and modeling. Your main responsibility will be supporting Cabot in becoming a data-driven organization by ensuring data hygiene, security, and compliance. You will play a crucial role in bridging the gap between business stakeholders and third-party implementation teams for the successful implementation of the Cabot RENEW Digitalization project. Key Responsibilities: - Drive the 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 and deliver enterprise data analytics solutions across various data platforms stacks (Oracle, Microsoft, SAP). - Solve complex business problems through data analysis, building proof-of-concepts 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 for continuous improvement of Master Data Management across platforms. - Support the definition and design of a unified company-wide data architecture to realize the data management strategy. - Translate business requirements into fit-for-purpose solutions and technical requirements for developers. - Research and answer complex questions related to enterprise reporting solutions and other systems. - Work closely with Business Relationship Managers to ensure requirements are met during user acceptance testing (UAT) and secure end-user acceptance signoff. - Create reports, dashboards, and interactive visualizations using Power BI/OAS. - Provide guidance and training to business stakeholders on business intelligence solutions and establish best practices. - Support data ingestion from various sources into the data platform and curate data for consumption. - Ensure compliance with data governance and data security requirements. Qualifications Required: - Bachelor's degree in Computer Science, Information Systems, or related field. Advanced degree is a plus. - 7+ years of related work experience, preferably in a global manufacturing organization. - 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 collaborate with various teams within the organization. - Excellent verbal and written communication skills with strong interpersonal and relationship-building abilities. - Strong programming and scripting skills, particularly in PySpark or Spark on Azure Synapse, or comparable big data technology. - Solid experience with SQL, writing complex queries, joins, and validation logic. - Hands-on experience with Azure Data Factory. - Familiarity with data modeling techniques, including building dimensional schemas and understanding star/snowflake, conformed dimensions, slowly changing dimensions, etc. - Bonus: Experience 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.,