Senior Power BI Developer/Data Analyst (15-Month Contract)

The Midtown Group

1 month ago

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Working hours

Shift work

Languages

English

Experience level

Senior

Compensation

$ 114K

Job location

Remote

Tech stack

Artificial Intelligence

Data analysis

Azure

Databases

Information Engineering

Data Governance

Data Systems

Software Debugging

PostgreSQL

Microsoft SQL Server

Oracle Applications

Performance Tuning

Power BI

SQL Databases

Generative AI

Backend

Star Schema

GPT

Job description

We are looking to hire a Senior Power BI Developer / Data Analyst. This team handles highly sensitive, high-visibility data related to medical residencies and fellowships.

We are not just looking for a dashboard designer. We need a true "Full-Stack" Data Professional-a fixer who can act as a heavy-hitting backend analyst (Oracle/Postgres) while simultaneously optimizing complex semantic models to rescue slow, bloated Power BI reports.

The Challenge:

The team is currently dealing with critical executive dashboards that take several minutes to render. We need an expert who knows how to look under the hood using Performance Analyzer and DAX Studio, optimize the semantic layer, push transformations back to the database, and get load times down to seconds.

What You Will Do:

Performance Optimization: Audit, troubleshoot, and rebuild existing Power BI dashboards to drastically reduce rendering times and improve user experience.
Backend Data Analysis (40% of the role): Act as the backup data analyst for the team, spending a significant portion of your week writing, reading, and natively optimizing raw SQL queries.
Semantic Modeling: Build highly efficient, lightweight Star Schemas from scratch out of massive Oracle and PostgreSQL databases.
Data Governance: Implement strict Dynamic Row-Level Security (RLS) to ensure highly sensitive medical data is locked down and only viewed by permitted users.
Stakeholder Partnership: Act as a consultative "go-getter." Don't just take orders-work directly with Directors and Relationship Managers to understand the why behind their requests and guide them toward the best data solutions.

Requirements

Do you have experience in Star schema?, * 7+ years of hands-on experience in Business Intelligence and Data Engineering/Analysis.

Deep Oracle & PostgreSQL Expertise: You must be completely comfortable natively querying and tuning execution plans in Oracle and Postgres. (If your background is 100% Microsoft SQL Server/Azure, this role will not be a fit).
Advanced Power BI Architecture: Proven track record of fixing slow dashboards, utilizing calculation groups, iterator functions, and building clean 1-to-many dimensional models.
Timezone Commitment: You must be online and available strictly from 8:00 AM to 4:00 PM Eastern Standard Time, Monday through Friday.

IMPORTANT: The Interview Process & "No-AI" Policy

This client requires candidates who can natively code from memory. The interview process includes a live, on-screen technical review where you will be required to verbally read, write, and debug raw SQL and DAX. The use of ChatGPT, Microsoft Copilot, or any other Generative AI tools is strictly prohibited during the interview and in your day-to-day coding for this role. If you rely on AI to write your complex DAX or SQL, you will not pass the technical screen.