Discover your dream Career
For Recruiters

Data Analyst (Power BI & Data Modeling)

K2 Integrity New York, United States
Posted 1 day ago Permanent Competitive

Data Analyst (Power BI & Data Modeling)

K2 Integrity New York, United States
Data Analyst (Power BI & Data Modeling)
Job description

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.

This is a remote role in the USA.

Job requirements

  • 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 responsibilities

  • 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.
Job ID  091fce4f-dd70-4906-b829-ddce6ed761b3
More Jobs From K2 Integrity
Contract Financial Crime Data Analyst
K2 Integrity
New York, United States
2 days ago Full time Competitive
Senior Software Engineer
K2 Integrity
New York, United States
1 day ago Full time Competitive
Business Development Specialist
K2 Integrity
New York, United States
15 days ago Full time Competitive
Technical Account Executive
K2 Integrity
New York, United States
18 days ago Full time Competitive
Security Consultant - Hardware Specialist
K2 Integrity
New York, United States
18 days ago Full time Competitive
Senior Associate, Investigations and Disputes
K2 Integrity
New York, United States
1 month ago Full time Competitive

Boost your career

Find thousands of job opportunities by signing up to eFinancialCareers today.
More Jobs Like This
Prudential Financial, Inc.
PGIM Real Estate - Analyst/Associate, Data Analytics & Governance
Prudential Financial, Inc.
Newark, United States
Blackstone
AI Engineer, Analyst - Data Analytics & AI
Blackstone
New York, United States
Herbert Smith Freehills LLP
Analyst, Client & Matter Data Assurance
Herbert Smith Freehills LLP
New York, United States