DRAG
Scyn Tech Scyn Tech

Quick access to essential system features, including the dashboard for an overview of operations, network settings for managing connectivity, system logs for tracking activities.

Get In Touch

img

789 Inner Lane, Holy park, California, USA

Power BI Analyst

Power BI Analyst

Job Title: Power BI Analyst
Job Location: Newport
Job Duration: 9+ months
Job Type: Contract
Core Responsibilities:
  • Data Preparation: Clean, transform, and shape raw datasets using Power Query and SQL.
  • Data Modeling: Build stable relational data models and write custom DAX (Data Analysis Expressions) formulas for metrics, reporting, and analysis.
  • Visualization: Create dynamic, multi-page dashboards and scorecards for stakeholders.
  • Collaboration: Translate business needs into key performance indicators (KPIs) and technical report specs.
  • Deliver enterprise-grade solutions leveraging Microsoft Power Platform (Power Apps, Power Automate, Power BI, and Power Pages), aligning technology capabilities with business strategy and operational priorities.
    Core Technical Skills
  • Power BI proficiency: Ability to use Power BI Desktop and Service to clean, transform, and model data.
  • DAX (Data Analysis Expressions): Master this formula language to build custom calculated columns, measures, totals, and complex filters.
  • Power Query & ETL: Use Power Query to extract, transform, and clean raw data from multiple sources before loading it into your model.
  • Data Modeling: Design relational schemas, connect data sources, and configure star schemas with proper fact and dimension tables.
  • SQL & Excel: Write database queries in SQL and leverage Excel for preliminary data manipulation and fast ad hoc analysis.