BI Analytics Analyst- Contractor

AnalyticsData & AI
3 views0 saves0 applied

Quick Summary

Key Responsibilities

Power BI & Semantic Model Development Design, build, and maintain enterprise semantic models — star schema design, grain, relationships, hierarchies,

Technical Tools
AnalyticsData & AI

The BI Analytics Analyst is responsible for designing, building, and maintaining the semantic models and Power BI content that make enterprise data usable by the business, and for supporting the data pipelines and ETL/ELT processes those models depend on. The role pairs report and semantic model development with day-to-day production support of the data platform; trusted, certified and performant data is the ultimate goal, which enables our organization to utilize data for performance evaluation and optimization.

 

Responsibilities

~3 min read
  • →Power BI & Semantic Model Development
    • →Design, build, and maintain enterprise semantic models — star schema design, grain, relationships, hierarchies, and conformed dimensions — over the Data Warehouse and Data Lakehouse layers.
    • →Select and implement the appropriate storage mode (Import, DirectQuery, Direct Lake, or composite) and configure incremental refresh and aggregations to meet performance and data latency requirements.
    • →Author and maintain DAX measures, calculation groups, and time intelligence logic, applying row and filter context correctly and documenting measure definitions.
    • →Develop Power Query (M) transformations that preserve query folding and align with established modeling standards.
    • →Design, develop, and publish Power BI reports, dashboards, and paginated reports that meet enterprise visualization, usability, and accessibility standards.
    • →Tune model and report performance using Performance Analyzer, DAX Studio, Tabular Editor, and VertiPaq Analyzer; remediate slow refreshes, oversized models, and inefficient measures.
    • →Implement row-level and object-level security in line with data governance and access standards.
  • →Power BI Service & Platform Administration
    • →Administer workspaces, apps, and content distribution; manage dataset endorsement and certification so the business consumes governed, reusable models.
    • →Manage scheduled refreshes, dataflows, and on-premises data gateway connections and credentials; monitor and remediate refresh failures.
    • →Monitor capacity utilization, refresh windows, and model size against licensed capacity, escalating and remediating constraints.
    • →Manage the BI release process — model and report artifacts in source control (PBIP/TMDL via Git) promoted through development, test, and production deployment pipelines.
    • →Apply sensitivity labels and maintain lineage, certification, and documentation in line with enterprise data governance standards.
  • →Data Engineering & Production Support
    • →Implement and maintain pipelines that move raw data into the data platform using spark, python, SQL and C# in line with well-established architectural standards related to Data Warehouse and Data Lakehouse modeling standards.
    • →Build and support ETL/ELT processes that produce curated, analytics-ready datasets.
    • →Serve on the Data Engineering support rotation: work the intake queue, resolve incidents within established service levels, and escalate along the defined path.
    • →Troubleshoot pipeline, orchestration, and refresh failures — dependency and scheduling errors, source system changes, re-runs and backfills — to restore service.
    • →Triage and troubleshoot perceived data aberrations submitted by the user community, performing root cause analysis and documenting findings.
    • →Implement and maintain data quality, validation, monitoring, and alerting capabilities to ensure data integrity and reliability.
    • →Contribute to runbooks, data flow and schema documentation, and change management records.
    • →Employ Azure Devops and Git in line with the Software Development Life Cycle best practices.
  • →Collaboration & Business Enablement
    • →Partner with business stakeholders, Business Analysts, and Data Analysts to elicit, clarify, and prioritize reporting requirements.
    • →Act as a liaison with Business Analysts and Testing teams to promote smooth development execution, and support user acceptance testing of reports and models.
    • →Maintain the reporting backlog, enable and train users on certified content, and retire or consolidate redundant reports.
    • →Partner with Data Engineering, Data Modeling, Governance, and Architecture teams to keep semantic models aligned to the enterprise data model and governance standards.
  • →Other duties as assigned.

 

Requirements

~2 min read
  • 2+ years of practical or collegiate experience (or equivalent) developing Power BI reports and semantic models, including DAX measures and Power Query (M) transformations.
  • Demonstrated ability to design a dimensional (star schema) model and author performant DAX, including time intelligence and correct use of row and filter context.
  • 2+ years of practical or collegiate experience (or equivalent) in SQL related to data engineering (or equivalent collegiate experience / certifications).
  • 2+ years of practical or collegiate experience (or equivalent) in Python related to data engineering (spark, pandas, etc).
  • Working knowledge of ETL/ELT concepts, dimensional and relational data modeling, and relational databases.
  • Experience supporting production pipelines or reporting in a ticket-driven support environment, including incident triage and root cause analysis.
  • Solid understanding of the Software Development Life Cycle.
  • Motivated individual looking to expand their knowledge in all areas of Business Intelligence, Data Engineering, Analytics and AI.
  • Bachelor’s Degree or Relevant Certifications & equivalent years of experience

 

  • Microsoft Certified: Power BI Data Analyst Associate (PL-300)
  • Microsoft Cloud Certification (Azure or Microsoft Fabric)
  • Experience with Microsoft Fabric — OneLake, Lakehouse/Warehouse, and Direct Lake semantic models.
  • Experience with Power BI application lifecycle management: PBIP/TMDL in source control, deployment pipelines, and Tabular Editor.
  • Experience administering the Power BI Service: capacity monitoring, gateways, and workspace and app lifecycle.
  • Experience with data governance tooling (Microsoft Purview): lineage, sensitivity labels, and asset certification.
  • Experience with orchestration tooling (Azure Data Factory, Synapse Pipelines, or Fabric Data Factory).
  • Familiarity with Machine Learning and AI, including surfacing model output in BI content.

 

  • <10%

Location & Eligibility

Where is the job
United States
Hybrid within the country
Who can apply
US

About this job

Who can apply
United States
Posted
Today
Employer
has 78 open jobs on Jobera in 13 countries.

Listing Details

Posted
November 18, 2026
First seen
November 18, 2026
Last seen
November 18, 2026

Posting Health

Days active
0
Repost count
0
Trust Level
58%
Scored at
November 18, 2026

Signal breakdown

freshnesssource trustcontent trustemployer trust

4 other jobs at

View all →

Explore open roles at .

Newsletter

Stay ahead of the market

Get the latest job openings, salary trends, and hiring insights delivered to your inbox every week.

A
B
C
D
Join 12,000+ marketers

No spam. Unsubscribe at any time.

BI Analytics Analyst- Contractor