BI Architect

Date: May 12, 2025

Location:

Indianapolis, IN, US, 46278

Store # - Mall Name: Corporate Office

About Our Company

Lids Sports Group, operating within Lids Holdings, Inc., is the largest licensed sports retailer in North America, selling fan and fashion-oriented headwear and apparel across North America and Europe. Operating out of Indianapolis, IN, Lids retail stores and affiliated concepts offer officially licensed headwear from collegiate teams and major professional sports teams, as well as branded headwear and other specialty fashion categories in the latest styles and trends in over 1,200 locations and counting. Lids is currently in growth mode with the goal to open a significant number of stores, both domestically and internationally, as well as with the goal to help grow Lids to be the largest brick-and-mortar licensed sports retailer globally.

General Position Summary

Lids is striving to become a data driven company and requires a talented individual to fulfill the BI Architect role. The role will support BI initiatives across different business areas by ensuring information is delivered in a timely and accurate manner that is easily understood by all end users. As a BI Architect, you’ll be expected to:

· Provide solutions that address technical and functional problems
· Size and setup cloud resources
· Hands on development
· Guide and influence other on best practices
· Perform code reviews
· Optimize code for performance and reliability
· Troubleshoot technical/functional issues.
· Setup CI/CD processes to streamline delivery processes

Lids is predominantly using Microsoft Azure technologies with an Enterprise Data Warehouse architecture but looking to enable a Data Lake and Fabric for future growth.

Principle Duties and Responsibilities

Provide ownership of Business Intelligence and Reporting systems.
Technical, strategic, tactical, and operational responsibilities across BI-related areas:
Data preparation (sourcing, acquisition, integration), data warehousing, reporting, analytics, data exploration, and information delivery (portals, mobile).
Develop and maintain Azure Data Factory ETL packages to import and organize BI data.
Ensure data accuracy.
Identify data sources, build decomposition and flow diagrams, and document processes.
Design and develop Business Intelligence and Reporting systems.
Identify and connect additional data sources (e.g., business-critical systems, external sources) and add new fields from existing sources into the Data Warehouse/BI environment.
Translate business requirements into data models, develop and schedule ETLs, build data cubes, and validate results.
Support implemented BI solutions by monitoring and tuning queries and data loads, resolving data integrity issues, monitoring performance, and addressing technical concerns.
Provide on-call support for off-hours issues.
Offer expert-level guidance and perform code reviews to ensure quality and adherence to standards.
Size and configure Azure resources.
Participate in change control activities.
Create and maintain documentation for operations, installations, troubleshooting, and knowledge sharing.
Expand technical knowledge of Lids IT systems and tools.
Support and follow all company policies, procedures, and guidelines.
Manage goals and objectives established with the supervisor.
Communicate with employees at all levels of the company.
Other duties as assigned.

Additional Principal Duties and Responsibilities

In Order to be Successful in this Role

Desired prior work environment experience (fast paced), proficiency in processes, positive mindset, great work ethic, excellent communicator, proficiency in Excel.

Job Required Knowledge & Skills

Bachelor’s degree in Computer Science, Engineering, MIS, or equivalent.
10+ years of business experience in moderate to large-sized corporate environments.
7+ years of experience with Microsoft SQL Server 2012 or higher.
5+ years with Analysis Services (DAX) programming.
5+ years with Azure resource setup.
Must have prior experience designing and setting up an enterprise data warehouse.
Extensive database system knowledge, theory, security, design, capacity planning, performance analysis, and change management.

Proven track record in the following:

Azure Data Factory
Azure SQL / Microsoft SQL Server
Transact SQL
Intermediate to complex stored procedures and triggers
Analysis Services (SSAS) – Tabular Modeling
DAX
Power BI
Entity Relationship Diagram development
Managed Data Lake / Warehouse
Microsoft Dynamics 365
Programming experience in Python or .NET, SSRS, or SSIS is a plus
Understanding of Azure Security
Fabric and OneLake
Extensive expertise in data modeling (logical and physical)
3NF, Slowly Changing Dimensions, Kimball data modeling techniques
Analytical process knowledge (governance, measurement, etc.)
Database tuning, capacity management, and resource forecasting
Experience with Azure DevOps documenting and progressing tickets/bugs through sprint release
Presents initiative and a positive attitude.

Preferred Job Required Knowledge & Skills

Strong working knowledge of the retail and distribution industry and its functions including the following areas: Finance, Retail Sales, Manufacturing, Purchase Order Entry, Supply Chain Management, Inventory Management, and Merchandising.
Experience with agile software development.
Experience with Dataverse

Education

Reports To

Director of Enterprise Data Solutions

EEO Statement:
Hat World, Inc., Lids Holdings, Inc., dba Lids and subsidiaries is an Equal Opportunity Employer and is committed to complying with all federal, state, and local EEO laws. Hat World, Inc., prohibits discrimination against employees and applicants for employment based on the individual's race or color, religion or creed, national origin, alienage or citizenship status, marital status, sex, pregnancy status, age, military status, disability, or any other protected characteristic or class protected by law. Hat World, Inc. provides reasonable accommodation for disabilities in accordance with applicable laws.

Notice to Applicants:
In connection with your application, we collect information that identifies, reasonably relates to or describes you (“Personal Information”). The categories of Personal Information that we collect include your name, government issued identification number(s), email address, mailing address, other contact information, emergency contact information, employment history, educational history, criminal record, and demographic information. We collect and use those categories of Personal Information about you for human resources and other business management purposes, including identifying and evaluating you as a candidate for potential or future employment or future contract positions, recordkeeping in relation to recruiting and hiring, conducting criminal background checks as permitted by law, conducting analytics, and ensuring compliance with applicable legal requirements and Company policies.

Need accessibility assistance to apply?
Applicants who require accessibility assistance to submit an employment application, please email us at onboardingsupport@lids.com. A member of our Talent team will respond as soon as reasonably possible. This email address and is only for individuals seeking accommodation when applying for a career at Lids.

Req ID: 22999

Location: Corporate Office