Description

You will transform complex data from multiple sources into actionable business insights and automated analysis.

Responsibilities

• Gather, structure, and analyze data from complex sources to provide business insights.
• Profile data and formulate data flows, business logic, and corresponding measures.
• Reconcile data across various systems and sources to ensure accuracy.
• Collaborate with data architects and engineers to support data development and automation.
• Present analysis results and strategic recommendations to management and reporting teams.

Required Skills

• 5+ years of experience in business intelligence and data analysis.
• Expert-level proficiency with SQL Server and database management.
• Extensive experience with SQL Server Analysis Services (SSAS), including Tabular Models, DAX, MDX, Power Query, and M language.
• Strong understanding of normalized and star-schema (dimensional) physical and logical modeling.
• Advanced Power BI skills and proficiency in Excel Pivot tables and Power Pivot.
• Ability to develop Power Apps to augment data ingestion to SSAS Cubes.
• C# and .NET development skills to maintain SSAS metadata and processing plans.
• Experience developing SSIS packages to automate processing of SSAS Cubes.

Preferred Skills

• Experience with C# and .NET development for SSAS metadata maintenance.
• Proficiency in file access methods within SQL Server.

Key Skills

Education

Any gradudate