Business Data Analyst

TekStaff's Client has a current vacancy for Business data analyst

Job Description

Typical Day in Role:

• Legacy Analysis & Documentation: Analyze existing legacy reports in SQL Server (stored procedures, complex queries) and Power BI (DAX, data models, dataflows) to thoroughly document current data transformations, business logic, and source-to-target mappings.
• Migration & Mapping: Map legacy data transformations to new data products on the Azure Databricks platform to ensure a seamless transition and migration.
• Process Optimization: Identify duplication of logic across reports and find opportunities to simplify and streamline overall reporting processes.
• Data Profiling & Quality: Perform data analysis using SQL and Excel to profile data, identify inconsistencies, and conduct root-cause analysis on data quality issues (including CRM/Salesforce data hygiene).
• Collabora...