Data Analyst

Data Analyst (SAP Data)

Hybrid

Location: Findley, OH or San Antonio, TX ( 3 days onsite)

Data Modeling & Analytics

• Design and maintain dimensional data models (star schema, fact and dimension tables)
• Develop advanced DAX measures, calculated tables, and KPIs
• Optimize Power BI data models for performance and scalability
• Create reusable semantic models and standardized reporting datasets
• Analyze trends and identify actionable business insights from data
• Write and optimize SQL Server queries to extract, join, and validate data
• Clean, transform, and structure data for reporting use
• Connect and load data into Power BI using appropriate connectors
• Build and maintain Power BI dashboards and underlying data models
• Provide input on the design and definition of underlying metrics

SAP Data Expertise

• Understand SAP data structures, tables, and relationships across ECC, BW, and S/4HANA environments
• Identify the appropriate SAP tables and fields needed to support reporting requirements
• Trace data lineage from SAP transactions through reporting solutions
• Validate business logic using SAP source data
• Collaborate with functional teams to understand data definitions and process impacts
• Build SAP queries and extracts (front end) to source relevant data