MicroStrategy Engineer

PacSun

Anaheim (CA)

On-site

USD 95,000 - 115,000

Full time

10 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Dog friendly office environment
On-site Cafe
On-site Gym
Immediate 401K employer match
Generous associate discount

Job summary

Pacsun is seeking a MicroStrategy Engineer to develop, enhance, and support Pacsun’s enterprise analytics using Strategy on Snowflake, reporting to the Manager, Business Analytics & Reporting. The role blends technology with retail context and applies AI to BI workflows.

You will build dashboards, maintain the semantic layer, implement retail logic, validate data with SQL, and collaborate across merchandising, finance, and IT to deliver actionable insights.

Qualifications

  • 3+ years hands-on Strategy development in an enterprise environment.
  • Strong SQL skills and data warehousing knowledge.
  • Retail analytics experience with sales, inventory, margin.
  • Experience with Snowflake and Strategy integration.
  • AI tools in BI context and generative AI experience.
  • Excellent analytical and communication skills.
  • Fashion/retail experience preferred.

Responsibilities

  • Develop and support enterprise reports, dashboards, dossiers, metrics, and analytics in Strategy.
  • Maintain Strategy metadata and semantic layer for consistency and performance.
  • Apply retail logic for sales, inventory, cost, margins, and sell-through.
  • Validate reporting with SQL and Snowflake; reconcile to source data.
  • Provide production support and performance tuning.
  • Assist upgrades, environment management and releases.
  • Incorporate AI features like NLP and AI-generated narratives in dashboards.
  • Partner with merchandising, planning, stores, finance, supply chain, and marketing.

Skills

Strategy development
SQL skills
Snowflake
AI in BI

Education

Bachelor's degree in CS or related

Tools

Strategy (MicroStrategy)

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 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.
  • 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)
  • 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.

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Manager, Business Analytics & Reporting
Manager, Business Analytics & Reporting

PacSun • Anaheim (CA)

On-site
USD 120,000 - 145,000
Dog friendly office
On-site Cafe
On-site Gym
+2
Director, Enterprise Data & Analytics
Director, Enterprise Data & Analytics

PacSun • Anaheim (CA)

On-site
USD 175,000 - 210,000
Dog friendly office environment
On-site Cafe
On-site Gym
+6
Sr. Manager - Search Technology & Analytics
Sr. Manager - Search Technology & Analytics

PacSun • Anaheim (CA)

On-site
USD 135,000 - 143,000
Competitive incentive program
401K with employer match
Dog-friendly office
+5
VP, Inventory Management
VP, Inventory Management

PacSun • Anaheim (CA)

Remote
USD 250,000 - 300,000
Remote work options
Onsite gym
Employee discounts
+1
Senior Manager, Search Tech & AI Analytics
Senior Manager, Search Tech & AI Analytics

PacSun • Anaheim (CA)

On-site
USD 135,000 - 143,000
Competitive incentive program
401K with employer match
Dog-friendly office
+5
Senior Buyer, Women's Non- Apparel, Graphics & Fleece
Senior Buyer, Women's Non- Apparel, Graphics & Fleece

PacSun • Anaheim (CA)

On-site
USD 115,000 - 135,000
Short-term incentive program
401K employer match
Dog-friendly office
+1
Sr. CRM Specialist
Sr. CRM Specialist

PacSun • Anaheim (CA)

On-site
USD 72,000 - 82,000
Generous 401K with employer match
Dog friendly office
$1,000 referral incentive program
+4
Senior Buyer, Women's Graphics & Fleece — Strategic Leader
Senior Buyer, Women's Graphics & Fleece — Strategic Leader

PacSun • Anaheim (CA)

On-site
USD 115,000 - 135,000
Short-term incentive program
401K employer match
Dog-friendly office
+1
Director, Real Estate
Director, Real Estate

PacSun • Anaheim (CA)

On-site
USD 180,000 - 230,000
Competitive incentive program
401K with company match
Dog-friendly office
+5
Store Manager — Fashion Retail Leader with Perks & Growth
Store Manager — Fashion Retail Leader with Perks & Growth

PacSun • King of Prussia (PA)

On-site
USD 65,000 - 90,000
30-50% associate discount
401K with employer match
Employee perks throughout the year