Join the Pacsun Community
Co-created in Los Angeles, Pacsun exists at the intersection of fashion, music, art, and sport. We’re a lifestyle brand built with and for the next generation, bringing together the culture, creativity, and self-expression that define youth today.
Our curated assortment features some of the most relevant brands and styles in the world, including adidas, Brandy Melville, Fear of God Essentials, alongside Pacsun’s own labels and exclusive collaborations.
But Pacsun is more than what we sell. It’s the community we build.
This is Pacsun. Built with culture. Powered by community.
___________________________________________________________________________________________
About the Job:
The MicroStrategy Engineer is a hands-on technical role responsible for developing, enhancing, administering, and supporting Pacsun’s enterprise reporting and analytics solutions using Strategy (formerly MicroStrategy) on top of the Snowflake retail data warehouse. Reporting to the Manager, Business Analytics & Reporting, the Engineer maintains and evolves the Strategy metadata and reporting environment, builds new business reports and analytics, supports upgrades and production operations, and troubleshoots issues.
The Engineer understands both the technology and the retail business context behind the data, and brings AI into daily BI work, using natural language query, AI-generated insights, and GenAI tools to improve both the analytics delivered and the way it is built.
A day in the life, what you’ll be doing:
- Report and dashboard development. Design, develop, test, deploy, and support enterprise reports, dashboards, dossiers, metrics, and analytical applications in Strategy, taking each solution from business requirements through testing and production support.
- Metadata and semantic layer. Maintain and enhance Strategy metadata, including attributes, facts, metrics, hierarchies, transformations, filters, prompts, schema objects, security, and reusable components, to keep reporting consistent, accurate, and performant.
- Retail measures and business logic. Apply retail business logic, including sales, inventory, cost, margin, gross margin, and sell-through, and ensure reports calculate and present these measures correctly.
- SQL and data warehouse. Work hands-on with SQL, Snowflake, relational databases, and dimensional models to validate reporting logic, reconcile reports to source data, resolve discrepancies, and tune report SQL, in collaboration with data engineers.
- Production support. Provide day-to-day production support, including root-cause analysis, defect resolution, performance tuning, monitoring, and user support.
- Upgrades and environments. Support Strategy upgrades, patches, migrations, environment management, regression testing, and release deployment, using tools such as Workstation, Object Manager, Integrity Manager, and Command Manager.
- AI-enabled analytics. Integrate AI features such as natural language query, AI-generated insights and narratives, and anomaly detection into dashboards, and use GenAI tools (e.g., Copilot, ChatGPT, Strategy AI features, Snowflake Cortex) to accelerate development, documentation, and testing. Evaluate new AI tools and share what works with the team.
- Business partnership. Partner with business stakeholders across merchandising, planning, inventory, stores, eCommerce, finance, supply chain, and marketing to clarify requirements and deliver usable, accurate solutions. Collaborate closely with the Manager, data engineers, the Data Architect, other IT teams, and external partners.
- Governance and security. Follow data governance, row-level security, access control, and responsible AI practices, including accuracy checks on AI-generated output.
- Documentation and continuous improvement. Document report logic, metadata changes, technical designs, and operational procedures, and continuously improve reporting performance, usability, maintainability, and development standards. Stay current on Strategy platform updates and emerging AI analytics trends.
Collaboration & Team Expectations:
- Exemplify integrity, ownership, and a collaborative spirit when working across IT, data engineering, and business teams.
- Communicate clearly with technical and non-technical stakeholders, translating complex data and AI concepts into actionable business insights.
- Contribute to a culture of continuous learning by sharing AI and data knowledge within the BI and analytics team.
- Support cross-functional initiatives, including ERP and financial systems transformation work, as they relate to reporting.
What it takes to join:
- Bachelor’s degree in Computer Science, Information Systems, Analytics, Engineering, or a related field, or equivalent practical experience.
- Mandatory: 3+ years of hands-on Strategy (formerly MicroStrategy) development and engineering experience in an enterprise environment, with strong working knowledge of metadata and architecture, including metrics, attributes, facts, schema objects, reports and dashboards, security, and troubleshooting.
- Mandatory: strong SQL skills and a thorough understanding of relational databases, data warehousing, dimensional modeling, and analytical data structures.
- Mandatory: retail industry experience, with practical understanding of sales, inventory, cost, margin, and related retail analytics and reporting concepts.
- Hands-on experience with Snowflake as a cloud data warehouse, including querying and integration with Strategy.
- Demonstrated ability to develop new enterprise reports and analytics from business requirements through testing and production support.
- Demonstrated experience learning, adopting, and applying AI or generative AI tools in a BI or analytics context (e.g., natural language query, AI-generated narratives, or AI-assisted development).
- Strong analytical, troubleshooting, documentation, and communication skills, with the ability to work effectively with business users, technical peers, and external partners in a fast-paced production environment.
- Fashion, apparel, or specialty retail experience.
- Experience with Strategy administration, upgrades, performance tuning, and environment migrations.
- Strategy (MicroStrategy) certification (Developer or Architect level) and Snowflake certification (e.g., SnowPro).
- Exposure to Tableau, Power BI, or other analytics platforms.
Developing the Community/ Leadership Qualities:
- Operate with the highest level of conduct, integrity, and confidentiality; setting the example for leaders and associates.
- Develop and nurture strong cross functional partnerships; driving business results and inspiring a culture of transparency, collaboration, and accountability.
- Serve as a Pacsun advocate in the industry and marketplace.
- Recruit, identify, develop, and retain talent that delivers performance excellence.
- As a manager, serve as a leader of company culture, norms, and conduct.
- Ability to balance a strong management presence with a high level of approachability, encouraging and eliciting associate feedback and interaction.
Salary Range: ($95,000-$115,000)
Pac Perks:
- Dog friendly office environment
- On-site Cafe
- On-site Gym
- $1,000 referral incentive program
- Generous associate discount of 30-50% off merchandise online and in-stores
- Competitive long term and short-term incentive program
- Immediate 100% vested 401K contributions and employer match
- Calm Premium access for all employees
- Employee perks throughout the year
Physical Requirements:
The physical demands described here are representative of those that are required by an associate to successfully perform the essential functions of this job.
- While performing the duties of this job, the associate is regularly required to talk or hear. The associate is frequently required to sit; stand; walk; use hands to finger, handle or feel; as well as reach with hands and arms.
- Specific vision abilities required by this job include close vision, distance vision, depth perception and ability to adjust focus.
- Ability to work in open environment with fluctuating temperatures and standard lighting.
- Ability to work on computer and mobile phone for multiple hours; with frequent interruptions.
- Required to travel in elevator or stairwells to attend meetings and engage with associates on multiple floors throughout building.
- Hotel, Airplane, and Car Travel may be required.
Position Type/Expected Hours of Work:
This is a full-time position. As a National Retailer, occasional evening and/or weekend work may be required during periods of high volume. This role operates in a professional office environment and routinely uses standard office equipment.
Other Considerations:
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the associate for this job. Duties, responsibilities and activities may change at any time with or without notice. Reasonable accommodations may be made to qualified individuals with disabilities to enable them to perform the essential functions of the role.