ENTERPRISE DATA WAREHOUSE (EDW) SOLUTION ARCHITECT

ABOUT YOU:

Are you an experienced data architect ready to design and implement scalable, high-performing data solutions? Jostens is seeking an Enterprise Data Warehouse (EDW) Solution Architect to lead the development and optimization of our data warehouse architecture. This role is critical to ensuring our data environment supports business intelligence, analytics, and reporting needs while maintaining security, governance, and scalability.

YOU HAVE:

• Technical Expertise. Proven experience designing and implementing large-scale EDW solutions using technologies like Snowflake, Redshift, or Google BigQuery.

• Integration & Modeling Skills. Expertise in ETL/ELT processes and data integration tools (e.g., FiveTran, dbt, Pentaho, Apache Airflow) and strong knowledge of data modeling (star/snowflake schema) and SQL optimization.

• Cloud Platform Proficiency. Experience with cloud platforms, particularly AWS and Snowflake.

• Analytical Skills. Proficiency in SQL with the ability to analyze and optimize data processes.

• Experience. 8+ years of experience in data warehousing, data architecture, or solution architecture.

• Education. Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Engineering, or a related field.

  YOU WILL:

• Architect and Design Solutions. Lead the design and implementation of scalable and secure data warehouse solutions to meet enterprise data needs.

• Collaborate Across Teams. Partner with business units, data scientists, and analysts to gather requirements and ensure the platform supports business intelligence, reporting, and analytics.

• Develop Data Pipelines. Design and implement robust ETL/ELT processes, data models, and pipelines for efficient and automated data flow across the organization.

• Document and Train. Maintain architecture documentation and provide training and support for development teams as needed.

• Ensure Data Integrity. Establish quality assurance protocols to guarantee data accuracy and consistency across all processes.

• Implement Governance and Security. Develop data governance frameworks and enforce security standards and best practices to ensure compliance with regulatory requirements.

• Preferred Advanced Framework Knowledge. Experience with Data Lakes, Data Governance frameworks, and Master Data Management (MDM) concepts.

• Preferred Modern Architecture Understanding. Familiarity with data warehouse architectures like dimensional modeling, Data Vault, Lambda, or Kappa.

• Preferred Programming Skills. Proficiency in scripting languages such as Python or R.

• Typical/expected % of overnight travel: None to Minimal.

  LOVE WHERE YOU WORK:

• We care about your health. We offer competitive healthcare (health, dental, vision, coverage) in addition to voluntary benefits including home and car insurance, pet insurance, flexible spending account, amongst many more.

• We invest in your future. Our 401K plan has immediate vesting, so you can start saving for retirement right away.

• We believe in flexibility. We provide hybrid work options.

• We want you to unplug when needed. We believe in taking your time off without guilt and offer accrued paid time off and company paid holidays. *For Washington residents, you will receive 13 vacation days, 8 paid sick leave, 8 company paid holidays, and family paid leave.

• We care about your development. We support tuition reimbursement after 6 months of service.

• We believe in pay transparency. The salary range is $XX to $XX with annual bonus eligibility.

  APPLICATION DEADLINE: Feb. 28, 2025

  ABOUT US:

  Jostens leads the student commemoration market and has been serving local communities for over 125 years. We work with thousands of K-12 schools, colleges and universities each year, and have the honor of partnering with beloved sports teams and esteemed organizations across the country. Our iconic products — like yearbooks, letter jackets, class jewelry and championship rings — keep meaningful traditions alive and inspire millions of people to celebrate their unique stories, milestone moments and biggest accomplishments every year. We have 13 first-class facilities across the globe, from North America to the Caribbean. Watch a short video about us here (https://f.io/HIAsH659) .

  ALL ABOUT TECHNOLOGY:

  Our Technology organization combines planning, analysis, and development in combination with both enterprise retail and manufacturing platforms as well as custom development using primarily Java, web services, and web application frameworks like ReactJS/NodeJS. The Technology organization manages priorities through a centralized quarterly planning in close collaborative with business decision-making and strategy, directly supporting leadership in Marketing, Sales, Digital & Operations. Delivery is managed through typically an agile, two-week scrum or Kanban methodology leveraging a suite of Atlassian products. The Technology teams are structured organizationally to focus on key platforms and the business units that they. Though the utilization of best-in-class technical software, such as AWS, Tableau, SAP BPC, Oracle EBS, Salesforce, & Microsoft 360, you will get to play a critical role in determining technology solutions that steer our business. Jostens allows for a hybrid work setting that focuses on creating professional and personal development. We can’t wait to show you what our Technology Team has to offer at Jostens!

  AMERICANS WITH DISABILITIES ACT (ADA):

  Jostens is committed to the full inclusion of all qualified individuals. If reasonable accommodation is required to fully participate in the job application or interview process, or to perform the essential functions of the position, please reach out to our HR team at recruiter@jostens.com or (952) 830-3399.

  Jostens is an Equal Opportunity Employer and complies with applicable employment laws. EOE/M/F/Vet/Disabled are encouraged to apply.

  California Privacy Policy: https://www.jostens.com/about/california-employee-privacy-policy