Senior MicroStrategy & AI Analytics Developer

Pacific Sunwear Stores LLC; Anaheim (CA); On-site; USD 115,000 - 150,000; Full time

Benefits offered by this job

Dog-friendly office

401K with employer match

Referral incentive program

Associate discount

On-site cafe

On-site gym

Car wash service

Job summary

Pacsun is seeking a Senior MicroStrategy & AI Analytics Developer to design, build, and optimize the enterprise MicroStrategy environment with AI extensions. You will own dashboards, reports, and dossiers supporting merchandising, retail operations, and customer experience decisions.

The ideal candidate has 5+ years in MicroStrategy development, strong SQL skills, Snowflake experience, and familiarity with AI governance.

Qualifications

• Bachelor's degree in CS/IS/Data Analytics or related field.
• Minimum of 5 years hands-on MicroStrategy development experience.
• Experience applying AI or generative AI within BI/analytics.
• Strong SQL skills and Snowflake experience.
• Retail industry experience required.
• Familiarity with AI governance and data privacy in analytics.
• Excellent communication and problem-solving skills.

Responsibilities

• Design, develop, and maintain MicroStrategy schema objects, reports, dossiers, and dashboards.
• Build the MicroStrategy semantic layer, cubes, and metadata architecture for self-service analytics.
• Integrate AI capabilities including NLQ, narratives, anomaly detection, and predictive analytics.
• Collaborate with data science and AI Analytics leadership to support AI/ML use cases and pipelines.
• Write and optimize SQL against Snowflake and manage ETL/ELT and OLAP processes.
• Leverage GenAI tools to accelerate report development and documentation.
• Engage with business stakeholders to translate requirements into actionable analytics.
• Ensure data governance, security, and responsible AI practices across reporting.
• Troubleshoot data, performance, and reporting issues within MicroStrategy environment.
• Create technical documentation and mentor junior BI developers.
• Stay updated on MicroStrategy updates and AI trends.

Skills

MicroStrategy

SQL

Snowflake

AI analytics

Retail analytics

Education

Bachelor's degree in CS/IS/Data Analytics

Tools

MicroStrategy ONE

GenAI tools

Job description

Job Category: Information Technology

Requisition Number: SENIO010349

• Posted : September 11, 2026
• Full-Time
• On-site

Locations

Showing 1 location

Description

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 Senior MicroStrategy & AI Analytics Developer is a hands-on technical expert responsible for designing, building, and optimizing Pacsun's enterprise MicroStrategy environment while extending it with AI and generative-AI-powered analytics capabilities. This role owns the development of dashboards, dossiers, and reports that power merchandising, retail operations, and customer experience decisions, and partners closely with the Director, System Integration and AI Analytics to embed machine learning, predictive analytics, and natural-language/GenAI features into the BI platform. The ideal candidate combines deep MicroStrategy schema and development expertise with a strong working knowledge of Snowflake, modern data architecture, and emerging AI tools, and is comfortable translating ambiguous business questions into scalable, trustworthy analytics solutions.

A day in the life, what you’ll be doing:

• Design, develop, and maintain MicroStrategy schema objects (attributes, facts, hierarchies, transformations), reports, dossiers, and dashboards that support merchandising, retail operations, and executive reporting.
• Build and optimize the MicroStrategy semantic layer, cubes, and metadata architecture to ensure accurate, performant, and scalable self-service analytics across the enterprise.
• Integrate AI and generative AI capabilities into the BI platform, including natural language query (NLQ), AI-generated insights and narratives, anomaly detection, and predictive/prescriptive analytics features within MicroStrategy dashboards.
• Partner with data science and the Director, System Integration and AI Analytics to prepare data models, feature sets, and semantic layers that support AI/ML use cases, RAG pipelines, and vector-enabled analytics.
• Write and optimize complex SQL against Snowflake and other enterprise data sources; design and tune ETL/ELT and OLAP processes feeding both traditional BI and AI/ML workloads.
• Leverage GenAI tools (e.g., Copilot, ChatGPT, MicroStrategy AI features) to accelerate report development, automate documentation, and improve developer and analyst productivity.
• Collaborate with business stakeholders across merchandising, planning, marketing, and finance to gather requirements and translate them into performant BI and AI-enabled analytics solutions.
• Ensure data governance, security, and responsible AI practices are followed within all reporting and analytics deliverables, including row-level security, access controls, and model/output accuracy monitoring.
• Troubleshoot and resolve data, performance, and reporting issues across the MicroStrategy environment, including upgrades, migrations, and platform administration support.
• Create and maintain technical documentation, including data flow diagrams, schema documentation, and dashboard/report specifications.
• Mentor junior BI developers and analysts, sharing best practices in MicroStrategy development and the adoption of AI-assisted analytics techniques.
• Stay current on MicroStrategy platform updates (including MicroStrategy ONE / AI features) and emerging AI analytics trends, recommending enhancements that improve business impact.

What it takes to Join:

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field, or equivalent practical experience.
• Minimum of 5 years of hands-on MicroStrategy development experience, including schema design, dossier/dashboard development, and performance tuning; MicroStrategy Certification (Developer or Architect level) strongly preferred.
• Demonstrated experience applying AI or generative AI tools within a BI/analytics context (e.g., NLQ, AI-generated narratives, automated insight generation, or AI-assisted development).
• Strong SQL skills and hands-on experience with Snowflake or comparable cloud data warehouse platforms.
• Experience with dimensional data modeling (star/snowflake schemas), ETL/ELT processes, and enterprise data warehouse concepts.
• Retail industry experience required.
• Familiarity with AI governance, data privacy, and responsible AI practices as they apply to analytics and reporting.
• Strong communication and problem-solving skills, with the ability to manage multiple projects and work independently in a fast-paced environment.

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

( $114,849 - $150,000 )

• Competitive short-term incentive program
• Immediate 100% vested 401K contributions and employer match
• Dog friendly office environment
• $1,000 referral incentive program
• Generous associate discount of 30 - 50% off merchandise online and in-stores
• On-site Cafe
• On-site Gym with Fitness Classes
• Weekly Car Wash Service and more!

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.

Equal Opportunity Employer

This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.