Data Analyst (Power BI & Data Modeling)

Posted An Hour Ago
Hiring Remotely in United States
Remote
Entry level
Business Intelligence • Consulting
The Role
Owns Power BI reporting and dimensional data models, developing dashboards, KPIs, DAX measures, Power Query transformations, and self-service analytics. Reconciles data, resolves quality issues, maintains documentation, configures refreshes and security, and supports reporting cycles. Partners with stakeholders to define metrics, answer business questions, and present findings. Finance or regulated-data experience is preferred.
Summary Generated by Built In
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 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.

Skills Required

  • Bachelor's degree or international equivalent
  • Power BI report and dashboard design, including DAX, Power Query, refresh and gateway setup, row-level security, and workspace management
  • Dimensional or star-schema data modeling, including fact and dimension design, granularity, relationships, and semantic models
  • Strong SQL, including joins, aggregations, and window functions
  • Ability to translate business questions into metrics, validate data, and present findings to non-technical stakeholders
  • Data quality reconciliation, consistent measure definitions, and data dictionary maintenance
  • Effective communication and presentation skills; self-starting, detail-oriented, and able to work independently and collaboratively
  • Finance or financial-services domain experience
  • Databricks or Spark SQL experience
  • Python for analysis
  • Git version control
  • Experience working with large or regulated datasets
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: New York, NY
276 Employees
Year Founded: 2009

What We Do

K2 Integrity is the preeminent risk, compliance, investigations, and monitoring firm—built by industry leaders, driven by interdisciplinary teams, and supported by cutting-edge technology to safeguard our clients’ operations, reputations, and economic security. K2 Integrity represents the merger of K2 Intelligence, an industry-leading investigative, compliance, and cyber defense services firm founded in 2009 by Jeremy M. Kroll and Jules B. Kroll, the originator of the modern corporate investigations industry, and Financial Integrity Network (FIN), a premier strategic advisory firm founded by Juan Zarate and Chip Poncy dedicated to helping clients achieve their financial integrity goals. K2 Integrity leverages unmatched multidisciplinary experience to develop cutting-edge solutions, stimulate business opportunities, and shape global economic security in a complex world. Whether it’s protecting clients’ assets or navigating the complex financial regulatory landscape to help clients identify, manage, and mitigate risk, K2 Integrity is an advisor trusted to meet and exceed clients’ goals in a rapidly changing world. To learn more about how K2 Integrity is revolutionizing the management of risk, visit our website, www.k2integrity.com.

Similar Jobs

Circle (circle.so) Logo Circle (circle.so)

Operations Coordinator

Artificial Intelligence • Consumer Web • Digital Media • Information Technology • Social Impact • Software
Remote
32 Locations
250 Employees

Zscaler Logo Zscaler

Senior Manager, Content & Operations, Global Customer Advocacy

Cloud • Information Technology • Security • Software • Cybersecurity
Easy Apply
Remote or Hybrid
USA
8697 Employees
151K-215K Annually

Zeta Global Logo Zeta Global

Director, Political Partnerships

AdTech • Artificial Intelligence • Marketing Tech • Software • Analytics
Easy Apply
Remote or Hybrid
District of Columbia, USA
2429 Employees
150K-300K Annually

GameChanger Logo GameChanger

Principal Software Engineer

Computer Vision • Digital Media • Kids + Family • Mobile • Software • Sports
Remote
United States
260 Employees
210K-230K Annually

Similar Companies Hiring

Compa Thumbnail
Artificial Intelligence • HR Tech • Software • Business Intelligence
Irvine, California
94 Employees
Quanta Thumbnail
Artificial Intelligence • Fintech • Software • Business Intelligence • Big Data Analytics
San Francisco, California
23 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account