Sr. Strategy (Microstrategy) Developer - REMOTE

designerbrands; Columbus (OH); Hybrid; USD 110,000 - 150,000; Full time

Benefits offered by this job

Hybrid/Remote work

Education assistance

Employee discounts

Job summary

Designer Brands is seeking a Senior Business Intelligence Developer to transform complex data into trusted insights that guide decisions across the organization. You will design, build, and support enterprise analytics in our cloud data warehouse environment and collaborate with business and technology teams to deliver scalable reporting solutions.

The role prioritizes data architecture, BI best practices, and helping teams leverage data effectively.

Qualifications

• 7+ years of hands-on MicroStrategy development including schema, metadata, and production support.
• Experience translating business requirements into scalable BI solutions.
• Strong SQL, data modeling, and data warehousing knowledge.
• Experience with cloud analytics ecosystems, preferably GCP.

Responsibilities

• Lead enterprise BI solutions design, development, and delivery.
• Partner with Data Architecture to ensure semantic layer alignment with standards.
• Provide guidance and training to enable self-service analytics.

Skills

MicroStrategy

SQL

Data warehousing

Data modeling

BI reporting

Stakeholder comms

Looker/Power BI

Education

Bachelor's degree in Computer Science or related

Tools

Looker

Power BI

GCP/BigQuery

Job description

About Designer Brands

At Designer Brands, we are the proud parent company of DSW Designer Shoe Warehouse, The Shoe Company, and Rubino, operating nearly 675 stores across North America and a billion-dollar digital commerce business. We lead the footwear industry with a diverse portfolio of iconic brands, including Topo Athletic, Keds, Vince Camuto, Kelly & Katie, Jessica Simpson, Lucky Brand, Mix No. 6, Crown Vintage, and others. With expertise in design, production, and sourcing, we create on-trend footwear and accessories, delivered through a robust omni-channel infrastructure and national wholesale distribution. At Designer Brands, we are committed to fostering a culture of collaboration, innovation, and inclusivity, where each employee’s unique perspective contributes to our success. Anchored by our core values of “We Love What We Do,” “We Own What We Do,” “We Do What’s Right,” and “We Belong,” we continuously drive forward together, building a future where everyone can put their best foot forward.

The Opportunity

At Designer Brands, data helps power great decisions, better experiences, and meaningful business outcomes. As a Senior Business Intelligence Developer, you'll play a key role in transforming complex data into trusted insights that help teams across the organization make informed decisions.

This is a hands‑on technical role where you'll design, build, and support enterprise analytics solutions within our cloud data warehouse environment. You'll partner with both business and technology teams to understand challenges, uncover opportunities, and deliver scalable reporting and analytics solutions that make an impact.

We're looking for someone who enjoys solving complex problems, collaborating with stakeholders, and turning data into actionable insights. If you're passionate about data architecture, business intelligence, and helping others leverage data more effectively, this could be a great opportunity to grow your career while influencing decisions across a dynamic retail organization.

This position is open to remote candidates within the continental United States.

What You’ll Be Doing

Lead Enterprise BI Solutions

• Design, develop, and maintain Strategy (formerly MicroStrategy) metadata objects, including schemas, cubes, attributes, hierarchies, metrics, prompts, filters, consolidations, and custom groups.
• Architect and deliver certified enterprise reporting, dashboard, and decision support solutions that provide accurate and reliable data.
• Partner with the Data Architecture team to ensure semantic layer and metadata solutions align with enterprise standards and best practices.

Support Data-Driven Decision Making

• Collaborate with business stakeholders to understand reporting and analytics needs and translate them into scalable solutions.
• Provide guidance, training, and best practices that help teams leverage self‑service analytics tools effectively.
• Help promote a data‑driven culture by ensuring users have access to trusted and meaningful insights.

Solve Complex Technical Challenges

• Serve as the primary technical owner for user inquiries, production support incidents, and enhancement requests.
• Triage, prioritize, estimate, and drive work through successful resolution while balancing competing business priorities.
• Perform root cause analysis and troubleshoot data, performance, and application issues across reporting, metadata, and platform components.

Ensure Stability and Continuous Improvement

• Participate in production deployments, object migrations, and change management activities.
• Contribute to an after‑hours on‑call rotation.
• Create and maintain technical documentation, metadata architecture artifacts, schema designs, and knowledge management resources.

What You’ll Need

Required Experience & Technical Skills

• 7+ years of hands‑on Strategy (formerly MicroStrategy) development experience, including schema development, metadata administration, semantic layer design, enterprise reporting, and production support.
• Designing and maintaining Strategy schemas. Defining facts, attributes, hierarchies, and relationships.
• Experience translating business requirements into scalable BI solutions using semantic layers, metrics, attributes, hierarchies, and reporting structures within enterprise BI platforms such as Strategy (formerly MicroStrategy).
• Advanced SQL expertise, including complex query development, performance tuning, troubleshooting, and large dataset analysis within cloud data warehouse environments.
• Experience working with cloud‑based analytics ecosystems, preferably Google Cloud Platform (GCP).
• Experience working with relational database management systems (RDBMS) and cloud data warehouse platforms.
• Strong understanding of tables, joins, keys, relationships, views, and data structures that support reporting and analytics solutions.
• Strong knowledge of relational data modeling principles, including entity relationships, normalization, and conceptual, logical, and physical data models.
• Understanding of dimensional modeling and data warehousing concepts, including:
  • Fact and dimension tables
  • Star and snowflake schemas
  • Surrogate keys
  • Reporting and analytics design best practices
• Strong written and verbal communication skills with the ability to explain technical concepts and partner effectively with diverse stakeholders.

Education

• Bachelor's degree in Computer Science, MIS, CIS, Information Technology, Data Analytics, Software Engineering, or a related technical discipline.

Preferred Qualifications

• Experience working with SQL-based database technologies and development tools used for querying, troubleshooting, and data analysis.
• Knowledge of:
  • Data governance
  • Data quality
  • Data profiling
  • Data mapping
  • Master data management
  • Data standardization best practices
• Experience supporting data integration, batch processing, or enterprise job scheduling platforms such as CA Workload Automation (dSeries), Control‑M, or similar orchestration tools.
• Working knowledge of the Strategy platform ecosystem, including Workstation, Platform Analytics, and administration and monitoring capabilities.
• Understanding of retail business processes and metrics, including:
  • Merchandising
  • Inventory management
  • Sales reporting
  • Financial analytics
• Demonstrated curiosity and adoption of emerging technologies, including AI‑assisted development, analytics, and automation capabilities.
• Experience with additional data visualization tools such as Looker, Power BI, or similar platforms.

Perks and Benefits You’ll Enjoy!

• Your Sole Well-Being: Our benefits package is crafted with our associates in mind! We support you with benefits like free virtual health care, robust family/fertility benefits, 401(k) w/ match, and more. Explore our offerings at https://mymobilewalletcard.com/dbi.
• Stride with Flexibility: We offer hybrid and remote work opportunities, giving you the freedom to stay connected, productive, and inspired—wherever you do your best work.
• Stepping Up Your Career: Take advantage of training programs, professional development, and education assistance to advance your career with a company that celebrates bold ideas and fresh perspectives.
• We are Shoe-Obsessed: Because we know a great pair of shoes can change your day, you’ll enjoy 30% off at DSW & DSW.com, plus discounts across our family of brands.