Remote Power Query Jobs in Columbus, OH (NOW HIRING)

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 experience working with BI tools (MicroStrategy/Strategy), analytics platforms, data warehouses, or cloud-based analytics environments.
• 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.