BI - Data Modeler

Position Summary

Lids is striving to become a data driven company and requires talented individuals to fulfill the Data Modeler role. We are seeking a skilled Data Modeler with a strong background in the Retail Industry and experience with Dynamics 365 Finance & Operations (F&O). The ideal candidate will model data, champion data governance, elicit functional requirements, define terms, and capture business logic. This role requires a solid understanding of data engineering and report development using the latest Microsoft stack of cloud analytical tools and best practices in modern data warehousing.

Principle Duties and Responsibilities

• Develop, maintain, and optimize data models to support BI initiatives across various business processes such as finance, supply chain, inventory management, sales, and customer insights.
• Champion data governance, ensuring data quality, integrity, and compliance across all data sources and processes.
• Collaborate with business stakeholders to elicit and document functional requirements, ensuring alignment with business goals and strategies.
• Define business terms and capture business logic for accurate data representation, facilitating clear communication and understanding across the organization.
• Work closely with the BI team to develop and deliver insightful reports and dashboards using the latest Microsoft cloud analytical tools (e.g., Analysis Services, Power BI, Azure Data Factory, Azure Synapse Analytics).
• Apply best practices in data modeling, including star schema design, normalization, and the use of modern data modeling tools such as ER / Studio or ERwin.
• Support data integration and transformation processes, ensuring efficient and accurate data flow from various sources into the data warehouse.
• Define and document technical requirements to support data engineering efforts.
• Address data quality issues commonly found in retail environments, such as duplicate records, inconsistent data, and missing values, by implementing robust data validation and cleansing processes.
• Validate / Test data solutions put in place to ensure they adhere to intended design.

Additional Principal Duties and Responsibilities

Job Required Knowledge & Skills

Preferred Job Required Knowledge & Skills

o Azure Data Factory

o Azure SQL / Microsoft SQL Server

o Transact SQL

o Intermediate to complex stored procedures and triggers

o Analysis Services (SSAS) – Tabular Modeling

§ DAX

o Azure Synapse Analytics

o Power BI

o Microsoft Dynamics 365

Education