{"schemaVersion":"jobsearcher.job.v1","id":"2f62d2c6d6d3800437dfce58","url":"https://jobsearcher.com/jobs/2f62d2c6d6d3800437dfce58","canonicalUrl":"https://jobsearcher.com/jobs/2f62d2c6d6d3800437dfce58","title":"Associate Data Engineer","description":"Associate Data Engineer\r\nUrbandale, IA or Remote\r\nThe Associate Data Engineer supporting Digital, Marketing, and Pro CX at Pella is responsible for building and maintaining the data foundations that enable scalable, reliable analytics across customer experience, digital performance, and marketing functions. This role focuses on designing data pipelines, transforming and modeling data, and ensuring high-quality, well-governed data is available for analytics, reporting, and advanced use cases.\r\nThis individual will work cross-functionally with the Digital team, Marketing team, and Pro CX team to support a wide range of analytics needs, including digital performance measurement, customer journey analysis, and marketing effectiveness. While not embedded within a single function, the role plays a critical part in enabling these teams by delivering trusted, production-ready data that supports insight generation and decision-making across Pella.\r\nIn this role, you will: Design, build, and maintain reliable and scalable data pipelines using Azure-native services and Databricks to ingest data from digital, marketing, and enterprise systems.\r\nDevelop and manage analytics-ready data models using lakehouse and dimensional modeling patterns that support reporting, dashboards, and downstream analytics use cases.\r\nImplement data transformations, validations, and quality checks within Databricks to ensure data is accurate, consistent, and production ready.\r\nOptimize data pipelines and models for performance, cost, reliability, and reusability across the analytics ecosystem.\r\nEnable analytics and BI use cases by making curated data easily consumable in Power BI and other analytics tools.\r\nPartner closely with analysts, data scientists, and business stakeholders to translate analytical requirements into scalable technical solutions.\r\nCollaborate with platform, integration, and vendor teams to onboard new data sources and evolve existing pipelines.\r\nDocument data pipelines, models, definitions, lineage, and assumptions to support governance, discoverability, and reuse.\r\nContribute to the continuous improvement of analytics standards, engineering best practices, and architecture patterns.\r\nSupport Digital, Marketing, and Pro CX teams by aligning analytics data with customer journeys, digital tools, and measurement frameworks.\r\nRequired Education & Experience: 3+ years of experience in data engineering, analytics engineering, or a related technical analytics role.\r\nStrong experience building data pipelines and transformations using Databricks (or comparable cloud-based data engineering platforms).\r\nHands-on experience with Microsoft Azure data services such as Azure Data Lake Storage, Azure Synapse, or similar.\r\nStrong SQL skills, including complex joins, aggregations, window functions, and query optimization.\r\nProficiency in Python for data transformation, automation, and pipeline development.\r\nExperience designing analytics data models (e.g., star schemas, fact and dimension tables).\r\nExperience supporting BI and analytics tools, with a strong preference for Power BI.\r\nFamiliarity with digital and marketing data sources such as web analytics platforms, CRM systems, and advertising platforms.\r\nAbility to collaborate effectively with analysts, data scientists, and business partners.\r\nStrong communication skills with the ability to explain technical concepts to both technical and non-technical audiences.\r\nPreferred Experience: Experience with:\r\nDatabricks lakehouse architectures, Delta Lake, and notebook-based development.\r\nPower BI semantic models, performance optimization, and enterprise reporting patterns.\r\nData governance, metadata management, and documentation practices.\r\nGoogle Cloud Platform technologies such as BigQuery, Google Analytics, or Google Tag Manager.\r\nIntegrating data from platforms such as Salesforce, Fullstory, or other customer and digital experience tools.\r\nSupporting cross-functional teams such as Digital, Marketing, Customer Experience, or E-commerce.\r\nModern CI/CD or version control practices for data pipelines and analytics assets.\r\nNice to Haves: Experience working in hybrid-cloud or multi-platform analytics environments.\r\nFamiliarity with data quality frameworks, monitoring, and observability.\r\nInterest in contributing to evolving enterprise analytics strategy and standards.\r\nJ-18808-Ljbffr","company":"Socket","rawCompany":"socket","city":"Urbandale","state":"IA","isRemote":false,"isActive":false,"createdAt":"2026-08-08T01:53:08.985Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-2051.00","title":"Data Scientists","slug":"data-scientists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Associate Data Engineer","description":"Associate Data Engineer\r\nUrbandale, IA or Remote\r\nThe Associate Data Engineer supporting Digital, Marketing, and Pro CX at Pella is responsible for building and maintaining the data foundations that enable scalable, reliable analytics across customer experience, digital performance, and marketing functions. This role focuses on designing data pipelines, transforming and modeling data, and ensuring high-quality, well-governed data is available for analytics, reporting, and advanced use cases.\r\nThis individual will work cross-functionally with the Digital team, Marketing team, and Pro CX team to support a wide range of analytics needs, including digital performance measurement, customer journey analysis, and marketing effectiveness. While not embedded within a single function, the role plays a critical part in enabling these teams by delivering trusted, production-ready data that supports insight generation and decision-making across Pella.\r\nIn this role, you will: Design, build, and maintain reliable and scalable data pipelines using Azure-native services and Databricks to ingest data from digital, marketing, and enterprise systems.\r\nDevelop and manage analytics-ready data models using lakehouse and dimensional modeling patterns that support reporting, dashboards, and downstream analytics use cases.\r\nImplement data transformations, validations, and quality checks within Databricks to ensure data is accurate, consistent, and production ready.\r\nOptimize data pipelines and models for performance, cost, reliability, and reusability across the analytics ecosystem.\r\nEnable analytics and BI use cases by making curated data easily consumable in Power BI and other analytics tools.\r\nPartner closely with analysts, data scientists, and business stakeholders to translate analytical requirements into scalable technical solutions.\r\nCollaborate with platform, integration, and vendor teams to onboard new data sources and evolve existing pipelines.\r\nDocument data pipelines, models, definitions, lineage, and assumptions to support governance, discoverability, and reuse.\r\nContribute to the continuous improvement of analytics standards, engineering best practices, and architecture patterns.\r\nSupport Digital, Marketing, and Pro CX teams by aligning analytics data with customer journeys, digital tools, and measurement frameworks.\r\nRequired Education & Experience: 3+ years of experience in data engineering, analytics engineering, or a related technical analytics role.\r\nStrong experience building data pipelines and transformations using Databricks (or comparable cloud-based data engineering platforms).\r\nHands-on experience with Microsoft Azure data services such as Azure Data Lake Storage, Azure Synapse, or similar.\r\nStrong SQL skills, including complex joins, aggregations, window functions, and query optimization.\r\nProficiency in Python for data transformation, automation, and pipeline development.\r\nExperience designing analytics data models (e.g., star schemas, fact and dimension tables).\r\nExperience supporting BI and analytics tools, with a strong preference for Power BI.\r\nFamiliarity with digital and marketing data sources such as web analytics platforms, CRM systems, and advertising platforms.\r\nAbility to collaborate effectively with analysts, data scientists, and business partners.\r\nStrong communication skills with the ability to explain technical concepts to both technical and non-technical audiences.\r\nPreferred Experience: Experience with:\r\nDatabricks lakehouse architectures, Delta Lake, and notebook-based development.\r\nPower BI semantic models, performance optimization, and enterprise reporting patterns.\r\nData governance, metadata management, and documentation practices.\r\nGoogle Cloud Platform technologies such as BigQuery, Google Analytics, or Google Tag Manager.\r\nIntegrating data from platforms such as Salesforce, Fullstory, or other customer and digital experience tools.\r\nSupporting cross-functional teams such as Digital, Marketing, Customer Experience, or E-commerce.\r\nModern CI/CD or version control practices for data pipelines and analytics assets.\r\nNice to Haves: Experience working in hybrid-cloud or multi-platform analytics environments.\r\nFamiliarity with data quality frameworks, monitoring, and observability.\r\nInterest in contributing to evolving enterprise analytics strategy and standards.\r\nJ-18808-Ljbffr","datePosted":"2026-08-08T01:53:08.985Z","dateModified":"2026-08-08T01:53:08.985Z","hiringOrganization":{"@type":"Organization","name":"Socket","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Urbandale","addressRegion":"IA","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"2f62d2c6d6d3800437dfce58"},"url":"https://jobsearcher.com/jobs/2f62d2c6d6d3800437dfce58"}}