Data Analyst (Power BI & Data Modeling)

K2 Integrity

New York (NY)

Remote

USD 75,000 - 110,000

Full time

3 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

K2 Integrity is seeking a Data Analyst (Power BI & Data Modeling) to own the design, build, and maintenance of our Power BI reporting and the underlying data models across Azure Databricks / SQL / Postgres sources. You will create self-service dashboards, KPIs, and ad hoc analysis for business and operations stakeholders, delivering trustworthy reporting and a single definition of key metrics.

The role is remote within the USA, with responsibilities spanning data modeling, DAX measures, data

Qualifications

  • Bachelor’s degree or international equivalent is required.
  • Proficient in Power BI design, DAX, and Power Query.
  • Strong SQL skills across relational sources.
  • Experience with star-schema data modeling.
  • Ability to translate business questions into metrics.
  • Experience with finance or AML data preferred.
  • Excellent communication and presentation skills.

Responsibilities

  • Build and maintain Power BI dashboards and reports.
  • Design dimensional data models to power self-service reporting.
  • Develop DAX measures and M transformations with documentation.
  • Reconcile figures to source systems and fix data quality issues.
  • Gather stakeholder requirements and translate into metrics and KPIs.
  • Provide ad hoc analysis for business and operations.
  • Maintain data dictionary, catalogs, refresh schedules, gateways, and row-level security.
  • Support month-end and periodic reporting cycles.

Skills

Power BI
DAX measures
Power Query
Star schema
SQL
Analytical mindset
Data quality
Communication
Finance domain
Databricks Spark
Python
Git

Education

Bachelor's degree

Tools

Power BI
Databricks
Git
Python
SQL Server

Job description

Job Summary

We are seeking a Data Analyst (Power BI & Data Modeling) to own the design, build, and maintenance of our Power BI reporting and the underlying data models that turn platform and business data into decisions. Working across the data platform (Azure Databricks / SQL / Postgres sources), you will model clean, well-documented datasets and deliver self-service dashboards, KPIs, and ad hoc analysis for business and operations stakeholders. This role is the dedicated owner of trustworthy self-service reporting and a single, consistent definition of key metrics across the business — enabling faster, data-driven decisions and reducing the ad hoc reporting burden currently carried by engineers and analysts.

Job Summary

This is a remote role in the USA.

Job Responsibilities
  • Build and maintain Power BI dashboards and reports for business, operations, and leadership stakeholders.
  • Design and maintain dimensional / semantic data models (star schema — facts and dimensions) that power self-service reporting.
  • Author and maintain DAX measures and Power Query (M) transformations with consistent, documented definitions.
  • Reconcile reported figures back to source systems and resolve data-quality issues before they reach reports.
  • Gather requirements from stakeholders and translate ambiguous business questions into clear metrics and KPIs.
  • Produce ad hoc analysis to answer specific business and operational questions.
  • Maintain a data dictionary and report catalog; configure refresh schedules, gateways, and row-level security.
  • Support month-end and periodic reporting cycles.
Job Qualifications
  • Bachelor’s degree or international equivalent is required.
  • Power BI report and dashboard design, including DAX measures, Power Query (M), data refresh and gateway setup, row-level security, and workspace / publishing management.
  • Dimensional / star-schema data modeling: fact and dimension design, managing granularity and relationships, and building semantic models for self-service reporting.
  • Strong SQL: writing and optimizing queries (joins, aggregations, window functions) against relational sources.
  • Strong analytical mindset: translating ambiguous business questions into metrics, validating data, and presenting clear findings to non-technical stakeholders.
  • Data quality and documentation: reconciling figures to source, defining measures consistently, and maintaining a data dictionary.
  • Effective communication and presentation skills; self-starting, detail-oriented, and able to work both independently and as part of a team.
  • Finance / financial-services domain experience (reading revenue, cost, billing, or AML / compliance data) preferred.
  • Databricks / Spark SQL, Python for analysis, and Git version control preferred.
  • Experience working with large or regulated datasets preferred.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Power BI Analytics Engineer – Remote (US)
Senior Power BI Analytics Engineer – Remote (US)

aspenviewtech • United States

Remote
USD 120,000 - 180,000
Data Analyst
Data Analyst

Vital Study Skills • Houston (TX)

On-site
USD 65,000 - 95,000
Senior Data Analyst
Senior Data Analyst

Kake Group • United States

Remote
USD 120,000 - 160,000
PowerBI Developer
PowerBI Developer

Career Techniques • Conshohocken

On-site
USD 85,000 - 120,000
Senior Power BI Developer & Analytics Engineer
Senior Power BI Developer & Analytics Engineer

DiligenceVault • New York (NY)

Hybrid
USD 120,000 - 180,000
Senior Power BI Developer: DAX, Modeling & Azure Data
Senior Power BI Developer: DAX, Modeling & Azure Data

Compunnel Inc. • Pennsylvania

On-site
USD 90,000 - 120,000
Senior Power BI Developer
Senior Power BI Developer

DCS Corporation • Alexandria (VA)

Remote
USD 100,000 - 135,000
Power BI & SSRS Business Intelligence Developer Data Infrastructure · Remote (US) · Full-time Posted 2026-05-11
Power BI & SSRS Business Intelligence Developer Data Infrastructure · Remote (US) · Full-time Posted 2026-05-11

CYFR Technologies, Inc. • United States

Remote
USD 90,000 - 120,000
Data Analytics Developer
Data Analytics Developer

Trinity Consultants • Dallas (TX)

On-site
USD 90,000 - 140,000
ETL Developer / Power BI
ETL Developer / Power BI

247Hire • Burbank (CA)

On-site
USD 100,000 - 130,000