Developer, BI

Date:  Nov 21, 2021

Indianapolis, IN, US, 46278

Store # - Mall Name:  Corporate Office

General Description

Principle Duties and Responsibilities

  1. Provide reliable source of ownership for our Business Intelligence and Reporting systems.
  2. 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)
  3. Developing and maintaining Azure Data Factory ETL packages for the importing and organization of the BI data.
  4. Ensuring the accuracy of data.
  5. Work with Infrastructure Architect(s) to perform capacity planning and troubleshooting.
  6. Identifying data sources, constructing data decomposition diagrams, providing data flow diagrams and documenting the processes.
  7. Configure Business Intelligence and Reporting system effectively by implementing security filters and roles at the corporate, department and individual levels of the organization.
  8. 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.
  9. Help to identify and add additional data fields from existing data sources into the Data Warehouse / Business Intelligence system environment.

Additional Principle Duties and Responsibilities

  1. Work with Business Analysts and other department leaders to translate business requirements into data models, develop / schedule ETLs, build data cubes and filtering, and validate results.
  2. Develop analytical databases and systems that allow for the creation of BI reporting in key departments.
  3. Support already implemented Business Intelligence solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring system performance and communicating functional and technical issues.
  4. Participating in change control activities.
  5. Creating and maintaining documentation such as operational information, installation procedures, troubleshooting techniques, and knowledge-base information.
  6.  Expanding technical knowledge of the systems and tools utilized by the Lids IT
  7. Supporting and adhering to all company policies, procedures, and guidelines.
  8. Managing the goals and objectives established with the supervisor.
  9. Communicating with employees at all levels of the company.
  10. Other duties as assigned.

Job Required Knowledge & Skills

  1. Bachelor’s degree in Information Technology, Computer Science, or equivalent.
  2. Five or more years of business experience in moderate to large-sized corporate environments.
  3. Five or more years of experience with Microsoft SQL Server 2012 or higher.
  4. 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.
  5. Extensive database system knowledge, database theory, database security, database design, capacity planning, performance analysis, and change management.
  6. Proven track record in the following areas:
    • Azure SQL /Microsoft SQL Server
    • Microsoft Dynamics 365
    • Azure Data Factory
    • Transact SQL
    • Intermediate to complex stored procedures and triggers
    • SQL Server Integration Services (SSIS)
    • SQL Reporting Services (SSRS)
    • Analysis Services (SSAS) – Tabular Modeling
    • Entity Relationship Diagram development
    • Managed Data Lake / Warehouse
  7. Extensive expertise in data modeling, both logical and physical.
  8. Experience in and understanding of a wide variety of analytical processes (governance, measurement, etc.).
  9. Experience with agile software development.
  10. Knowledge of database tuning, capacity management, and resource forecasting.
  11. Experience with Azure DevOps documenting and progressing ticket/bugs through to the sprint release.
  12. Presents initiative and a positive attitude.


Bachelor's Level Degree in Computer Science or Other

Reports To

Manager, BI

Nearest Major Market: Indianapolis