Logo for K2 Integrity

Data Analyst (Power BI & Data Modeling)

Role overview

Summary

This role is for a Data Analyst focused on Power BI and data modeling at the company. You will design and maintain reporting tools and data models that facilitate data-driven decisions for business and operations stakeholders.

Qualifications

  • Bachelor’s degree or international equivalent.
  • Power BI report and dashboard design, including DAX measures and Power Query.
  • Dimensional / star-schema data modeling experience.
  • Strong SQL skills for writing and optimizing queries.
  • Effective communication and presentation skills.

Responsibilities

  • Build and maintain Power BI dashboards and reports for stakeholders.
  • Design and maintain dimensional data models that support self-service reporting.
  • Author and maintain DAX measures and Power Query transformations with documented definitions.
  • Gather requirements from stakeholders and translate business questions into metrics and KPIs.

Key facts

Hard skills

Key skills for this role

Other skills

  • Analytical Skills
  • Communication
  • Presentations
  • Detail Oriented
  • Teamwork

About the company

K2 Integrity logo

K2 Integrity

  • Management Consulting
  • 201–500
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.

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

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.
 
 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.

Related jobs

See all Data Analyst jobs

Other jobs at K2 Integrity