Associate BI Developer

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 talented individuals to fulfill the Associate BI Developer 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.  Lids is predominantly using Microsoft Azure technologies with an Enterprise Data Warehouse architecture but looking to transition to Microsoft Fabric.

Principle Duties and Responsibilities

• Provide reliable source of ownership for our Business Intelligence and Reporting systems.
• Technical, strategic, tactical, operational responsibilities associated with the following BI and BI-related functional areas:
  • Data preparation (sourcing, acquisition, integration)
  • Data warehousing
  • Reporting, analytics, data exploration
  • Information delivery (portals, mobile)
• Developing and maintaining Azure Data Factory ETL packages for the importing and organization of the BI data.
• Ensuring the accuracy of data.
• Identifying data sources, constructing data decomposition diagrams, providing data flow diagrams, and documenting the processes.
• Designing and developing Business Intelligence and Reporting system effectively.
• Help to identify and connect additional data sources (i.e. business critical database systems, outside data sources, etc.) to the Data Warehouse / Business Intelligence system environment.
• Help to identify and add additional data fields from existing data sources into the Data Warehouse / Business Intelligence system environment.
• Translate business requirements into data models, develop/schedule ETLs, build data cubes, and validate results.
• Support already implemented BI solutions by: monitoring and tuning queries and data loads, addressing end user questions concerning data integrity, monitoring system performance and communicating functional/technical issues.
• Provide On-Call support when issues arise off hours.
• Participate in change control activities
• Create and maintain documents such as operational information, installation procedures, troubleshooting techniques, and knowledge-base information.
• Expand technical knowledge of the systems and tools utilized by the Lids IT.
• Support and adhere to all company policies, procedures, and guidelines.
• Manage the goals and objectives established with the supervisor.
• Communicate with employees at all levels of the company.
• Other duties as assigned.

Job Required Knowledge, Skills and Education

• Bachelor’s Level Degree in Computer Science, Engineering, MIS, or equivalent degree
• 1 to 3 years of business experience in moderate to large-sized corporate environments.
• 1 to 3 years of experience with Microsoft SQL Server 2012 or higher.
• Database system knowledge, database theory, database security, database design, capacity planning, performance analysis, and change management.
• Proven track record in the following areas:
  • Azure SQL /Microsoft SQL Server
  • Transact SQL
  • Power BI /Tableau
  • Entity Relationship Diagram development
• Presents initiative and a positive attitude.

Preferred Job Knowledge, Skills and Education

• Programing experience in Python or .NET, SSRS, or SSIS is a plus
• 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.
• Expertise in data modeling, both logical and physical.
• Experience in and understanding of a wide variety of analytical processes (governance, measurement, etc.).
• Knowledge of database tuning, capacity management, and resource forecasting.
• Background with Azure/MSFT related data tools
  • Azure Data Factory
  • Intermediate to complex stored procedures and triggers
  • Analysis Services (SSAS) – Tabular Modeling
    • DAX
  • Entity Relationship Diagram development
  • Managed Data Lake / Warehouse
  • Microsoft Dynamics 365
  • Microsoft Fabric
  • Familiarity with ML/AI tools
• Experience with Azure DevOps documenting and progressing ticket/bugs through to the sprint release.

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.
• Must be willing to provide on call support when required.

Physical/ Travel Requirements

• In order to perform the essential functions of this job, an employee must be able to meet the following physical demands: While performing the duties of this job, the employee is frequently required to sit; talk; or hear. The employee is occasionally required to stand; walk; use hands to finger; handle; or feel; reach with hands and arms; and stoop; kneel; or crouch. The employee must occasionally lift and/or move up to 50 pounds. Specific vision abilities required by this job include close vision, distance vision and depth perception
• This position requires less than 20% travel

Reports to:

• Director of Enterprise Data Solutions

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or disability.