[Remote] Associate Data Engineer

Note: The job is a remote job and is open to candidates in USA. Pella Corporation is seeking an Associate Data Engineer to support their Digital, Marketing, and Pro CX teams. This role is responsible for building and maintaining data foundations that enable reliable analytics, focusing on designing data pipelines and ensuring high-quality data for various analytics needs.ResponsibilitiesDesign, build, and maintain reliable and scalable data pipelines using Azure-native services and Databricks to ingest data from digital, marketing, and enterprise systemsDevelop and manage analytics-ready data models using lakehouse and dimensional modeling patterns that support reporting, dashboards, and downstream analytics use casesImplement data transformations, validations, and quality checks within Databricks to ensure data is accurate, consistent, and production readyOptimize data pipelines and models for performance, cost, reliability, and reusability across the analytics ecosystemEnable analytics and BI use cases by making curated data easily consumable in Power BI and other analytics toolsPartner closely with analysts, data scientists, and business stakeholders to translate analytical requirements into scalable technical solutionsCollaborate with platform, integration, and vendor teams to onboard new data sources and evolve existing pipelinesDocument data pipelines, models, definitions, lineage, and assumptions to support governance, discoverability, and reuseContribute to the continuous improvement of analytics standards, engineering best practices, and architecture patternsSupport Digital, Marketing, and Pro CX teams by aligning analytics data with customer journeys, digital tools, and measurement frameworksSkills3+ years of experience in data engineering, analytics engineering, or a related technical analytics roleStrong experience building data pipelines and transformations using Databricks (or comparable cloud-based data engineering platforms)Hands-on experience with Microsoft Azure data services such as Azure Data Lake Storage, Azure Synapse, or similarStrong SQL skills, including complex joins, aggregations, window functions, and query optimizationProficiency in Python for data transformation, automation, and pipeline developmentExperience designing analytics data models (e.g., star schemas, fact and dimension tables)Experience supporting BI and analytics tools, with a strong preference for Power BIFamiliarity with digital and marketing data sources such as web analytics platforms, CRM systems, and advertising platformsAbility to collaborate effectively with analysts, data scientists, and business partnersStrong communication skills with the ability to explain technical concepts to both technical and non-technical audiencesExperience with Databricks lakehouse architectures, Delta Lake, and notebook-based developmentPower BI semantic models, performance optimization, and enterprise reporting patternsData governance, metadata management, and documentation practicesGoogle Cloud Platform technologies such as BigQuery, Google Analytics, or Google Tag ManagerIntegrating data from platforms such as Salesforce, Fullstory, or other customer and digital experience toolsSupporting cross-functional teams such as Digital, Marketing, Customer Experience, or E-commerceModern CI/CD or version control practices for data pipelines and analytics assetsCompany OverviewAs the #1 most-preferred national window and door brand by homeowners across the country, Pella Corporation leads the industry in innovation and design. It was founded in 1927, and is headquartered in Pella, Iowa, USA, with a workforce of 10001+ employees. Its website is http://pellawi.com.Company H1B SponsorshipPella Corporation has a track record of offering H1B sponsorships, with 4 in 2026, 12 in 2025, 14 in 2024, 15 in 2023, 12 in 2022, 8 in 2021, 12 in 2020. Please note that this does not guarantee sponsorship for this specific role.