MicroStrategy Engineer

Pacsun Careers•Anaheim, CA

About The Position

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 the Snowflake retail data warehouse. Reporting to the Manager, Business Analytics & Reporting, the Engineer maintains and evolves the Strategy metadata and reporting environment, builds business reports and analytics, supports upgrades and production operations, and troubleshoots issues. The role requires understanding both the technology and the retail business context behind the data, while applying AI tools and capabilities to improve analytics and BI development. The Engineer partners with stakeholders across merchandising, planning, inventory, stores, eCommerce, finance, supply chain, and marketing, and collaborates with the Manager, data engineers, the Data Architect, other IT teams, and external partners. The role also supports cross-functional ERP and financial systems transformation initiatives as they relate to reporting. It operates in a professional office environment and routinely uses standard office equipment. Occasional evening or weekend work may be required during high-volume periods, and travel may be required.

Requirements

Bachelor’s degree in Computer Science, Information Systems, Analytics, Engineering, or a related field, or equivalent practical experience.
At least 3 years of hands-on Strategy (formerly MicroStrategy) development and engineering experience in an enterprise environment.
Strong working knowledge of Strategy metadata and architecture, including metrics, attributes, facts, schema objects, reports and dashboards, security, and troubleshooting.
Strong SQL skills and thorough understanding of relational databases, data warehousing, dimensional modeling, and analytical data structures.
Retail industry experience and 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 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, such as 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.
Ability to uphold integrity and confidentiality, build cross-functional partnerships, and contribute to a collaborative and accountable working culture.

Nice To Haves

Fashion, apparel, or specialty retail experience.
Experience with Strategy administration, upgrades, performance tuning, and environment migrations.
Strategy (MicroStrategy) Developer- or Architect-level certification.
Snowflake certification, such as SnowPro.
Exposure to Tableau, Power BI, or other analytics platforms.

Responsibilities

Design, develop, test, deploy, and support enterprise Strategy reports, dashboards, dossiers, metrics, and analytical applications from business requirements through testing and production support.
Maintain and enhance Strategy metadata, including attributes, facts, metrics, hierarchies, transformations, filters, prompts, schema objects, security, and reusable components.
Apply retail business logic for sales, inventory, cost, margin, gross margin, and sell-through, ensuring measures are calculated and presented correctly.
Use 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.
Provide production support, including root-cause analysis, defect resolution, performance tuning, monitoring, and user support.
Support Strategy upgrades, patches, migrations, environment management, regression testing, and release deployment using tools such as Workstation, Object Manager, Integrity Manager, and Command Manager.
Integrate AI features such as natural language query, AI-generated insights and narratives, and anomaly detection into dashboards; use GenAI tools to accelerate development, documentation, and testing; evaluate new AI tools and share effective practices with the team.
Partner with business stakeholders to clarify requirements and deliver usable, accurate analytics solutions.
Follow data governance, row-level security, access-control, and responsible AI practices, including accuracy checks on AI-generated output.
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.
Communicate clearly with technical and non-technical stakeholders, translate complex data and AI concepts into actionable business insights, and share AI and data knowledge with the BI and analytics team.
Support cross-functional initiatives, including ERP and financial systems transformation work, as they relate to reporting.