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.
Responsibilities:
- Design, build, and maintain reliable and scalable data pipelines using Azure-native services and Databricks to ingest data from digital, marketing, and enterprise systems
- Develop and manage analytics-ready data models using lakehouse and dimensional modeling patterns that support reporting, dashboards, and downstream analytics use cases
- Implement data transformations, validations, and quality checks within Databricks to ensure data is accurate, consistent, and production ready
- Optimize data pipelines and models for performance, cost, reliability, and reusability across the analytics ecosystem
- Enable analytics and BI use cases by making curated data easily consumable in Power BI and other analytics tools
- Partner closely with analysts, data scientists, and business stakeholders to translate analytical requirements into scalable technical solutions
- Collaborate with platform, integration, and vendor teams to onboard new data sources and evolve existing pipelines
- Document data pipelines, models, definitions, lineage, and assumptions to support governance, discoverability, and reuse
- Contribute to the continuous improvement of analytics standards, engineering best practices, and architecture patterns
- Support Digital, Marketing, and Pro CX teams by aligning analytics data with customer journeys, digital tools, and measurement frameworks
Requirements:
- 3+ years of experience in data engineering, analytics engineering, or a related technical analytics role
- Strong 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 similar
- Strong SQL skills, including complex joins, aggregations, window functions, and query optimization
- Proficiency in Python for data transformation, automation, and pipeline development
- Experience designing analytics data models (e.g., star schemas, fact and dimension tables)
- Experience supporting BI and analytics tools, with a strong preference for Power BI
- Familiarity with digital and marketing data sources such as web analytics platforms, CRM systems, and advertising platforms
- Ability to collaborate effectively with analysts, data scientists, and business partners
- Strong communication skills with the ability to explain technical concepts to both technical and non-technical audiences
- Experience with Databricks lakehouse architectures, Delta Lake, and notebook-based development
- Power BI semantic models, performance optimization, and enterprise reporting patterns
- Data governance, metadata management, and documentation practices
- Google Cloud Platform technologies such as BigQuery, Google Analytics, or Google Tag Manager
- Integrating data from platforms such as Salesforce, Fullstory, or other customer and digital experience tools
- Supporting cross-functional teams such as Digital, Marketing, Customer Experience, or E-commerce
- Modern CI/CD or version control practices for data pipelines and analytics assets