Data Analyst (Power BI & Data Modeling)

Jobgether

United States

Remote

USD 85,000 - 120,000

Full time

2 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Jobgether is assisting a partner company in finding a Data Analyst (Power BI & Data Modeling) based in the United States. The role is fully remote and focuses on turning complex data into trusted, actionable insights across business and operations teams.

You will own Power BI dashboards, data models, and KPI definitions, working with Azure Databricks, SQL, and PostgreSQL data sources to deliver reliable reporting. Collaboration with stakeholders ensures timely, accurate results.

Qualifications

  • Bachelor's degree or international equivalent is required.
  • Demonstrated experience designing and maintaining Power BI reports and dashboards.
  • Strong practical knowledge of DAX, Power Query (M), and Power BI administration.
  • Experience designing dimensional and star-schema data models for self-service reporting.
  • Strong SQL skills with joins, aggregations, and window functions.

Responsibilities

  • Power BI reporting and dashboard development for multiple stakeholders.
  • Develop self-service reporting solutions with accessible metrics and KPIs.
  • Manage Power BI workspaces, refresh schedules, gateways, and row-level security.
  • Design and maintain dimensional data models and semantic models.
  • Build clean datasets from Azure Databricks, SQL, and PostgreSQL sources.
  • Validate data, reconcile figures, and maintain data dictionaries and report catalogs.

Skills

Power BI
DAX
Power Query (M)
SQL
Data modeling
Data quality
KPIs
Stakeholder comms
Self-motivation

Education

Bachelor's degree

Tools

Azure Databricks
PostgreSQL
Power BI administration

Job description

This position is listed on behalf of a partner company, which manages all applications and next steps. Our partner is looking for a Data Analyst (Power BI & Data Modeling) based in the United States.This fully remote opportunity is ideal for a data analyst who enjoys turning complex business and platform data into reliable insights that support better decisions. You will own the development and maintenance of Power BI dashboards, reports, and the underlying data models used across business and operational teams. Working with data from Azure Databricks, SQL, and PostgreSQL sources, you will create well-structured, documented datasets and consistent performance metrics. You will partner with stakeholders to translate business questions into meaningful KPIs, self-service reporting, and targeted analysis. A key part of the role is establishing trusted, consistent definitions of business metrics while improving data quality and reducing reliance on engineers for ad hoc reporting. Your work will help teams access accurate information, monitor performance, and make faster, data-informed decisions.

Accountabilities
  • Power BI reporting and dashboard development
    • 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 across the organization.
    • Manage Power BI workspaces, publishing processes, refresh schedules, data gateways, and row-level security.
  • Data modeling and transformation
    • Design and maintain dimensional and semantic data models using star-schema architecture, including fact and dimension tables.
    • Define appropriate data granularity, relationships, and structures to support consistent and scalable reporting.
    • Create and maintain DAX measures and Power Query (M) transformations, ensuring calculations and business definitions are documented and consistently applied.
    • Work with data from Azure Databricks, SQL, and PostgreSQL sources to build clean, reusable datasets.
  • Data quality and metric governance
    • Reconcile reported figures against source systems and investigate discrepancies before they affect business reporting.
    • Identify and resolve data-quality issues, ensuring dashboards and analytical outputs are accurate and trustworthy.
    • Maintain a data dictionary and report catalog to document datasets, measures, definitions, and reporting assets.
    • Establish consistent definitions of key business metrics across teams.
  • Business analysis and stakeholder collaboration
    • Gather reporting requirements and translate ambiguous business questions into clearly defined metrics and KPIs.
    • Produce ad hoc analysis to address specific business and operational questions.
    • Present findings and explain analytical results to non-technical stakeholders.
    • Support month-end and other periodic reporting cycles, helping ensure timely and consistent delivery.
Requirements
  • Bachelor's degree or international equivalent is required.
  • Demonstrated experience designing and maintaining Power BI reports and dashboards.
  • Strong practical knowledge of:
    • DAX: Creating and maintaining measures and calculations.
    • Power Query (M): Transforming and preparing data for reporting.
    • Power BI administration: Configuring 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 for self-service reporting.
  • Strong SQL skills, including the ability to write and optimize queries using joins, aggregations, and window functions against relational databases.
  • Strong analytical skills, with the ability to translate unclear business questions into measurable KPIs and actionable insights.
  • Experience validating data, reconciling reported figures against source systems, and investigating data-quality issues.
  • Ability to define metrics consistently and maintain clear documentation, including data dictionaries and report catalogs.
  • Effective communication and presentation skills, particularly when explaining data and analytical findings to non-technical audiences.
  • Self-motivated, detail-oriented, and comfortable working independently as well as collaboratively with cross-functional teams.
Preferred Qualifications
  • Experience in finance or financial services, including working with revenue, cost, billing, anti-money laundering (AML), or compliance data.
  • Familiarity with Azure Databricks and Spark SQL.
  • Experience using Python for data analysis.
  • Knowledge of Git and version control practices.
  • Experience working with large-scale or regulated datasets.
Benefits
  • Work arrangement: Fully remote position for candidates based in the United States.
  • Employment type: Employee position.
  • Technical ownership: Opportunity to take ownership of Power BI reporting, semantic data models, and consistent business-wide metrics.
  • Cross-functional impact: Work directly with business, operations, and leadership stakeholders to improve reporting and decision-making.
  • Data platform exposure: Work with data from Azure Databricks, SQL, and PostgreSQL environments.
  • Professional scope: Opportunity to establish trusted self-service reporting practices and reduce the burden of recurring ad hoc reporting.
  • Compensation and additional benefits: Salary range, healthcare coverage, retirement plans, paid leave, and other employee benefits are not specified in the job description.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst (Power BI & Data Modeling)
Data Analyst (Power BI & Data Modeling)

Job Envoy • United States

Remote
USD 70,000 - 120,000
Data Analyst (Power BI & Data Modeling)
Data Analyst (Power BI & Data Modeling)

K2 Integrity • New York (NY)

Remote
USD 75,000 - 110,000
Data Analyst (Power BI & Data Modeling)
Data Analyst (Power BI & Data Modeling)

K2 Integrity • United States

Remote
USD 85,000 - 120,000
Senior Power BI Developer
Senior Power BI Developer

Jobgether • Oregon

Hybrid
USD 41,000 - 55,000
Senior Power BI Analytics Engineer – Remote (US)
Senior Power BI Analytics Engineer – Remote (US)

aspenviewtech • United States

Remote
USD 120,000 - 180,000
Power BI Developer1
Power BI Developer1

Cooperdyne Tech • United States

Remote
USD 100,000 - 170,000
Competitive salary
Comprehensive health benefits
Paid time off
+2
Senior Power BI & Data Analyst
Senior Power BI & Data Analyst

Network-Wireless-Solutions • Myrtle Point (OR)

On-site
USD 110,000 - 160,000
Senior Power BI & Data Analyst
Senior Power BI & Data Analyst

Network Wireless Solutions • Oregon

Hybrid
USD 120,000 - 150,000
Senior Data Analyst
Senior Data Analyst

Kake Group • United States

Remote
USD 120,000 - 160,000
Senior Power BI Developer & Analytics Engineer
Senior Power BI Developer & Analytics Engineer

DiligenceVault • New York (NY)

Hybrid
USD 120,000 - 180,000