Share this Job


You must apply through our internal portal: 
click here

Sr. Business Intelligence Analyst (Open to Remote)

DATE:  Jun 12, 2022
CITY:  Columbus
BRAND:  Designer Brands
REQ #:  133860
LOCATION NAME:  Home Office, Columbus - East 5th
DEPARTMENT:  Information Technology

The Sr. Business Intelligence Analyst position requires a senior level individual with proven capacity to lead the design and development of enterprise data warehouse business intelligence applications. Individual will mentor and provide direction to other development team members where appropriate.

The candidate must be a detail-oriented individual, with strong organizational skills, who has the flexibility to succeed in a fast-paced, remote, and dynamic atmosphere. Candidate must possess extensive experience with design and development in the areas of Business and have a proven track record with Enterprise Data Warehousing concepts, including schema designs and self-service analytics & reporting.


This is a hands-on role, responsible for the development to deployment of solutions using our enterprise analytic tool(s). The candidate should have a strong customer focus and be able to communicate and navigate many different personalities and opinions. Basic domain knowledge of the retail industry is a must for this role. We are open to remote candidates based in the continental United States for this opportunity.


Reports To: Manager, Solutions Delivery & Design


Essential Duties and Responsibilities:

  • Creates a robust, sustainable business intelligence solutions that supports requirements and provides expansion capabilities
  • Work with the business on requirements investigation and development of functional and technical reporting requirements documentation
  • Must be able to build schema, cubes, metrics, prompts, filters, subscriptions, custom groupings, consolidations, advanced reporting, and documents, including visualizations with dashboards and dossiers in MicroStrategy
  • Participate in the on-call support rotation
  • Estimate phases of the Software Development Lifecycle as they relate to reporting and analytics
  • Ensures that all reports are developed and delivered timely and accurately
  • Maintains existing and new users’ permissions for all reports
  • Work both internally and with the business to ensure quality is met on delivery of reporting.
  • Support of existing and prior developed reports across the various business units
  • Maintain reporting architecture and knowledge documentation
  • Provide training to other DSW associates to foster stronger cross-departmental relations
  • Create Platform Analytics reporting to show opportunities for environment enhancements
  • Mentor or support team members with technical expertise and knowledge


Required Skills:

  • Proven extensive hands-on experience with at least one of major BI platforms (MicroStrategy)
  • Excellent written and verbal communication skills
  • Extensive SQL knowledge and ability to perform SQL tuning a must
  • Prior experience or working knowledge of an RDBMS
  • Knowledge of all phases of project life cycle from inception to production deployment.
  • High level knowledge in relational and dimensional modeling (conceptual, logical, and physical data models)
  • Multi-task, manage time and priorities and be self-directed while maintaining high degree of organization



SETTING GOALS – Creates and follow effective plans. Anticipates risks, creates contingency plans. Aligns plans with goals. Allocates adequate resources. Accepts and supports change. Willing to take risks and suggests new ideas, approaches. Takes initiative. Seeks out learning activities.


WORKING WITH OTHERS – Clearly articulates own, other’s goals. Promotes a team atmosphere by demonstrating humility and respect. Builds effective relationships, relates well to others. Delivers and responds to feedback in a constructive manner. Considers multiple perspectives. Handles conflict, pressure, uncertainty and adapts independently. Meets commitments. Dedicated to working with business partners on their expectations.


GETTING RESULTS – Personally accountable for work performance targets and achieving results. Prioritizes well. Anticipates and handles obstacles effectively. Makes good, timely decisions. Can simply and process complex problems. Understands underlying issues and addresses root causes. Meets deadlines, works until finished.




  • 5+ years of BI tool (MicroStrategy) experience
  • 5+ years of report requirements development & estimation



  • Experience in Tableau a plus
  • Data governance, quality, mapping, profiling, cleansing and/or standardization
  • Experience with a batch monitor scheduling tool such as CA Workload Automation dSeries or Control M a plus
  • High level knowledge of supply chain, order management, transactional sources, financial acumen, inventory and merchandising, and ERP a plus
  • Experience in MicroStrategy Workstation a plus



  • Bachelor’s degree in Computer Science, MIS, or Business Administration


You must apply through our internal portal: 
click here

Why Choose A Career with Designer Brands?

Empowering associates and building strong teams poised to disrupt the retail and footwear landscape through positive change is at the core of who we are at Designer Brands.

  • Invested in helping our associates learn, develop, achieve and grow into strong leaders
  • Shared commitment to creating a culture fueled by engagement, excitement, optimism and fun
  • Dedicated to giving back and community involvement 

About Designer Brands:

Designer Brands Inc. is one of North America’s largest designers, producers and retailers of footwear and accessories. 

  • Designer Brands Inc. operates a portfolio of retail concepts in nearly 1,000 locations under the DSW Designer Shoe Warehouse, The Shoe Company, and Shoe Warehouse brands and operates leased locations in the U.S through its Affiliated Business Group. 
  • Designer Brands designs and produces footwear and accessories through Camuto Group, a leading manufacturer selling in more than 5,400 doors worldwide. 












Nearest Major Market: Columbus

Job Segment: Business Intelligence, Computer Science, Database, SQL, Data Warehouse, Technology