Data Analyst (Power BI & Data Modeling)

J
JobgetherFinancial services
Fully remote position for candidates based in the United States.Full-Time
Salary not disclosed
Apply NowOpens the employer's application page

Job Details

Required Skills
PostgreSQLPythonSQLMicrosoft Power BI

Requirements

  • Bachelor's degree or international equivalent is required.
  • Demonstrated experience designing and maintaining Power BI reports and dashboards.
  • Practical knowledge of DAX for creating and maintaining measures and calculations.
  • Practical knowledge of Power Query (M) for transforming and preparing data for reporting.
  • Experience administering Power BI, including refresh schedules, gateways, row-level security, workspaces, and publishing workflows.
  • Experience designing dimensional and star-schema data models, including fact and dimension tables, relationships, granularity, and semantic models.
  • Strong SQL skills, including writing and optimizing queries with joins, aggregations, and window functions against relational databases.
  • Experience validating data, reconciling reported figures against source systems, and investigating data-quality issues.
  • Ability to define consistent metrics and maintain documentation such as data dictionaries and report catalogs.
  • Ability to translate unclear business questions into measurable KPIs and actionable insights.
  • Communication and presentation skills for explaining data and analytical findings to non-technical audiences.
  • Preferred: experience in finance or financial services, including revenue, cost, billing, AML, or compliance data.
  • Preferred: familiarity with Azure Databricks and Spark SQL; Python for data analysis; Git and version control; or large-scale or regulated datasets.

Responsibilities

  • Build, publish, and maintain Power BI dashboards and reports for business, operational, and leadership stakeholders.
  • Develop self-service reporting solutions that make reliable data and key performance indicators accessible.
  • Manage Power BI workspaces, publishing processes, refresh schedules, data gateways, and row-level security.
  • Design and maintain dimensional and semantic data models using star-schema architecture, including fact and dimension tables.
  • Create and maintain DAX measures and Power Query (M) transformations, documenting calculations and business definitions.
  • Work with Azure Databricks, SQL, and PostgreSQL sources to build clean, reusable datasets.
  • Reconcile reported figures against source systems and investigate discrepancies and data-quality issues.
  • Maintain a data dictionary and report catalog, and establish consistent business metric definitions.
  • Translate business questions into metrics and KPIs, produce ad hoc analysis, and present findings to non-technical stakeholders.
  • Support month-end and other periodic reporting cycles.
View Full Description & ApplyYou'll be redirected to the employer's site
View details
Apply Now