Data Warehouse Analyst

Shutterfly • Eden Prairie, MN

217d • $93,250 - $112,500

About The Position

At Lifetouch (part of the Shutterfly family of brands), we believe there is extraordinary power in the self-expression. Built on the tradition of “Picture Day”, Lifetouch has captured the unique personalities of children and families for more than 85 years. We are seeking a skilled and proactive Data Warehouse Analyst to join our team. This role is responsible for designing, developing, and maintaining BI solutions that transform data into insights, enabling data-driven decision-making across the organization.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field
• 2-3 years experience as a BI Developer or in a similar role.
• Strong experience with BI tools (e.g., Power BI, Tableau, Qlik).
• Advanced SQL skills, including the ability to write, debug, and optimize complex queries using joins, subqueries, window functions, and performance tuning techniques.
• Proficiency in data modeling.
• Familiarity with ETL tools and processes.
• Excellent problem-solving, analytical, and communication skills.
• Understanding of data warehousing concepts and data governance best practices.

Nice To Haves

• Experience with PowerBI and Microsoft Power Platform
• Knowledge of scripting languages (e.g., Python, R) for data analysis.
• Experience working in Agile or Scrum environments.

Responsibilities

• Design, implement, and maintain BI software and systems, ensuring integration with databases and data warehouses.
• Develop dashboards, reports, and visualizations to present complex datasets in a clear and actionable manner.
• Build and maintain data models to support analytical needs, ensuring data accuracy, consistency, and relevance.
• Manage the extraction, transformation, and loading (ETL) of data from various sources into centralized data repositories.
• Engage with business stakeholders to understand data requirements and translate them into effective BI solutions.
• Provide ongoing support and training to users on BI tools and analytical practices.
• Perform regular updates and maintenance on BI systems to enhance performance and incorporate new features or data sources.
• Ensure data quality, completeness, and reliability. Implement and support data governance standards and best practices.
• Keep abreast of emerging BI tools, technologies, and trends to continually enhance BI capabilities and recommend improvements.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Industry: Personal and Laundry Services
• Education Level: Bachelor's degree