BI Analytics Analyst- Contractor

Park Place Technologies

Highland Heights (OH)

Hybrid

USD 65,000 - 95,000

Full time

24 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Park Place Technologies is hiring a BI Analytics Analyst in Highland Heights, OH for a hybrid, full-time role focused on designing, building, and maintaining semantic models and Power BI content that empower enterprise decision making. You will support data pipelines, ETL/ELT processes, and ensure trusted data for performance evaluation.

You will collaborate with Business Analysts and Data Engineers to deliver certified content, optimize reports, and maintain data governance practices while

Qualifications

  • 2+ years of experience developing Power BI reports and semantic models, including DAX measures and Power Query.
  • Proven ability to design a dimensional star schema and write performant DAX with time intelligence.
  • 2+ years SQL experience in data engineering.
  • 2+ years Python in data engineering (spark, pandas).
  • ETL/ELT concepts and relational databases.
  • Experience supporting production pipelines in a ticket-driven environment.
  • Understanding of the Software Development Life Cycle (SDLC).
  • Bachelor's Degree or relevant certifications & equivalent years of experience.

Responsibilities

  • 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 promoted through development, test, and production deployment pipelines.
  • Apply sensitivity labels and maintain lineage, certification, and documentation in line with enterprise data governance standards.
  • Collaborate 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.

Skills

Power BI
DAX measures
Power Query
SQL
Python
ETL/ELT
Dimensional modeling
Time intelligence
Root cause analysis
SDLC
Performance tuning

Education

Bachelor's degree

Tools

Azure DevOps
Git
DAX Studio
Tabular Editor
Power BI Service

Job description

Cleveland Headquarters Office
Highland Heights, OH 44143, USA

Locations

Showing 1 location Cleveland Headquarters Office
Highland Heights, OH 44143, USA

  • Hybrid
  • IT/IS
  • Full-Time
  • Requisition #: BIANA006733
Description

BI Analytics Analyst

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:

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

Basic Qualifications:

  • 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

Preferred Qualifications:

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

Travel:

  • <10%

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

BI Developer
BI Developer

Brixmor Property Group • False Pass (AK)

On-site
USD 90,000 - 140,000
PowerBI Developer
PowerBI Developer

Career Techniques • Conshohocken

On-site
USD 85,000 - 120,000
Sr. Software Engineer - Analytics Engineering
Sr. Software Engineer - Analytics Engineering

SHI International • Somerset (NJ)

On-site
USD 125,000 - 140,000
Health, wellness, and financial ben­ef
Office or remote work options
Business Intelligence Analyst / Data Engineer
Business Intelligence Analyst / Data Engineer

GEICO • Bethesda (MD)

On-site
USD 91,000 - 172,000
Competitive pay
Benefits
Flexibility
+1
Sr. BI Developer - Finance & Accounting
Sr. BI Developer - Finance & Accounting

LJA, Inc. / LJA Services, Inc. • Houston (TX)

On-site
USD 120,000 - 150,000
Analytics Engineer
Analytics Engineer

DEXTER TECHNOLOGIES INC • Houston (TX)

Hybrid
USD 90,000 - 130,000
Flexible work from home options
BI Developer
BI Developer

Premier Nutrition • Emeryville (CA)

Hybrid
USD 120,000 - 140,000
Data Analyst (Power BI & Data Modeling)
Data Analyst (Power BI & Data Modeling)

Jobgether • United States

Remote
USD 85,000 - 120,000
Business Systems Analyst
Business Systems Analyst

i-PRO University • Houston (TX)

Hybrid
USD 85,000 - 115,000
Business Intelligence Developer
Business Intelligence Developer

eNGINE • Pennsylvania

On-site
USD 120,000 - 180,000