Data Analyst (Power BI & Data Modeling)
United States2h ago
Key details
- Location
- United States
- Work style
- Remote
- Job type
- Full-time
- Function
- Data & ML
- Focus area
- Data engineering & Analytics
- Posted
- 2h ago
Skills
About the role
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.
-
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.
-
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.
-
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.
Requirements
Preferred qualifications:
Benefits
How well do you match this job?
Free account needed to apply or save. It takes a minute, and we'll bring you right back to this job.