Data Analyst
Liam Tran
HR Administrator
Efterfrågade kompetenser
Om tjänsten
Role Summary
Our client is seeking an experienced Data Analyst for a consulting assignment in a retail environment. The role spans enterprise reporting, analytics engineering, and data engineering, with a strong focus on Microsoft Fabric and Power BI. You will work across business and technical teams in a platform-building environment where analytical standards, governance practices, and engineering processes continue to evolve.
The assignment requires a strong understanding of retail operations and data, including sales, point-of-sale transactions, product and store hierarchies, markets, franchisee reporting, and customer-related information. You will translate business terminology and reporting requirements into dependable analytical measures, reusable semantic models, and practical reporting solutions.
Key Responsibilities
- Design, develop, modernize, and optimize enterprise reporting and business intelligence solutions using Microsoft Fabric and Power BI.
- Translate retail requirements and terminology into consistent KPIs, analytical measures, semantic models, reports, and reusable data products.
- Analyze retail transactions, sales trends, product performance, customer behavior, and market basket patterns.
- Support reporting for retail KPIs such as net and gross sales, transaction counts, average transaction value, basket size, comparable sales, and product performance.
- Develop and maintain certified semantic models for governed self-service analytics.
- Apply dimensional modeling techniques, including star schemas, fact and dimension tables, relationships, and appropriate cardinality.
- Create advanced DAX measures and business calculations using time intelligence, calculation groups, row context, and advanced filter context while optimizing model and report performance.
- Use Power Query and the M language to transform and prepare data for reporting and analysis.
- Build data engineering and transformation solutions using Microsoft Fabric notebooks, Dataflows Gen2, Data Pipelines, Warehouse, Lakehouse, Python, PySpark, and SQL.
- Apply Bronze, Silver, and Gold data-layer patterns within data lake and Delta Lake architectures.
- Validate data, troubleshoot analytical issues, optimize queries and reports, and ensure that analytical outputs are reliable and reusable.
- Implement appropriate access controls, including object-level security and row-level security in Microsoft Fabric and Power BI.
- Support version-controlled analytical assets, Git integration, CI/CD practices, and deployment pipelines.
- Evaluate and apply Import, DirectQuery, and Direct Lake models based on their architectural and performance characteristics.
- Collaborate across agile business and technical teams, document solutions, and share knowledge with relevant stakeholders.
Technical Stack & Requirements
- Business intelligence: Extensive hands-on experience with Power BI, enterprise report design, workspace management, semantic modeling, and governed self-service analytics.
- Data modeling: Strong command of dimensional modeling, star schemas, relationships, cardinality, fact and dimension tables, reusable certified semantic models, and semantic-model optimization.
- Calculations and transformation: Expert-level DAX, including performance optimization, calculation groups, time intelligence, row context, filter context, and complex business measures; experience with Power Query and M is also required.
- Microsoft Fabric: Practical experience with notebooks, Dataflows Gen2, Data Pipelines, Warehouse, and Lakehouse. Strong combined experience with Power BI and Azure data platforms may be considered where there is a demonstrated ability to become productive in Fabric quickly.
- Data engineering: Strong SQL skills for validation, troubleshooting, transformation, and analytical querying, together with practical Python and PySpark experience for transformation and distributed data processing.
- Cloud data platforms: Experience with Azure Data Factory, Azure Databricks, Azure Data Lake, or comparable modern data platforms.
- Lakehouse architecture: Experience applying Bronze, Silver, and Gold layers and working with data lakes and Delta Lake.
- Engineering practices: Familiarity with Git, version-controlled analytical assets, CI/CD, deployment pipelines, data contracts, and maintainable, testable, reusable data products.
- Security: Experience implementing access control, object-level security, and row-level security within Microsoft Fabric and Power BI.
Qualifications & Experience
A minimum of six years of relevant experience in business intelligence, analytics engineering, or data engineering is required. Candidates must have substantial experience designing reliable enterprise analytical solutions, validating data, improving report performance, modernizing reporting environments, and migrating enterprise BI solutions.
Strong retail knowledge is mandatory, including familiarity with retail operations, reporting requirements, sales and POS transactions, product and store hierarchies, stores, markets, franchisee reporting, customer data, and consistent KPI definitions across business entities. The successful consultant must be able to convert business requirements into technically reliable and practically useful analytical solutions.
Experience with customer loyalty, retention, segmentation, and customer behavior analytics is advantageous. Relevant Microsoft certifications, such as PL-300 or DP-600, are also beneficial. Experience developing Python and PySpark solutions specifically in Microsoft Fabric or Azure Databricks is preferred. Excellent written and spoken English is required.
Work Logistics & Location
This is a consulting assignment with a hybrid working arrangement. On-site attendance is required three days per week; the specific city and assignment duration have not been provided.