Intuit Inc.
Overview
At Intuit, a software leader serving over 100 million customers worldwide with financial technology products like TurboTax, QuickBooks, and Credit Karma, you'll find a dynamic and rewarding career. Within our Global Business Solutions Group, we pride ourselves on a supportive and collaborative work environment, where 'Stronger Together' isn't just a motto but a core value that fosters teamwork and belonging. Our culture is deeply values-driven, with 'Customer Obsession' at its heart, ensuring every project and initiative is focused on delivering meaningful impact for our customers. While we thrive in a rapid-paced, innovative environment that demands quick adaptation to new developments, our Marketing Operations team provides the operational backbone for all marketing efforts. We orchestrate the systems, processes, and technology, managing data, automating workflows, and measuring ROI, thereby empowering our creative and strategic marketers to deliver high-impact campaigns. Join us to play a pivotal role in this exciting landscape. We are seeking a highly skilled and motivated MOPS Data Engineer to join our Marketing Operations team. This role is central to the strategic transition of our marketing data onboarding process for TY'25 and beyond, implementing and managing a modern data architecture that enhances data integrity and operational efficiency. You will operate within a collaborative model, working closely with various teams to ensure seamless data flow and quality for high-impact marketing activations. Responsibilities
Data Pipeline Design & Management (ETL - SnapLogic):
Design, build, and maintain scalable data pipelines using SnapLogic, our new modern ETL platform. Manage the flow of data from our Change Data Capture (CDC) system into the new Marketing Data Warehouse (MDW), including integrations, data mapping, and transformation logic. Strictly adhere to transformation guardrails within SnapLogic, permitting only marketing-specific transformations (e.g., scalar operations, simple IF/ELSE conditional logic, string and number manipulations, date masking/formatting), and prohibiting API calls or hard-coded filters. Test and validate ETL pipelines, ensuring data accuracy and reliability for marketing activation. Adhere to SDLC best practices, including peer reviews, version control, and deployment processes for all production implementations. Troubleshoot and debug complex issues within data pipelines.
Data Quality Management (DQM):
Configure and manage CDC to MDW Parity Checks to validate CG (Customer Group) data for count and value consistency between the source (CDC) and the Marketing Data Warehouse (MDW). Onboard data to the DQM system, specifically from CDC to MDW. Utilize SQL for writing queries, joins, and data profiling to support robust data quality initiatives.
Data Architecture & Schema Management:
Drive Adobe Experience Platform (AEP) schema changes required for new or updated data attributes. Provide detailed attribute specifications to the GTM Technology team for MDW schema updates, supporting a 1-day turnaround SLA for adding attributes to the MDW. Collaborate with the GTM Technology team as they manage the MDW stack and Reverse ETL (rETL) processes.
Collaboration & Operational Excellence:
Act as a trusted bridge between data engineering, platform, and business teams, translating complex business requirements into resilient, observable pipeline flows. Understand and account for data dependencies for marketing campaigns and operational use cases. Maintain a strong observability, monitoring, and operational ownership mindset for all data flows. Ensure solid understanding and adherence to data security, privacy, and PII handling best practices.
Qualifications & Skills:
Proficient to expert-level skills in data engineering, with a strong background in ETL processes and data pipeline development. Proficiency in scripting languages, specifically Python and JavaScript. Expertise in SQL for writing complex queries, performing joins, and data profiling. Familiarity with data models, data structures, and schema management. Understanding of both streaming (e.g., Kafka) and batch data processing constructs. Experience with modern ETL platforms; direct experience with SnapLogic is highly desirable. Experience with MarTech platforms like Adobe Experience Platform (AEP) is a strong plus. Strong critical thinking and problem-solving skills, coupled with a curious mindset. Ability to troubleshoot and debug complex issues in data pipelines effectively. Ability to work effectively in a fast-paced, collaborative, and innovative environment, understanding organizational dynamics and decision pathways. Awareness of key business data elements, SLAs, and regulatory requirements relevant to marketing data. Adherence to SDLC best practices, including peer reviews, version control, and robust deployment processes.
#J-18808-Ljbffr
At Intuit, a software leader serving over 100 million customers worldwide with financial technology products like TurboTax, QuickBooks, and Credit Karma, you'll find a dynamic and rewarding career. Within our Global Business Solutions Group, we pride ourselves on a supportive and collaborative work environment, where 'Stronger Together' isn't just a motto but a core value that fosters teamwork and belonging. Our culture is deeply values-driven, with 'Customer Obsession' at its heart, ensuring every project and initiative is focused on delivering meaningful impact for our customers. While we thrive in a rapid-paced, innovative environment that demands quick adaptation to new developments, our Marketing Operations team provides the operational backbone for all marketing efforts. We orchestrate the systems, processes, and technology, managing data, automating workflows, and measuring ROI, thereby empowering our creative and strategic marketers to deliver high-impact campaigns. Join us to play a pivotal role in this exciting landscape. We are seeking a highly skilled and motivated MOPS Data Engineer to join our Marketing Operations team. This role is central to the strategic transition of our marketing data onboarding process for TY'25 and beyond, implementing and managing a modern data architecture that enhances data integrity and operational efficiency. You will operate within a collaborative model, working closely with various teams to ensure seamless data flow and quality for high-impact marketing activations. Responsibilities
Data Pipeline Design & Management (ETL - SnapLogic):
Design, build, and maintain scalable data pipelines using SnapLogic, our new modern ETL platform. Manage the flow of data from our Change Data Capture (CDC) system into the new Marketing Data Warehouse (MDW), including integrations, data mapping, and transformation logic. Strictly adhere to transformation guardrails within SnapLogic, permitting only marketing-specific transformations (e.g., scalar operations, simple IF/ELSE conditional logic, string and number manipulations, date masking/formatting), and prohibiting API calls or hard-coded filters. Test and validate ETL pipelines, ensuring data accuracy and reliability for marketing activation. Adhere to SDLC best practices, including peer reviews, version control, and deployment processes for all production implementations. Troubleshoot and debug complex issues within data pipelines.
Data Quality Management (DQM):
Configure and manage CDC to MDW Parity Checks to validate CG (Customer Group) data for count and value consistency between the source (CDC) and the Marketing Data Warehouse (MDW). Onboard data to the DQM system, specifically from CDC to MDW. Utilize SQL for writing queries, joins, and data profiling to support robust data quality initiatives.
Data Architecture & Schema Management:
Drive Adobe Experience Platform (AEP) schema changes required for new or updated data attributes. Provide detailed attribute specifications to the GTM Technology team for MDW schema updates, supporting a 1-day turnaround SLA for adding attributes to the MDW. Collaborate with the GTM Technology team as they manage the MDW stack and Reverse ETL (rETL) processes.
Collaboration & Operational Excellence:
Act as a trusted bridge between data engineering, platform, and business teams, translating complex business requirements into resilient, observable pipeline flows. Understand and account for data dependencies for marketing campaigns and operational use cases. Maintain a strong observability, monitoring, and operational ownership mindset for all data flows. Ensure solid understanding and adherence to data security, privacy, and PII handling best practices.
Qualifications & Skills:
Proficient to expert-level skills in data engineering, with a strong background in ETL processes and data pipeline development. Proficiency in scripting languages, specifically Python and JavaScript. Expertise in SQL for writing complex queries, performing joins, and data profiling. Familiarity with data models, data structures, and schema management. Understanding of both streaming (e.g., Kafka) and batch data processing constructs. Experience with modern ETL platforms; direct experience with SnapLogic is highly desirable. Experience with MarTech platforms like Adobe Experience Platform (AEP) is a strong plus. Strong critical thinking and problem-solving skills, coupled with a curious mindset. Ability to troubleshoot and debug complex issues in data pipelines effectively. Ability to work effectively in a fast-paced, collaborative, and innovative environment, understanding organizational dynamics and decision pathways. Awareness of key business data elements, SLAs, and regulatory requirements relevant to marketing data. Adherence to SDLC best practices, including peer reviews, version control, and robust deployment processes.
#J-18808-Ljbffr