Senior MicroStrategy & AI Analytics Developer

PACSUN; Anaheim (CA); On-site; USD 115,000 - 150,000; Full time

Benefits offered by this job

Medical, dental, and vision benefits

401K with employer match

Discount on merchandise

Dog friendly office

Referral incentive

On-site cafe

On-site gym

Job summary

PACSUN in Los Angeles, a fashion and lifestyle retailer, seeks a Senior MicroStrategy & AI Analytics Developer. This hands-on role designs, builds, and optimizes Pacsun's enterprise MicroStrategy environment and extends it with AI-powered analytics capabilities across merchandising, retail operations, and customer experience decisions.

You will collaborate with the Director, System Integration and AI Analytics to embed machine learning, predictive analytics, and GenAI features into the BI

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, or related field.
• Minimum of 5 years hands-on MicroStrategy development experience.
• Experience applying AI or generative AI tools within BI/analytics context.
• Strong SQL skills with Snowflake or comparable cloud data warehouse.
• Experience with dimensional data modeling (star/snowflake) and ETL/ELT.
• Retail industry experience.
• Familiarity with AI governance, data privacy, and responsible AI practices.

Responsibilities

• Design, develop, and maintain MicroStrategy schema objects, reports, dashboards supporting merchandising, retail operations, and executive reporting.
• Build and optimize the MicroStrategy semantic layer, cubes, and metadata architecture for scalable analytics.
• Integrate AI and generative AI capabilities into the BI platform (NLQ, AI insights, narratives, anomaly detection).
• Collaborate with data science to prepare data models and semantic layers for AI/ML use cases.
• Write and optimize SQL against Snowflake and manage ETL/ELT processes feeding BI/AI workloads.
• Mentor junior BI developers and analysts; stay current on MicroStrategy and AI trends.

Skills

MicroStrategy development

SQL

Snowflake

AI analytics

Data modeling

Communications

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics

Tools

MicroStrategy ONE

Copilot / ChatGPT

Snowflake

Job 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 )

Pac Perks

• Comprehensive medical, dental, and vision benefits
• 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
• Ample parking
• 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.