Senior BI Analyst

OVERVIEW

Our client is seeking an experienced Senior BI Analyst with deep hands-on expertise in data modeling, SQL, Power Query, and DAX to support Corporate Finance initiatives. This role requires someone who can independently design, build, and optimize Power BI data models and dashboards— not someone who has only partnered with or overseen data modeling work.

The successful candidate will collaborate closely with cross-functional partners including Business Intelligence, Data Science, Finance, Treasury, and Operations to translate business needs into scalable analytical solutions, define KPIs, and drive data-informed decision‑making.

This role is ideal for a proactive, detail‑oriented data professional who thrives in structured environments, enjoys bridging technical and business requirements, and can independently lead analytics initiatives from concept to delivery.

Location : Chicago, IL (Hybrid – 2–3 days in office)

Contract Length : 6 Months (Extension Possible)

Hours : 9 AM–5 PM CST

RESPONSIBILITIES

• Elicit, document, and validate data and analytics requirements from Finance, Operations, Treasury, and other stakeholders.
• Translate business objectives into actionable analytical solutions, metrics, and data models.
• Design, develop, and maintain end‑to‑end data models , including schema design, relationships, measures, and calculated columns using Power Query (M) and DAX .
• Build, optimize, and document Power BI dashboards , SQL queries, and analytical workflows.
• Conduct data preparation, cleansing, refinement, and transformation for high‑quality reporting.
• Define new KPIs and lead analysis to provide strategic insights and recommendations to business leaders.
• Present analytical findings in ad‑hoc and routine business reviews to Senior Leadership.
• Conduct performance tuning on Power BI datasets, reports, and underlying SQL queries to ensure reliability and scalability.
• Collaborate with Data and Software Engineers to interpret ETL pipelines, identify upstream changes, and ensure data accuracy.
• Partner with Data Scientists to design new metrics and analytical frameworks.
• Lead analytics projects end‑to‑end, managing requirements, timelines, and stakeholder alignment.
• Identify data gaps and propose enhancements to support improved decision‑making and business growth.
• Ensure alignment with enterprise data governance, quality, and security standards.

QUALIFICATIONS

Hands‑on expertise :

PREFERRED

EDUCATION

Post‑secondary degree in a quantitative discipline (e.g., Data Science, Statistics, Mathematics, Engineering, Finance, Computer Science) or related field.

NOTES FOR APPLICATIONS

Resumes must clearly demonstrate hands‑on data modeling experience , including explicit examples of building Power BI data models, writing complex DAX, and using Power Query (M).

Candidates who worked adjacent to data modeling or managed teams without building models themselves will not be considered .

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, disability status, or other non‑merit factor. We are committed to creating a diverse and inclusive environment for all employees.

#J-18808-Ljbffr