Data Analyst (Power BI & Data Modeling)

Job Envoy

United States

Remote

USD 70,000 - 120,000

Full time

2 days 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

Job Envoy is partnering to hire a Data Analyst (Power BI & Data Modeling) for a fully remote position based in the United States. You will own development and maintenance of Power BI dashboards, self-service reporting, and underlying data models using Azure Databricks, SQL, and PostgreSQL to deliver reliable insights across business and operational teams.

You will establish trusted definitions of metrics, ensure data quality, and partner with stakeholders to translate questions into KPIs while

Qualifications

  • Bachelor's degree or international equivalent is required.
  • Demonstrated experience designing and maintaining Power BI reports and dashboards.
  • Strong practical knowledge of DAX and Power Query.
  • Power BI administration: refresh schedules, gateways, RLS, workspaces, publishing workflows.
  • Experience designing dimensional and star-schema data models with fact and dimension tables.
  • Strong SQL skills with joins, aggregations, and window functions.
  • Ability to translate business questions into KPIs and actionable insights.
  • Experience validating data and reconciling figures against sources.

Responsibilities

  • Power BI reporting and dashboard development for business, operational, and leadership stakeholders.
  • Develop self-service reporting solutions for reliable data and KPIs.
  • Manage Power BI workspaces, refresh schedules, gateways, RLS, and publishing workflows.
  • Data modeling and transformation using star-schema architecture.
  • Create and maintain DAX measures and Power Query transformations.
  • Work with Azure Databricks, SQL, and PostgreSQL to build clean, reusable datasets.
  • Ensure data quality and govern metrics across reports and datasets.
  • Translate stakeholder questions into clearly defined metrics and KPIs.
  • Produce ad hoc analysis to address business questions.
  • Present findings to non-technical stakeholders and support period-end reporting.

Skills

Power BI reporting
DAX
Power Query
SQL
Data modeling
Data quality
Stakeholder communication
Ad hoc analysis

Education

Bachelor's degree

Tools

Azure Databricks
Spark SQL
Git
Python

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)

Jobgether • United States

Remote
USD 85,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
Senior Power BI Developer & Analytics Engineer
Senior Power BI Developer & Analytics Engineer

DiligenceVault • New York (NY)

Hybrid
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
Data Analyst
Data Analyst

Amplytico Inc. • San Francisco (CA)

Hybrid
USD 90,000 - 135,000
Hybrid work model
Data Analyst
Data Analyst

Vital Study Skills • Houston (TX)

On-site
USD 65,000 - 95,000
Data Analytics Developer
Data Analytics Developer

Trinity Consultants • Dallas (TX)

On-site
USD 90,000 - 140,000